ECC Inventory Management, Inventory Physical Counting

➜ Back to Library
Description
Categories: Enterprise Command Center
Imported from Enterprise Command Center
Dataset Key: inv-physical-inventory
Query Procedure: inv_ecc_phyinv_util_pvt.get_ecc_data_load_info
Security Procedure: inv_ecc_datasecurity_pkg_pub.GetFilterAttributeValues
Run ECC Inventory Management, Inventory Physical Counting and other Oracle EBS reports with Blitz Report™ on our demo environment
select
x.*
from
(
SELECT * FROM (SELECT * FROM ( select iepv.ecc_spec_id,phyinvtag_dfv.*,  iepv.organization_id,
								iepv.organization_code,
								iepv.physical_inventory_id,
								iepv.physical_inventory_name,
								iepv.total_adjustment_value,
								iepv.freeze_date,
								iepv.inventory_item_id,
								iepv.item,
								iepv.item_description,
								iepv.revision,
								iepv.subinventory_name,
								iepv.locator_id,
								iepv.locator,
								iepv.lot_number,
								iepv.primary_uom_code,
								iepv.secondary_uom_code,
								iepv.system_quantity,
								iepv.count_quantity,
								iepv.adjustment_quantity,
								iepv.system_value,
								iepv.count_value,
								iepv.adjustment_value,
								iepv.approval_status_code,
								iepv.approval_status,
								iepv.approved_by_employee_id,
								iepv.approver,
								iepv.secondary_system_qty,
								iepv.secondary_count_qty,
								iepv.secondary_adjustment_qty,
								iepv.sec_system_value,
								iepv.sec_count_value,
								iepv.sec_adjustment_value,
								iepv.cost_group_id,
								iepv.cost_group,
								iepv.parent_lpn_id,
								iepv.parent_lpn,
								iepv.outermost_lpn_id,
								iepv.outermost_lpn,
								iepv.tag_secondary_uom,
								iepv.tag_secondary_quantity,
								iepv.tag_qty_at_std_secondary_uom,
								iepv.standard_secondary_uom,
								iepv.tag_quantity,
								iepv.tag_creation_date,
								iepv.tag_number,
                                                                iepv.tag_id,
								iepv.void_flag_code,
								iepv.void_flag,
								iepv.adjustment_id,
								iepv.counted_by,
								iepv.blank_tag,
								iepv.reservation_exists,
							        iepv.allocation_exists,
								iepv.currency_code,
								iepv.adjustment_percent,
								iepv.item_cost,
								iepv.tag_value,
								iepv.language,
                                iepv.lot_expiration
 from (select iepv.*,mstl.language from INV_ECC_PHYINV_MAP iepv, mtl_system_items_tl mstl
where iepv.organization_id = mstl.organization_id (+)
AND iepv.inventory_item_id = mstl.inventory_item_id(+) ) iepv  ,(select "ROW_ID" "'INV_PHYINVTAG_ROW_ID'","CONTEXT" "'INV_PHYINVTAG_CONTEXT'","CONCATENATED_SEGMENTS" "'INV_PHYINVTAG_CONCATENATED_SEGMENTS'" from ( select ROWID "ROW_ID",ATTRIBUTE_CATEGORY "CONTEXT",NULL "CONCATENATED_SEGMENTS" from MTL_PHYSICAL_INVENTORY_TAGS )) phyinvtag_dfv, mtl_physical_inventory_tags mpit  where ( language is null OR language in ('US')) and mpit.rowid = phyinvtag_dfv."'INV_PHYINVTAG_ROW_ID'"(+)
                                   and iepv.tag_id = mpit.tag_id(+) ) WHERE     physical_inventory_id = nvl('',physical_inventory_id)
 AND     organization_id=nvl('',organization_id) ) PIVOT  (max(ITEM_DESCRIPTION) as ITEM_DESCRIPTION, max(APPROVAL_STATUS) as APPROVAL_STATUS ,max(VOID_FLAG) as VOID_FLAG
for LANGUAGE in ('US' "US"))
) x
where
2=2
Parameter Name SQL text Validation
Organization Code 
x.organization_code=:organization_code
 LOV
Download
Related Blitz Reports
INV Physical inventory tag listing INV Physical inventory missing tag listing INV Physical Inventory Tags INV Physical inventory counts INV Physical inventory trend and summary analysis ECC Project Manufacturing, On-Hand Balance ECC Oracle Asset Tracking, Oracle Asset Tracking: Assets CAC Deferred COGS Out-of-Balance GL Account Analysis
Blitz Report™

Blitz Report™ provides multiple benefits: