INV Cycle count listing (1)

Description
Categories: BI Publisher, Logistics
Application: Inventory
Source: Cycle count listing (XML)
Short Name: INVARCLI_XML
DB package: INV_INVARCLI_XMLP_PKG
select  
       cce.count_list_sequence,
       cce.inventory_item_id,
       sys.description  Description,
       cce.subinventory                       Subinventory,
       cce.revision                               Revision,
       cce.lot_number                         LotNumber,
       cce.locator_id                          Locator ,
       cce.count_due_date                  DueDate,
      abc.abc_class_name,
        sys.primary_uom_code            uom,
        mfg1.meaning                         Reason,
       null    C_LOCATOR_FLEXDAT,
       &P_ITEM_FLEXSQL             C_ITEM_FLEXDAT,
       CYCLE_COUNT_ENTRY_ID CYCLE_COUNT_ENTRY_ID1,
       SERIAL_DETAIL,
       SERIAL_NUMBER,
       SERIAL_NUMBER_CONTROL_CODE,
       SERIAL_COUNT_OPTION,
       EXPORT_FLAG,
       cch.container_enabled_flag,
       cce.outermost_lpn_id,
       cce.parent_lpn_id,
       cce.cost_group_id, 
	fnd_flex_xml_publisher_apis.process_kff_combination_1('f_item_flexval', 'INV', 'MSTK', 101, SYS.ORGANIZATION_ID, SYS.INVENTORY_ITEM_ID, 'ALL', 'Y', 'VALUE') F_Item_FlexVal, 
	fnd_flex_xml_publisher_apis.process_kff_combination_1('f_locator_value', 'INV', 'MTLL', 101, LOC.ORGANIZATION_ID, LOC.INVENTORY_LOCATION_ID, 'ALL', 'Y', 'VALUE') F_LOCATOR_VALUE, 
	INV_INVARCLI_XMLP_PKG.cf_sysqtyformula(SERIAL_NUMBER_CONTROL_CODE, SERIAL_COUNT_OPTION, cce.inventory_item_id, cce.subinventory, cce.lot_number, cce.revision, cce.locator_id, cce.parent_lpn_id, SERIAL_NUMBER) CF_SysQty, 
	INV_INVARCLI_XMLP_PKG.cf_outermost_lpnformula(cch.container_enabled_flag, cce.outermost_lpn_id) CF_OUTERMOST_LPN, 
	INV_INVARCLI_XMLP_PKG.cf_parent_lpnformula(cch.container_enabled_flag, cce.parent_lpn_id) CF_PARENT_LPN, 
	INV_INVARCLI_XMLP_PKG.cf_cost_groupformula(cce.cost_group_id) CF_COST_GROUP
from 
       mfg_lookups     mfg1,
       MTL_ITEM_LOCATIONS     LOC,
       mtl_abc_classes                abc,
       mtl_system_items_vl           sys, 
       mtl_cycle_count_headers   cch,
       mtl_cycle_count_items       cci,
       mtl_cycle_count_entries     cce
 where  sys.organization_id  = :P_ORG_ID
 and   cch.o