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
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 |
|
LOV |