View: PO_RFQ_LINES_PRINT

Product:	PO - Purchasing
Description:	Print view of RFQ lines
Implementation/DBA Data:	APPS.PO_RFQ_LINES_PRINT

View Text

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(+)

Columns