INV Cycle count listing

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.organization_id  = :P_ORG_ID
 and   cce.organization_id  = :P_ORG_ID
 and   abc.organization_id = :P_ORG_ID
 and   (cce.subinventory  = :P_SubInventory  or 
          :P_SubInventory  is NULL) 
 and   cce.locator_id =  loc.inventory_location_id(+)
 and   cce.inventory_item_id = cci.inventory_item_id
 and  cci.abc_class_id   = abc.abc_class_id
 and   cce.cycle_count_header_id  = cci.cycle_count_header_id
 and   cce.organization_id  =  loc.organization_id(+)
 and   cch.cycle_count_header_id = :P_HeaderID
 and   cce.cycle_count_header_id = :P_HeaderID
 and   sys.inventory_item_id            = CCE.inventory_item_id
 and   mfg1.lookup_type  = 'MTL_CC_ENTRY_STATUSES'
 and   mfg1.lookup_code = CCE.ENTRY_STATUS_CODE
 and  ( ((cce.entry_status_code = 1) and (:P_RecountOnly <> 1))
           or (cce.entry_status_code =  3))
 and  cce.creation_date <= to_date(to_char(:P_ToDate, 'DD-MON-RRRR') || ' 23:59:59', 'DD-MON-YYYY HH24:MI:SS')    
 and  cce.creation_date >= trunc(:P_FromDate)
and ( (nvl(:P_EXPORT_DISPLAY, 1) = 1)   
           OR (:P_EXPORT_DISPLAY = 2 AND nvl(cce.EXPORT_FLAG, 2) = 2)
           OR (:P_EXPORT_DISPLAY = 3 AND cce.EXPORT_FLAG = 1))
ORDER BY  cce.count_list_sequence,
Subinventory, C_LOCATOR_FLEXDAT, C_ITEM_FLEXDAT, Revision, LotNumber, SERIAL_NUMBER
Parameter Name SQL text Validation
Organization
 
Number
Items to include
 
LOV Oracle
Display Onhand Quantities
 
LOV Oracle
Display Serial Numbers
 
LOV Oracle
Subinventory
 
LOV Oracle
Include Recounts Only
 
LOV Oracle
End Date
 
Date
Start Date
 
Date
Cycle Count Name
 
LOV Oracle