ECC Inventory Management, Reservations
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
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 |
|
LOV |