INV Print Cycle Count Entries Open Interface data

Description
Categories: BI Publisher, Logistics
Application: Inventory
Source: Print Cycle Count Entries Open Interface data (XML)
Short Name: INVCCIER_XML
DB package: INV_INVCCIER_XMLP_PKG
SELECT  CC_ENTRY_INTERFACE_ID CC_ENTRY_INTERFACE_ID1,
               CYCLE_COUNT_HEADER_NAME,
               COUNT_LIST_SEQUENCE,
               ACTION_CODE,
               ML.MEANING ACTION_CODE_MEANING,
              fnd_flex_xml_publisher_apis.process_kff_combination_1('p_item_flexdata', 'INV', 'MSTK', 101, msi.ORGANIZATION_ID, msi.INVENTORY_ITEM_ID, 'ALL', 'Y', 'VALUE') ITEM_NUMBER,
              ITEM_DESCRIPTION, 
              REVISION,
              SUBINVENTORY,
              LOCATOR_ID,
              fnd_flex_xml_publisher_apis.process_kff_combination_1('p_loc_flexdata', 'INV', 'MTLL', 101, mil.ORGANIZATION_ID, mil.INVENTORY_LOCATION_ID, 'ALL', 'Y', 'VALUE') LOCATOR_NUMBER,
              LOT_NUMBER,
              SERIAL_NUMBER,
              COUNT_UNIT_OF_MEASURE,
              COUNT_DATE,
              COUNT_QUANTITY,
              EMPLOYEE_FULL_NAME,
              PROCESS_FLAG,
              PROCESS_MODE,
              STATUS_FLAG,
              ERROR_FLAG,
              PARENT_LPN_ID,
              MCCI.PARENT_LPN,
              MCCI.OUTERMOST_LPN_ID,
              MCCI.OUTERMOST_LPN,
              MCCI.COST_GROUP_ID,
              CG. COST_GROUP
FROM    MTL_CC_ENTRIES_INTERFACE_V MCCI,
              MTL_SYSTEM_ITEMS MSI,
              MTL_ITEM_LOCATIONS MIL,
              MFG_LOOKUPS ML,
              CST_COST_GROUPS CG
WHERE MCCI.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID(+)
AND      MCCI.ORGANIZATION_ID   = MSI.ORGANIZATION_ID(+)
AND      MCCI.ORGANIZATION_ID  = MIL.ORGANIZATION_ID(+)
AND      MCCI.LOCATOR_ID            = MIL.INVENTORY_LOCATION_ID(+)
AND      MCCI.ACTION_CODE        = ML.LOOKUP_CODE(+)
AND      ML.LOOKUP_TYPE  = 'MTL_CCEOI_ACTION_CODE' 
AND      NVL(MCCI.ERROR_FLAG,2) = 1
AND      MCCI.COST_GROUP_ID = CG.COST_GROUP_ID (+)
AND     &P_WHERE_CLAUSE