ECC Inventory Management, Reservations

Description

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

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

Copy

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