View: PO_LINES_PRINT

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

View Text

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

Columns