View: MRP_SCHEDULE_CONSUMPTIONS_V

Product:	MRP - Master Scheduling/MRP
Description:	Consumption history for master schedule
Implementation/DBA Data:	APPS.MRP_SCHEDULE_CONSUMPTIONS_V

View Text

SELECT MRSC.ROWID ROW_ID
, MRSC.TRANSACTION_ID
, MRSC.RELIEF_TYPE
, MRSC.DISPOSITION_TYPE
, L.MEANING DISPOSITION_TYPE_TEXT
, MRSC.DISPOSITION_ID
, DECODE(DISPOSITION_TYPE
, 1
, WIP.WIP_ENTITY_NAME
, 2
, POH.SEGMENT1
, 3
, NULL
, 4
, NULL
, 5
, POREQ.SEGMENT1
, 6
, POH.SEGMENT1
, 7
, RSHIP.SHIPMENT_NUM
, 8
, RSHIP.SHIPMENT_NUM
, 9
, WIP.WIP_ENTITY_NAME
, NULL) DISPOSITION
, MRSC.LINE_NUM
, MRSC.ORDER_DATE
, MRSC.ORDER_QUANTITY
, MRSC.RELIEF_QUANTITY
, MRSC.SCHEDULE_DATE
, MRSC.LAST_UPDATE_DATE
, MRSC.LAST_UPDATED_BY
, MRSC.CREATION_DATE
, MRSC.CREATED_BY
, MRSC.LAST_UPDATE_LOGIN
, MRSC.PROGRAM_APPLICATION_ID
, MRSC.PROGRAM_ID
, MRSC.PROGRAM_UPDATE_DATE
, MRSC.REQUEST_ID
FROM RCV_SHIPMENT_HEADERS RSHIP
, PO_REQUISITION_HEADERS_ALL POREQ
, PO_HEADERS_ALL POH
, WIP_ENTITIES WIP
, MFG_LOOKUPS L
, MRP_SCHEDULE_CONSUMPTIONS MRSC
WHERE POH.PO_HEADER_ID(+) = MRSC.DISPOSITION_ID
AND POREQ.REQUISITION_HEADER_ID(+) = MRSC.DISPOSITION_ID
AND RSHIP.SHIPMENT_HEADER_ID(+) = MRSC.DISPOSITION_ID
AND WIP.WIP_ENTITY_ID(+) = MRSC.DISPOSITION_ID
AND L.LOOKUP_TYPE = 'MRP_RELIEF_ORIGINATION'
AND L.LOOKUP_CODE = MRSC.DISPOSITION_TYPE

Columns