eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.MRPBV_MPS_CONSUMPTIONS

Source

View Text - Preformatted


SELECT MRSC.LINE_NUM , MRSC.RELIEF_QUANTITY , MRSC.SCHEDULE_DATE , MRSC.TRANSACTION_ID , DECODE(MRSC.DISPOSITION_TYPE, 2, MRSC.DISPOSITION_ID, 6, MRSC.DISPOSITION_ID, TO_NUMBER(NULL)) , TO_NUMBER(NULL) , TO_NUMBER(NULL) , TO_NUMBER(NULL) , MRSC.LAST_UPDATE_DATE , MRSC.LAST_UPDATED_BY , MRSC.CREATION_DATE , MRSC.CREATED_BY FROM PO_HEADERS_ALL POH, MFG_LOOKUPS LKUP, MRP_SCHEDULE_DATES MRSD, MRP_SCHEDULE_CONSUMPTIONS MRSC WHERE MRSD.MPS_TRANSACTION_ID = MRSC.TRANSACTION_ID AND MRSC.DISPOSITION_TYPE IN (2,6) AND POH.PO_HEADER_ID = MRSC.DISPOSITION_ID AND LKUP.LOOKUP_TYPE = 'MRP_RELIEF_ORIGINATION' AND LKUP.LOOKUP_CODE = MRSC.DISPOSITION_TYPE AND '_SEC:MRSD.ORGANIZATION_ID' IS NOT NULL UNION ALL SELECT MRSC.LINE_NUM , MRSC.RELIEF_QUANTITY , MRSC.SCHEDULE_DATE , MRSC.TRANSACTION_ID , TO_NUMBER(NULL) , DECODE(MRSC.DISPOSITION_TYPE, 7, MRSC.DISPOSITION_ID, 8, MRSC.DISPOSITION_ID, TO_NUMBER(NULL)) , TO_NUMBER(NULL) , TO_NUMBER(NULL) , MRSC.LAST_UPDATE_DATE , MRSC.LAST_UPDATED_BY , MRSC.CREATION_DATE , MRSC.CREATED_BY FROM RCV_SHIPMENT_HEADERS RSHIP, MFG_LOOKUPS LKUP, MRP_SCHEDULE_DATES MRSD, MRP_SCHEDULE_CONSUMPTIONS MRSC WHERE MRSD.MPS_TRANSACTION_ID = MRSC.TRANSACTION_ID AND MRSC.DISPOSITION_TYPE IN (7,8) AND RSHIP.SHIPMENT_HEADER_ID = MRSC.DISPOSITION_ID AND LKUP.LOOKUP_TYPE = 'MRP_RELIEF_ORIGINATION' AND LKUP.LOOKUP_CODE = MRSC.DISPOSITION_TYPE AND '_SEC:MRSD.ORGANIZATION_ID' IS NOT NULL UNION ALL SELECT MRSC.LINE_NUM , MRSC.RELIEF_QUANTITY , MRSC.SCHEDULE_DATE , MRSC.TRANSACTION_ID , TO_NUMBER(NULL) , TO_NUMBER(NULL) , DECODE(MRSC.DISPOSITION_TYPE, 5, MRSC.DISPOSITION_ID, TO_NUMBER(NULL)) , TO_NUMBER(NULL) , MRSC.LAST_UPDATE_DATE , MRSC.LAST_UPDATED_BY , MRSC.CREATION_DATE , MRSC.CREATED_BY FROM PO_REQUISITION_HEADERS_ALL POREQ, MFG_LOOKUPS LKUP, MRP_SCHEDULE_DATES MRSD, MRP_SCHEDULE_CONSUMPTIONS MRSC WHERE MRSD.MPS_TRANSACTION_ID = MRSC.TRANSACTION_ID AND MRSC.DISPOSITION_TYPE = 5 AND POREQ.REQUISITION_HEADER_ID = MRSC.DISPOSITION_ID AND LKUP.LOOKUP_TYPE = 'MRP_RELIEF_ORIGINATION' AND LKUP.LOOKUP_CODE = MRSC.DISPOSITION_TYPE AND '_SEC:MRSD.ORGANIZATION_ID' IS NOT NULL UNION ALL SELECT MRSC.LINE_NUM , MRSC.RELIEF_QUANTITY , MRSC.SCHEDULE_DATE , MRSC.TRANSACTION_ID , TO_NUMBER(NULL) , TO_NUMBER(NULL) , TO_NUMBER(NULL) , DECODE(MRSC.DISPOSITION_TYPE, 1, MRSC.DISPOSITION_ID, 9, MRSC.DISPOSITION_ID, TO_NUMBER(NULL)) , MRSC.LAST_UPDATE_DATE , MRSC.LAST_UPDATED_BY , MRSC.CREATION_DATE , MRSC.CREATED_BY FROM WIP_ENTITIES WIP, MFG_LOOKUPS LKUP, MRP_SCHEDULE_DATES MRSD, MRP_SCHEDULE_CONSUMPTIONS MRSC WHERE MRSD.MPS_TRANSACTION_ID = MRSC.TRANSACTION_ID AND MRSC.DISPOSITION_TYPE IN (1,9) AND WIP.WIP_ENTITY_ID = MRSC.DISPOSITION_ID AND LKUP.LOOKUP_TYPE = 'MRP_RELIEF_ORIGINATION' AND LKUP.LOOKUP_CODE = MRSC.DISPOSITION_TYPE AND '_SEC:MRSD.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

View Text - HTML Formatted

SELECT MRSC.LINE_NUM
, MRSC.RELIEF_QUANTITY
, MRSC.SCHEDULE_DATE
, MRSC.TRANSACTION_ID
, DECODE(MRSC.DISPOSITION_TYPE
, 2
, MRSC.DISPOSITION_ID
, 6
, MRSC.DISPOSITION_ID
, TO_NUMBER(NULL))
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, MRSC.LAST_UPDATE_DATE
, MRSC.LAST_UPDATED_BY
, MRSC.CREATION_DATE
, MRSC.CREATED_BY
FROM PO_HEADERS_ALL POH
, MFG_LOOKUPS LKUP
, MRP_SCHEDULE_DATES MRSD
, MRP_SCHEDULE_CONSUMPTIONS MRSC
WHERE MRSD.MPS_TRANSACTION_ID = MRSC.TRANSACTION_ID
AND MRSC.DISPOSITION_TYPE IN (2
, 6)
AND POH.PO_HEADER_ID = MRSC.DISPOSITION_ID
AND LKUP.LOOKUP_TYPE = 'MRP_RELIEF_ORIGINATION'
AND LKUP.LOOKUP_CODE = MRSC.DISPOSITION_TYPE
AND '_SEC:MRSD.ORGANIZATION_ID' IS NOT NULL UNION ALL SELECT MRSC.LINE_NUM
, MRSC.RELIEF_QUANTITY
, MRSC.SCHEDULE_DATE
, MRSC.TRANSACTION_ID
, TO_NUMBER(NULL)
, DECODE(MRSC.DISPOSITION_TYPE
, 7
, MRSC.DISPOSITION_ID
, 8
, MRSC.DISPOSITION_ID
, TO_NUMBER(NULL))
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, MRSC.LAST_UPDATE_DATE
, MRSC.LAST_UPDATED_BY
, MRSC.CREATION_DATE
, MRSC.CREATED_BY
FROM RCV_SHIPMENT_HEADERS RSHIP
, MFG_LOOKUPS LKUP
, MRP_SCHEDULE_DATES MRSD
, MRP_SCHEDULE_CONSUMPTIONS MRSC
WHERE MRSD.MPS_TRANSACTION_ID = MRSC.TRANSACTION_ID
AND MRSC.DISPOSITION_TYPE IN (7
, 8)
AND RSHIP.SHIPMENT_HEADER_ID = MRSC.DISPOSITION_ID
AND LKUP.LOOKUP_TYPE = 'MRP_RELIEF_ORIGINATION'
AND LKUP.LOOKUP_CODE = MRSC.DISPOSITION_TYPE
AND '_SEC:MRSD.ORGANIZATION_ID' IS NOT NULL UNION ALL SELECT MRSC.LINE_NUM
, MRSC.RELIEF_QUANTITY
, MRSC.SCHEDULE_DATE
, MRSC.TRANSACTION_ID
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, DECODE(MRSC.DISPOSITION_TYPE
, 5
, MRSC.DISPOSITION_ID
, TO_NUMBER(NULL))
, TO_NUMBER(NULL)
, MRSC.LAST_UPDATE_DATE
, MRSC.LAST_UPDATED_BY
, MRSC.CREATION_DATE
, MRSC.CREATED_BY
FROM PO_REQUISITION_HEADERS_ALL POREQ
, MFG_LOOKUPS LKUP
, MRP_SCHEDULE_DATES MRSD
, MRP_SCHEDULE_CONSUMPTIONS MRSC
WHERE MRSD.MPS_TRANSACTION_ID = MRSC.TRANSACTION_ID
AND MRSC.DISPOSITION_TYPE = 5
AND POREQ.REQUISITION_HEADER_ID = MRSC.DISPOSITION_ID
AND LKUP.LOOKUP_TYPE = 'MRP_RELIEF_ORIGINATION'
AND LKUP.LOOKUP_CODE = MRSC.DISPOSITION_TYPE
AND '_SEC:MRSD.ORGANIZATION_ID' IS NOT NULL UNION ALL SELECT MRSC.LINE_NUM
, MRSC.RELIEF_QUANTITY
, MRSC.SCHEDULE_DATE
, MRSC.TRANSACTION_ID
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, DECODE(MRSC.DISPOSITION_TYPE
, 1
, MRSC.DISPOSITION_ID
, 9
, MRSC.DISPOSITION_ID
, TO_NUMBER(NULL))
, MRSC.LAST_UPDATE_DATE
, MRSC.LAST_UPDATED_BY
, MRSC.CREATION_DATE
, MRSC.CREATED_BY
FROM WIP_ENTITIES WIP
, MFG_LOOKUPS LKUP
, MRP_SCHEDULE_DATES MRSD
, MRP_SCHEDULE_CONSUMPTIONS MRSC
WHERE MRSD.MPS_TRANSACTION_ID = MRSC.TRANSACTION_ID
AND MRSC.DISPOSITION_TYPE IN (1
, 9)
AND WIP.WIP_ENTITY_ID = MRSC.DISPOSITION_ID
AND LKUP.LOOKUP_TYPE = 'MRP_RELIEF_ORIGINATION'
AND LKUP.LOOKUP_CODE = MRSC.DISPOSITION_TYPE
AND '_SEC:MRSD.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY