ECC Inventory Management, Inventory Physical Counting

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

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Contact us to schedule a demo or if you need help with the installation

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