VIEW: APPS.MRP_SCHEDULE_CONSUMPTIONS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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