VIEW: APPS.PO_RFQ_LINES_PRINT

Source

View Text - Preformatted

SELECT POL.ITEM_REVISION , POL.LINE_NUM , POL.ITEM_DESCRIPTION , POL.VENDOR_PRODUCT_NUM , POL.NOTE_TO_VENDOR , DECODE(PLT.ORDER_TYPE_LOOKUP_CODE,'QUANTITY', POL.UNIT_PRICE, TO_NUMBER(NULL)) , DECODE(PLT.ORDER_TYPE_LOOKUP_CODE,'QUANTITY', POL.QUANTITY, NULL) , POL.UNIT_PRICE * POL.QUANTITY , 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.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.PO_HEADER_ID , POL.PO_LINE_ID , POL.ITEM_ID , POL.ORG_ID FROM PO_LINE_TYPES PLT, PO_HEADERS_ALL POH, PO_LINES 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 = POH.PO_HEADER_ID AND POH.TYPE_LOOKUP_CODE = 'RFQ' AND POL.HAZARD_CLASS_ID = PHC.HAZARD_CLASS_ID(+) AND POL.UN_NUMBER_ID = PUN.UN_NUMBER_ID(+) AND POL.UNIT_MEAS_LOOKUP_CODE = MUM.UNIT_OF_MEASURE(+)

View Text - HTML Formatted

SELECT POL.ITEM_REVISION
, POL.LINE_NUM
, POL.ITEM_DESCRIPTION
, POL.VENDOR_PRODUCT_NUM
, POL.NOTE_TO_VENDOR
, DECODE(PLT.ORDER_TYPE_LOOKUP_CODE
, 'QUANTITY'
, POL.UNIT_PRICE
, TO_NUMBER(NULL))
, DECODE(PLT.ORDER_TYPE_LOOKUP_CODE
, 'QUANTITY'
, POL.QUANTITY
, NULL)
, POL.UNIT_PRICE * POL.QUANTITY
, 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.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.PO_HEADER_ID
, POL.PO_LINE_ID
, POL.ITEM_ID
, POL.ORG_ID
FROM PO_LINE_TYPES PLT
, PO_HEADERS_ALL POH
, PO_LINES 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 = POH.PO_HEADER_ID
AND POH.TYPE_LOOKUP_CODE = 'RFQ'
AND POL.HAZARD_CLASS_ID = PHC.HAZARD_CLASS_ID(+)
AND POL.UN_NUMBER_ID = PUN.UN_NUMBER_ID(+)
AND POL.UNIT_MEAS_LOOKUP_CODE = MUM.UNIT_OF_MEASURE(+)