LEDG_LE_BU_INV_MFG_CST

-- Ledgers 
 SELECT LEDGER_ID, NAME, SHORT_NAME, DESCRIPTION, CURRENCY_CODE, CHART_OF_ACCOUNTS_ID, LEDGER_CATEGORY_CODE, PERIOD_SET_NAME 
 FROM GL_LEDGERS; 
  
 -- Legal Entities 
 SELECT DISTINCT 
     legEnt.name AS LE_NAME, 
     legEnt.LEGAL_ENTITY_ID, 
     legEnt.PARTY_ID, 
     legEnt.LEGAL_ENTITY_IDENTIFIER, 
     hou.name AS BU_NAME, 
     hou.organization_id AS BU_ID, 
     xlolv.ledger_id 
 FROM xle_entity_profiles legEnt, 
     hr_operating_units hou, 
     XLE_LE_OU_LEDGER_V xlolv 
 WHERE hou.DEFAULT_LEGAL_CONTEXT_ID(+) = legEnt.LEGAL_ENTITY_ID 
   AND legEnt.LEGAL_ENTITY_ID = xlolv.LEGAL_ENTITY_ID; 
  
 -- Cost Organizations 
 SELECT * FROM CST_COST_ORGS_V; 
  
 -- Business Units 
 SELECT bu.BU_ID, bu.BU_NAME, bu.SHORT_CODE, bu.DEFAULT_CURRENCY_CODE, bu.STATUS 
 FROM fun_all_business_units_v bu 
 WHERE STATUS = 'A'; 
  
 -- Inventory Organizations 
 SELECT HOU.ORGANIZATION_ID, HOU.NAME AS ORGANIZATION_NAME, MP.ORGANIZATION_CODE, LGR.LEDGER_ID AS SET_OF_BOOKS_ID, 
        LGR.CHART_OF_ACCOUNTS_ID, LGR.CURRENCY_CODE, LGR.PERIOD_SET_NAME, 
        DECODE(HOI1.STATUS,'A','Y','N') AS INVENTORY_ENABLED_FLAG, 
        BU.BU_NAME AS BUSINESS_UNIT_NAME, MP.BUSINESS_UNIT_ID, MP.LEGAL_ENTITY_ID AS LEGAL_ENTITY, HOU.TYPE AS ORGANIZATION_TYPE 
 FROM HR_ALL_ORGANIZATION_UNITS_X HOU, 
      HR_ORG_UNIT_CLASSIFICATIONS_X HOI1, 
      INV_ORG_PARAMETERS MP, 
      GL_LEDGERS LGR, 
      FUN_ALL_BUSINESS_UNITS_V BU 
 WHERE HOU.ORGANIZATION_ID = HOI1.ORGANIZATION_ID 
   AND HOU.ORGANIZATION_ID = MP.ORGANIZATION_ID 
   AND HOI1.CLASSIFICATION_CODE = 'INV' 
   AND BU.PRIMARY_LEDGER_ID = LGR.LEDGER_ID(+) 
   AND LGR.OBJECT_TYPE_CODE(+) = 'L' 
   AND NVL(LGR.COMPLETE_FLAG,'Y') = 'Y' 
   AND BU.BU_ID(+) = MP.BUSINESS_UNIT_ID 
 ORDER BY 3; 
  
 -- Manufacturing Organizations 
 SELECT HOU.ORGANIZATION_ID, HOU.NAME AS ORGANIZATION_NAME, MP.ORGANIZATION_CODE, LGR.LEDGER_ID AS SET_OF_BOOKS_ID, 
        LGR.CHART_OF_ACCOUNTS_ID, LGR.CURRENCY_CODE, LGR.PERIOD_SET_NAME, 
        DECODE(HOI1.STATUS,'A','Y','N') AS INVENTORY_ENABLED_FLAG, 
        BU.BU_NAME AS BUSINESS_UNIT_NAME, MP.BUSINESS_UNIT_ID, MP.LEGAL_ENTITY_ID AS LEGAL_ENTITY, HOU.TYPE AS ORGANIZATION_TYPE, 
        MP.MFG_PLANT_FLAG 
 FROM HR_ALL_ORGANIZATION_UNITS_X HOU, 
      HR_ORG_UNIT_CLASSIFICATIONS_X HOI1, 
      INV_ORG_PARAMETERS MP, 
      GL_LEDGERS LGR, 
      FUN_ALL_BUSINESS_UNITS_V BU 
 WHERE HOU.ORGANIZATION_ID = HOI1.ORGANIZATION_ID 
   AND HOU.ORGANIZATION_ID = MP.ORGANIZATION_ID 
   AND HOI1.CLASSIFICATION_CODE = 'INV' 
   AND BU.PRIMARY_LEDGER_ID = LGR.LEDGER_ID(+) 
   AND LGR.OBJECT_TYPE_CODE(+) = 'L' 
   AND NVL(LGR.COMPLETE_FLAG,'Y') = 'Y' 
   AND BU.BU_ID(+) = MP.BUSINESS_UNIT_ID 
   AND MP.MFG_PLANT_FLAG = 'Y' 
 ORDER BY 3;