INV Subinventory listing

Description
Categories: BI Publisher, Logistics
Application: Inventory
Source: Subinventory listing (XML)
Short Name: INVSRSUB_XML
DB package: INV_INVSRSUB_XMLP_PKG
select
       a.secondary_inventory_name  subinventory,
       a.description,
       a.disable_date,
         mfg1.meaning atp_code,
         mfg2.meaning avail_code,
         mfg3.meaning reservable_code,
         mfg4.meaning locator_type,
         mfg6.meaning  quantity_tracked,
         a.picking_order,
         a.material_account           material_account,
         null  c_material_account,
         a.material_overhead_account  material_burden,
         null   c_material_burden_flexdat,
         a.resource_account           resource_account,
         null          c_resource_flexdat,
         a.overhead_account           overhead_account,
         null      c_resource_ovh_flexdat,
         a.outside_processing_account value_added,
         null       c_value_added_flexdat,
         mfg5.meaning                 inventory_type,
         a.encumbrance_account        encumbrance_account,
         &P_encumbrance_FLEXSQL       c_encumbrance_flexdat,
         a.expense_account            expense_account,
         &P_expense_FLEXSQL           c_expense_flexdat,
         a.source_type                source_type_id,
         mfg7.meaning                 source_type_name,
         a.source_organization_id     source_org_id,
         o.organization_code          source_org_code,
         o.organization_name          source_org_name,
         a.source_subinventory        source_subinv,
         a.requisition_approval_type  req_apprv_id,
         mfg8.meaning                 req_apprv_name,
         mfg9.meaning        default_count_type,
         mfg10.meaning      planning_level,
	fnd_flex_xml_publisher_apis.process_kff_combination_1('f_encumbrance_flex', 'SQLGL', 'GL#', GLC_6.CHART_OF_ACCOUNTS_ID, NULL, GLC_6.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') F_ENCUMBRANCE_FLEX,
	fnd_flex_xml_publisher_apis.process_kff_combination_1('f_expense_flex', 'SQLGL', 'GL#', GLC_7.CHART_OF_ACCOUNTS_ID, NULL, GLC_7.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') F_EXPENSE_FLEX,
	fnd_flex_xml_publisher_apis.process_kff_combination_1('f_resource_flex', 'SQLGL', 'GL#', GLC_3.CHART_OF_ACCOUNTS_ID, NULL, GLC_3.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') F_RESOURCE_FLEX,
	fnd_flex_xml_publisher_apis.process_kff_combination_1('f_resource_ovh_flex', 'SQLGL', 'GL#', GLC_4.CHART_OF_ACCOUNTS_ID, NULL, GLC_4.CODE_COMBINATION_ID, 'ALL',</