INV Physical inventory tag listing

Description

Imported from BI Publisher
Description: Physical inventory tag listing
Application: Inventory
Source: Physical inventory tag listing (XML)
Short Name: INVARPTG_XML
DB package: INV_INVARPMT_XMLP_PKG

INV Physical inventory tag listing and other Oracle EBS reports with Blitz Report™ on our demo environment

Copy

select 	pit.tag_number,
	pit.subinventory,
	&P_item_flex	C_item_flex,
 	pit.revision,
	&P_loc_flex   	C_loc_flex,
loc.inventory_location_id           loc_id,
	pit.lot_number	,
	pit.serial_num	Serial_number,
	pit.tag_quantity	quantity,
	pit.tag_uom	uom,
	v.last_name	Counted_by,
                  pit.inventory_item_Id item_id,
                  pit.outermost_lpn_id,
                  pit.parent_lpn_id ,
	pit.cost_group_id, 
	fnd_flex_xml_publisher_apis.process_kff_combination_1('c_item_field', 'INV', 'MSTK', 101, MSI.ORGANIZATION_ID, MSI.INVENTORY_ITEM_ID, 'ALL', 'Y', 'VALUE') C_item_field, 
	nvl2(loc.inventory_location_id, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_loc_field', 'INV', 'MTLL', 101, LOC.ORGANIZATION_ID, LOC.INVENTORY_LOCATION_ID, 'ALL', 'Y', 'VALUE'), null)  C_loc_field, 
	INV_INVARPMT_XMLP_PKG.cf_outermost_lpnformula(pit.outermost_lpn_id) CF_OUTERMOST_LPN, 
	INV_INVARPMT_XMLP_PKG.cf_parent_lpnformula(pit.parent_lpn_id) CF_PARENT_LPN, 
	INV_INVARPMT_XMLP_PKG.cf_cost_groupformula(pit.cost_group_id) CF_COST_GROUP
from    
	mtl_system_items	        msi,
	mtl_item_locations          loc ,
	mtl_employees_view           v,
	mtl_physical_inventory_tags pit
where       pit.organization_id = :P_org_id
and	msi.organization_id(+) = :P_org_id
and 	loc.organization_id(+) = :P_org_id
and     pit.inventory_item_id = msi.inventory_item_id(+)
and 	pit.locator_id = loc.inventory_location_id(+) 
and           pit.physical_inventory_id = :P_phys_inv_id
&C_where
and	pit.counted_by_employee_id = v.employee_id(+)
and	v.organization_id(+) = :P_org_id
-- P_condition this does not do any thing
order by 1