INV Cycle counts pending approval

Description
Categories: BI Publisher, Logistics
Application: Inventory
Source: Cycle counts pending approval report (XML)
Short Name: INVARCPA_XML
DB package: INV_INVARCPA_XMLP_PKG
select sys.item_number,
       sys.description,
       cch.cycle_count_header_name,
       cce.count_date_current,
       cce.subinventory,
       cce.revision,
       cce.lot_number,
       cce.locator_id,
       round( cce.adjustment_quantity, :P_qty_precision)  
                                                     adjustment_quantity,
   cce.adjustment_date,
   round(nvl(cce.adjustment_quantity,0)*nvl(cce.item_unit_cost,0),
              :S_STD_Precision)          adjustment_amount,
       round( cce.count_quantity_current, :P_qty_precision)
                                                      count_quantity_current,
       abc.abc_class_name,
       null    C_LOCATOR_FLEXDAT,
       round( cce.neg_adjustment_quantity, :P_qty_precision)  
       NEG_ADJUSTMENT_QUANTITY,
       round(nvl(cce.neg_adjustment_quantity,0)*nvl(cce.item_unit_cost,0),
              :S_STD_Precision) 
       NEG_ADJUSTMENT_AMOUNT,
       cce.SERIAL_DETAIL SERIAL_DETAIL ,
       CYCLE_COUNT_ENTRY_ID CYCLE_COUNT_ENTRY_ID1,
       cce.SERIAL_NUMBER SERAIL_NUMBER,
       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_locator_value', 'INV', 'MTLL', 101, LOC.ORGANIZATION_ID, LOC.INVENTORY_LOCATION_ID, 'ALL', 'Y', 'VALUE') F_LOCATOR_VALUE, 
	INV_INVARCPA_XMLP_PKG.cf_outermost_lpnformula(cch.container_enabled_flag, cce.outermost_lpn_id) CF_OUTERMOST_LPN, 
	INV_INVARCPA_XMLP_PKG.cf_parent_lpnformula(cch.container_enabled_flag, cce.parent_lpn_id) CF_PARENT_LPN, 
	INV_INVARCPA_XMLP_PKG.cf_cost_groupformula(cce.cost_group_id) CF_COST_GROUP
from 
       MTL_ITEM_LOCATIONS LOC,
       mtl_item_flexfields       sys,
       mtl_cycle_count_headers   cch,
       mtl_cycle_count_items     cci,
       mtl_cycle_count_entries   cce,
       mtl_abc_classes           abc   
where
       sys.organization_id  = :ORGANIZATION_ID
 and  cch.cycle_count_header_id = :P_HeaderId
 and   cce.organization_id = :ORGANIZATION_ID
 and   cch.organization_id  = :ORGANIZATION_ID
 and   abc.organization_id  = :ORGANIZATION_ID
 and   cce.locator_id =  loc.inventory_location_id(+)
 and   cce.organization_id    =  loc.organization_id(+)
 and   cce.cycle_count_header_id = :P_HeaderId
 and   cce.entry_status_code  = 2
 and   sys.item_id           = cce.inventory_item_id
 and   cci.abc_class_id      = abc.abc_class_id
 and   cci.cycle_count_header_id = :P_HeaderId
 and   cci.inventory_item_id     = cce.inventory_item_id 
&C_ORDERBY
Parameter Name SQL text Validation
Organization
 
Number
Display Serial Numbers
 
LOV Oracle
Sort By
 
LOV Oracle
Cycle Count Name
 
LOV Oracle