View: PO_LINES_CHANGE_PRINT

Product:	PO - Purchasing
Description:	- Retrofitted
Implementation/DBA Data:	APPS.PO_LINES_CHANGE_PRINT

View Text

SELECT POL.REVISION_NUM
, POL.ITEM_REVISION
, POL.LINE_NUM
, POL.ITEM_DESCRIPTION
, DECODE(POL.CANCEL_FLAG
, 'Y'
, 'Y'
, 'I'
, 'Y'
, 'N'
, 'N'
, NULL)
, POL.CANCEL_DATE
, POL.CANCEL_REASON
, POL.VENDOR_PRODUCT_NUM
, POL.NOTE_TO_VENDOR
, DECODE(PLT.ORDER_TYPE_LOOKUP_CODE
, 'AMOUNT'
, TO_NUMBER(NULL)
, POL.UNIT_PRICE)
, DECODE(PLT.ORDER_TYPE_LOOKUP_CODE
, 'QUANTITY'
, DECODE(PH1.TYPE_LOOKUP_CODE
, 'STANDARD'
, POL.QUANTITY
, 'PLANNED'
, POL.QUANTITY
, NULL)
, NULL)
, DECODE(PLT.ORDER_TYPE_LOOKUP_CODE
, 'QUANTITY'
, DECODE(PH1.TYPE_LOOKUP_CODE
, 'STANDARD'
, POL.UNIT_PRICE * POL.QUANTITY
, 'PLANNED'
, POL.UNIT_PRICE * POL.QUANTITY
, TO_NUMBER(NULL))
, 'AMOUNT'
, DECODE(PH1.TYPE_LOOKUP_CODE
, 'STANDARD'
, POL.UNIT_PRICE * POL.QUANTITY
, 'PLANNED'
, POL.UNIT_PRICE * POL.QUANTITY
, TO_NUMBER(NULL))
, 'RATE'
, DECODE (PH1.TYPE_LOOKUP_CODE
, 'STANDARD'
, POL.AMOUNT
, TO_NUMBER(NULL))
, 'FIXED PRICE'
, DECODE (PH1.TYPE_LOOKUP_CODE
, 'STANDARD'
, POL.AMOUNT
, TO_NUMBER(NULL))
, TO_NUMBER(NULL))
, NVL(MUM.UNIT_OF_MEASURE_TL
, POL.UNIT_MEAS_LOOKUP_CODE) UNIT_MEAS_LOOKUP_CODE
, PUN.UN_NUMBER||' '||PUN.DESCRIPTION
, PHC.HAZARD_CLASS
, PLT.ORDER_TYPE_LOOKUP_CODE
, POL.CONTRACT_NUM
, PH2.SEGMENT1
, PH2.QUOTE_VENDOR_QUOTE_NUMBER
, PL2.LINE_NUM
, POL.ATTRIBUTE_CATEGORY
, POL.ATTRIBUTE1
, POL.ATTRIBUTE2
, POL.ATTRIBUTE3
, POL.ATTRIBUTE4
, POL.ATTRIBUTE5
, POL.ATTRIBUTE6
, POL.ATTRIBUTE7
, POL.ATTRIBUTE8
, POL.ATTRIBUTE9
, POL.ATTRIBUTE10
, POL.ATTRIBUTE11
, POL.ATTRIBUTE12
, POL.ATTRIBUTE13
, POL.ATTRIBUTE14
, POL.ATTRIBUTE15
, POL.UNIT_PRICE
, POL.QUANTITY
, POL.QUANTITY_COMMITTED
, POL.PO_HEADER_ID
, POL.PO_LINE_ID
, TO_NUMBER(NULL)
, POL.ITEM_ID
, POL.ORG_ID
FROM PO_LINE_TYPES PLT
, PO_HEADERS_ALL PH2
, PO_LINES_ALL PL2
, PO_HEADERS_ALL PH1
, PO_LINES_ARCHIVE POL
, PO_UN_NUMBERS PUN
, PO_HAZARD_CLASSES PHC
, MTL_UNITS_OF_MEASURE MUM
WHERE POL.LINE_TYPE_ID = PLT.LINE_TYPE_ID
AND (POL.PO_HEADER_ID = PH1.PO_HEADER_ID)
AND PH1.TYPE_LOOKUP_CODE IN ('STANDARD'
, 'PLANNED')
AND POL.HAZARD_CLASS_ID = PHC.HAZARD_CLASS_ID (+)
AND POL.UN_NUMBER_ID = PUN.UN_NUMBER_ID (+)
AND PL2.PO_HEADER_ID = PH2.PO_HEADER_ID (+)
AND POL.FROM_LINE_ID = PL2.PO_LINE_ID (+)
AND NVL(POL.LATEST_EXTERNAL_FLAG
, 'N') = 'Y'
AND POL.UNIT_MEAS_LOOKUP_CODE = MUM.UNIT_OF_MEASURE(+) UNION SELECT POL.REVISION_NUM
, POL.ITEM_REVISION
, POL.LINE_NUM
, POL.ITEM_DESCRIPTION
, DECODE(POL.CANCEL_FLAG
, 'Y'
, 'Y'
, 'I'
, 'Y'
, 'N'
, 'N'
, NULL)
, POL.CANCEL_DATE
, POL.CANCEL_REASON
, POL.VENDOR_PRODUCT_NUM
, POL.NOTE_TO_VENDOR
, DECODE(PLT.ORDER_TYPE_LOOKUP_CODE
, 'AMOUNT'
, TO_NUMBER(NULL)
, POL.UNIT_PRICE)
, DECODE(PLT.ORDER_TYPE_LOOKUP_CODE
, 'QUANTITY'
, DECODE(PH1.TYPE_LOOKUP_CODE
, 'STANDARD'
, POL.QUANTITY
, 'PLANNED'
, POL.QUANTITY
, NULL)
, NULL)
, DECODE(PLT.ORDER_TYPE_LOOKUP_CODE
, 'QUANTITY'
, DECODE(PH1.TYPE_LOOKUP_CODE
, 'STANDARD'
, POL.UNIT_PRICE * POL.QUANTITY
, 'PLANNED'
, POL.UNIT_PRICE * POL.QUANTITY
, TO_NUMBER(NULL))
, 'AMOUNT'
, DECODE(PH1.TYPE_LOOKUP_CODE
, 'STANDARD'
, POL.UNIT_PRICE * POL.QUANTITY
, 'PLANNED'
, POL.UNIT_PRICE * POL.QUANTITY
, TO_NUMBER(NULL))
, TO_NUMBER(NULL))
, NVL(MUM.UNIT_OF_MEASURE_TL
, POL.UNIT_MEAS_LOOKUP_CODE) UNIT_MEAS_LOOKUP_CODE
, PUN.UN_NUMBER||' '||PUN.DESCRIPTION
, PHC.HAZARD_CLASS
, PLT.ORDER_TYPE_LOOKUP_CODE
, POL.CONTRACT_NUM
, PH2.SEGMENT1
, PH2.QUOTE_VENDOR_QUOTE_NUMBER
, PL2.LINE_NUM
, POL.ATTRIBUTE_CATEGORY
, POL.ATTRIBUTE1
, POL.ATTRIBUTE2
, POL.ATTRIBUTE3
, POL.ATTRIBUTE4
, POL.ATTRIBUTE5
, POL.ATTRIBUTE6
, POL.ATTRIBUTE7
, POL.ATTRIBUTE8
, POL.ATTRIBUTE9
, POL.ATTRIBUTE10
, POL.ATTRIBUTE11
, POL.ATTRIBUTE12
, POL.ATTRIBUTE13
, POL.ATTRIBUTE14
, POL.ATTRIBUTE15
, POL.UNIT_PRICE
, POL.QUANTITY
, POL.QUANTITY_COMMITTED
, POL.PO_HEADER_ID
, POL.PO_LINE_ID
, POR.PO_RELEASE_ID
, POL.ITEM_ID
, POL.ORG_ID
FROM PO_RELEASES_ALL POR
, PO_LINE_TYPES PLT
, PO_LINE_LOCATIONS_ALL PLL
, PO_HEADERS_ALL PH2
, PO_LINES_ALL PL2
, PO_HEADERS_ALL PH1
, PO_LINES_ARCHIVE POL
, PO_UN_NUMBERS PUN
, PO_HAZARD_CLASSES PHC
, MTL_UNITS_OF_MEASURE MUM
WHERE POL.LINE_TYPE_ID = PLT.LINE_TYPE_ID
AND (POL.PO_HEADER_ID = PH1.PO_HEADER_ID
AND PH1.PO_HEADER_ID = POR.PO_HEADER_ID )
AND PLL.PO_LINE_ID = POL.PO_LINE_ID
AND PLL.PO_HEADER_ID = PH1.PO_HEADER_ID
AND PLL.PO_RELEASE_ID = POR.PO_RELEASE_ID
AND PH1.TYPE_LOOKUP_CODE IN ('STANDARD'
, 'PLANNED')
AND POL.HAZARD_CLASS_ID = PHC.HAZARD_CLASS_ID (+)
AND POL.UN_NUMBER_ID = PUN.UN_NUMBER_ID (+)
AND PL2.PO_HEADER_ID = PH2.PO_HEADER_ID (+)
AND POL.FROM_LINE_ID = PL2.PO_LINE_ID (+)
AND NVL(POL.LATEST_EXTERNAL_FLAG
, 'N') = 'Y'
AND POL.UNIT_MEAS_LOOKUP_CODE = MUM.UNIT_OF_MEASURE(+) UNION SELECT POL.REVISION_NUM
, POL.ITEM_REVISION
, POL.LINE_NUM
, POL.ITEM_DESCRIPTION
, DECODE(POL.CANCEL_FLAG
, 'Y'
, 'Y'
, 'I'
, 'Y'
, 'N'
, 'N'
, NULL)
, POL.CANCEL_DATE
, POL.CANCEL_REASON
, POL.VENDOR_PRODUCT_NUM
, POL.NOTE_TO_VENDOR
, DECODE(PLT.ORDER_TYPE_LOOKUP_CODE
, 'AMOUNT'
, TO_NUMBER(NULL)
, POL.UNIT_PRICE)
, DECODE(PLT.ORDER_TYPE_LOOKUP_CODE
, 'QUANTITY'
, POL.QUANTITY_COMMITTED
, NULL)
, DECODE(PLT.ORDER_TYPE_LOOKUP_CODE
, 'QUANTITY'
, POL.COMMITTED_AMOUNT
, 'AMOUNT'
, POL.COMMITTED_AMOUNT
, TO_NUMBER(NULL))
, NVL(MUM.UNIT_OF_MEASURE_TL
, POL.UNIT_MEAS_LOOKUP_CODE) UNIT_MEAS_LOOKUP_CODE
, PUN.UN_NUMBER||' '||PUN.DESCRIPTION
, PHC.HAZARD_CLASS
, PLT.ORDER_TYPE_LOOKUP_CODE
, POL.CONTRACT_NUM
, PH2.SEGMENT1
, PH2.QUOTE_VENDOR_QUOTE_NUMBER
, PL2.LINE_NUM
, POL.ATTRIBUTE_CATEGORY
, POL.ATTRIBUTE1
, POL.ATTRIBUTE2
, POL.ATTRIBUTE3
, POL.ATTRIBUTE4
, POL.ATTRIBUTE5
, POL.ATTRIBUTE6
, POL.ATTRIBUTE7
, POL.ATTRIBUTE8
, POL.ATTRIBUTE9
, POL.ATTRIBUTE10
, POL.ATTRIBUTE11
, POL.ATTRIBUTE12
, POL.ATTRIBUTE13
, POL.ATTRIBUTE14
, POL.ATTRIBUTE15
, POL.UNIT_PRICE
, POL.QUANTITY
, POL.QUANTITY_COMMITTED
, POL.PO_HEADER_ID
, POL.PO_LINE_ID
, TO_NUMBER(NULL)
, POL.ITEM_ID
, POL.ORG_ID
FROM PO_LINE_TYPES PLT
, PO_UN_NUMBERS PUN
, PO_HAZARD_CLASSES PHC
, PO_HEADERS_ALL PH2
, PO_LINES_ALL PL2
, PO_HEADERS_ALL PH1
, PO_LINES_ARCHIVE POL
, MTL_UNITS_OF_MEASURE MUM
WHERE POL.LINE_TYPE_ID = PLT.LINE_TYPE_ID
AND POL.PO_HEADER_ID = PH1.PO_HEADER_ID
AND PH1.TYPE_LOOKUP_CODE = 'BLANKET'
AND POL.HAZARD_CLASS_ID = PHC.HAZARD_CLASS_ID (+)
AND POL.UN_NUMBER_ID = PUN.UN_NUMBER_ID (+)
AND PL2.PO_HEADER_ID = PH2.PO_HEADER_ID (+)
AND POL.FROM_LINE_ID = PL2.PO_LINE_ID (+)
AND NVL(POL.LATEST_EXTERNAL_FLAG
, 'N') ='Y'
AND POL.UNIT_MEAS_LOOKUP_CODE = MUM.UNIT_OF_MEASURE(+) UNION SELECT POL.REVISION_NUM
, POL.ITEM_REVISION
, POL.LINE_NUM
, POL.ITEM_DESCRIPTION
, DECODE(POL.CANCEL_FLAG
, 'Y'
, 'Y'
, 'I'
, 'Y'
, 'N'
, 'N'
, NULL)
, POL.CANCEL_DATE
, POL.CANCEL_REASON
, POL.VENDOR_PRODUCT_NUM
, POL.NOTE_TO_VENDOR
, DECODE(PLT.ORDER_TYPE_LOOKUP_CODE
, 'AMOUNT'
, TO_NUMBER(NULL)
, POL.UNIT_PRICE)
, DECODE(PLT.ORDER_TYPE_LOOKUP_CODE
, 'QUANTITY'
, POL.QUANTITY_COMMITTED
, NULL)
, DECODE(PLT.ORDER_TYPE_LOOKUP_CODE
, 'QUANTITY'
, POL.COMMITTED_AMOUNT
, 'AMOUNT'
, POL.COMMITTED_AMOUNT
, TO_NUMBER(NULL))
, NVL(MUM.UNIT_OF_MEASURE_TL
, POL.UNIT_MEAS_LOOKUP_CODE) UNIT_MEAS_LOOKUP_CODE
, PUN.UN_NUMBER||' '||PUN.DESCRIPTION
, PHC.HAZARD_CLASS
, PLT.ORDER_TYPE_LOOKUP_CODE
, POL.CONTRACT_NUM
, PH2.SEGMENT1
, PH2.QUOTE_VENDOR_QUOTE_NUMBER
, PL2.LINE_NUM
, POL.ATTRIBUTE_CATEGORY
, POL.ATTRIBUTE1
, POL.ATTRIBUTE2
, POL.ATTRIBUTE3
, POL.ATTRIBUTE4
, POL.ATTRIBUTE5
, POL.ATTRIBUTE6
, POL.ATTRIBUTE7
, POL.ATTRIBUTE8
, POL.ATTRIBUTE9
, POL.ATTRIBUTE10
, POL.ATTRIBUTE11
, POL.ATTRIBUTE12
, POL.ATTRIBUTE13
, POL.ATTRIBUTE14
, POL.ATTRIBUTE15
, POL.UNIT_PRICE
, POL.QUANTITY
, POL.QUANTITY_COMMITTED
, POL.PO_HEADER_ID
, POL.PO_LINE_ID
, POR.PO_RELEASE_ID
, POL.ITEM_ID
, POL.ORG_ID
FROM PO_RELEASES_ALL POR
, PO_LINE_TYPES PLT
, PO_LINE_LOCATIONS_ALL PLL
, PO_HEADERS_ALL PH2
, PO_LINES_ALL PL2
, PO_HEADERS_ALL PH1
, PO_LINES_ARCHIVE POL
, PO_UN_NUMBERS PUN
, PO_HAZARD_CLASSES PHC
, MTL_UNITS_OF_MEASURE MUM
WHERE POL.LINE_TYPE_ID = PLT.LINE_TYPE_ID
AND (POL.PO_HEADER_ID = PH1.PO_HEADER_ID
AND PH1.PO_HEADER_ID = POR.PO_HEADER_ID )
AND PLL.PO_LINE_ID = POL.PO_LINE_ID
AND PLL.PO_HEADER_ID = PH1.PO_HEADER_ID
AND PLL.PO_RELEASE_ID = POR.PO_RELEASE_ID
AND PH1.TYPE_LOOKUP_CODE = 'BLANKET'
AND POL.HAZARD_CLASS_ID = PHC.HAZARD_CLASS_ID (+)
AND POL.UN_NUMBER_ID = PUN.UN_NUMBER_ID (+)
AND PL2.PO_HEADER_ID = PH2.PO_HEADER_ID (+)
AND POL.FROM_LINE_ID = PL2.PO_LINE_ID (+)
AND NVL(POL.LATEST_EXTERNAL_FLAG
, 'N') = 'Y'
AND POL.UNIT_MEAS_LOOKUP_CODE = MUM.UNIT_OF_MEASURE(+)

Columns