View: MRPFV_MPS_CONSUMPTIONS

Product:	MRP - Master Scheduling/MRP
Description:
Implementation/DBA Data:	APPS.MRPFV_MPS_CONSUMPTIONS

View Text

SELECT DECODE(MRSC.DISPOSITION_TYPE
, 2
, POH.SEGMENT1
, 6
, POH.SEGMENT1
, NULL)
, LKUP.MEANING
, 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 DECODE(MRSC.DISPOSITION_TYPE
, 7
, RSHIP.SHIPMENT_NUM
, 8
, RSHIP.SHIPMENT_NUM
, NULL)
, LKUP.MEANING
, 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 DECODE(MRSC.DISPOSITION_TYPE
, 5
, POREQ.SEGMENT1
, NULL)
, LKUP.MEANING
, 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 DECODE(MRSC.DISPOSITION_TYPE
, 1
, WIP.WIP_ENTITY_NAME
, 9
, WIP.WIP_ENTITY_NAME
, NULL)
, LKUP.MEANING
, 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

Columns