VIEW: APPS.PO_LINES_PRINT

Source

View Text - Preformatted

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 , CONTRACT.SEGMENT1 , 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, PO_HEADERS_ALL CONTRACT, 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.CONTRACT_ID = CONTRACT.PO_HEADER_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 , CONTRACT.SEGMENT1 , 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, PO_HEADERS_ALL CONTRACT, 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.CONTRACT_ID = CONTRACT.PO_HEADER_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 , CONTRACT.SEGMENT1 , 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, PO_HEADERS_ALL CONTRACT, 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.CONTRACT_ID = CONTRACT.PO_HEADER_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 , CONTRACT.SEGMENT1 , 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, PO_HEADERS_ALL CONTRACT, 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.CONTRACT_ID = CONTRACT.PO_HEADER_ID(+) AND PL1.FROM_LINE_ID = PL2.PO_LINE_ID (+) AND PL1.UNIT_MEAS_LOOKUP_CODE = MUM.UNIT_OF_MEASURE (+)

View Text - HTML Formatted

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
, CONTRACT.SEGMENT1
, 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
, PO_HEADERS_ALL CONTRACT
, 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.CONTRACT_ID = CONTRACT.PO_HEADER_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
, CONTRACT.SEGMENT1
, 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
, PO_HEADERS_ALL CONTRACT
, 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.CONTRACT_ID = CONTRACT.PO_HEADER_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
, CONTRACT.SEGMENT1
, 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
, PO_HEADERS_ALL CONTRACT
, 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.CONTRACT_ID = CONTRACT.PO_HEADER_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
, CONTRACT.SEGMENT1
, 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
, PO_HEADERS_ALL CONTRACT
, 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.CONTRACT_ID = CONTRACT.PO_HEADER_ID(+)
AND PL1.FROM_LINE_ID = PL2.PO_LINE_ID (+)
AND PL1.UNIT_MEAS_LOOKUP_CODE = MUM.UNIT_OF_MEASURE (+)