ECC Inventory Management, Reservations

➜ Back to Library
Description
Categories: Enterprise Command Center
Imported from Enterprise Command Center
Dataset Key: inv-reservations
Query Procedure: inv_ecc_rsv_util_pvt.get_ecc_data_load_info
Security Procedure: inv_ecc_datasecurity_pkg_pub.GetFilterAttributeValues
Run ECC Inventory Management, Reservations and other Oracle EBS reports with Blitz Report™ on our demo environment
select
x.*
from
(
SELECT * FROM (SELECT * FROM (   select ierv.ecc_spec_id, ierv.DEMAND_HEADER
					  , ierv.LINE_NUMBER DEMAND_LINE
					  , ierv.DEMAND_QUANTITY DEMAND_QTY
					  , ierv.RESERVED_QTY
					  , ierv.SECONDARY_RESERVATION_QUANTITY
					  , ierv.SERIAL_RESERVATION_QUANTITY
					  , ierv.DEMAND_NAME
					  , ierv.DEMAND_SOURCE
					  , ierv.NEED_BY_DATE
					  , ierv.DEMAND_UOM
					  , ierv.REMAINING_UOM
					  , ierv.REMAINING_QUANTITY REMAINING_QTY
					  , ierv.DEMAND_SOURCE_TYPE_ID  DEMAND_TYPE_ID
					  , ierv.ITEM_ID
					  , ierv.ORG_ID
					  , ierv.ITEM_DESCRIPTION
					  , ierv.ITEM_NAME
					  , ierv.CROSSDOCK_FLAG CROSSDOCK
					  , ierv.CUSTOMER
					  , ierv.LPN
					  , ierv.LOCATOR
					  , ierv.SUBINVENTORY_CODE SUBINVENTORY
					  , ierv.LOT
					  , ierv.REVISION
					  , ierv.SUPPLY_LINE_DETAILS
					  , ierv.SUPPLY_LINE
					  , ierv.SUPPLY_HEADER
					  , ierv.RESERVED_UOM
					  , ierv.SUPPLY_NAME
					  , ierv.SUPPLY_TYPE
					  , ierv.SHORT
					  , ierv.SHORT_DESC
					  , ierv.LANGUAGE
					  , ierv.ORG_CODE
					  , ierv.RESERVATION_ID
					  , ierv.VALUE
					  , ierv.DEMAND_LINE_ID
					  , ierv.DEMAND_HEADER_ID
                      , ierv.GRADE
					  , CASE WHEN (ierv.STAGED_FLAG='Y') THEN 'N'
						WHEN (ierv.wms_enabled_flag='Y' AND ( ierv.CROSSDOCK_FLAG = 'Y' OR ierv.supply_source_type_id IN (27,17)) )
						THEN 'N'
						ELSE 'Y'
						 END release_level
					  FROM  INV_ECC_RESERVATIONS_V  ierv where
					  language in ('US'))  where 1=1  ) PIVOT (max(ITEM_DESCRIPTION) as ITEM_DESCRIPTION,
				 max(DEMAND_SOURCE) as DEMAND_SOURCE, max(SUPPLY_TYPE) as  SUPPLY_TYPE, max(SHORT_DESC) as SHORT_DESC
				 for LANGUAGE in ('US' "US"))
) x
where
2=2
Parameter Name SQL text Validation
Organization Code 
x.org_code=:organization_code
 LOV
Download
Related Blitz Reports
INV Onhand Quantities ECC Project Manufacturing Genealogy & Trace, Sales Orders ECC Discrete Manufacturing, Work Order Delays ECC Discrete Manufacturing, Work Orders ECC Receivables, Outstanding Receivables (14) ECC Inventory Management, Inbound Details (1) ECC Procurement, Purchase Orders ECC Receivables, Billing Process, SQL1 ECC Assets, Pipeline
Blitz Report™

Blitz Report™ provides multiple benefits: