View: PO_LINES_RFQQT_V

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

View Text

SELECT POL.ROWID
, POL.PO_HEADER_ID
, POL.PO_LINE_ID
, POL.LINE_NUM
, POL.LINE_TYPE_ID
, PLT.LINE_TYPE
, POL.ITEM_ID
, POL.ITEM_REVISION
, POL.CATEGORY_ID
, POL.ITEM_DESCRIPTION
, POL.UNIT_MEAS_LOOKUP_CODE
, MUOM.UOM_CLASS
, POL.UNIT_PRICE
, POL.VENDOR_PRODUCT_NUM
, POL.UN_NUMBER_ID
, PUN.UN_NUMBER
, POL.HAZARD_CLASS_ID
, PHC.HAZARD_CLASS
, POL.MIN_ORDER_QUANTITY
, POL.MAX_ORDER_QUANTITY
, POL.NOTE_TO_VENDOR
, POL.FROM_HEADER_ID
, POL.FROM_LINE_ID
, POL.TAXABLE_FLAG
, POL.QUANTITY
, MSI.ALLOW_ITEM_DESC_UPDATE_FLAG
, MSI.ALLOWED_UNITS_LOOKUP_CODE
, PLT.ORDER_TYPE_LOOKUP_CODE
, NVL(PLT.OUTSIDE_OPERATION_FLAG
, 'N')
, POL.LAST_UPDATE_DATE
, POL.LAST_UPDATED_BY
, POL.LAST_UPDATE_LOGIN
, POL.CREATED_BY
, POL.CREATION_DATE
, POL.PROGRAM_ID
, POL.PROGRAM_UPDATE_DATE
, POL.REQUEST_ID
, POL.PROGRAM_APPLICATION_ID
, 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.ATTRIBUTE_CATEGORY
, POL.PROJECT_ID
, PJM_PROJECT.ALL_PROJ_IDTONUM(POL.PROJECT_ID)
, POL.TASK_ID
, PJM_PROJECT.ALL_TASK_IDTONUM(POL.TASK_ID)
, POL.QC_GRADE
, POL.BASE_UOM
, POL.BASE_QTY
, POL.SECONDARY_UOM
, POL.SECONDARY_QTY
, POL.OKE_CONTRACT_HEADER_ID
, POL.OKE_CONTRACT_VERSION_ID
, PLT.PURCHASE_BASIS
, PLT.MATCHING_BASIS
, POL.ORG_ID
FROM PO_LINES POL
, PO_LINE_TYPES PLT
, MTL_UNITS_OF_MEASURE MUOM
, PO_UN_NUMBERS_TL PUN
, PO_HAZARD_CLASSES_TL PHC
, MTL_SYSTEM_ITEMS MSI
, FINANCIALS_SYSTEM_PARAMS_ALL FSP
WHERE PLT.LINE_TYPE_ID (+) = POL.LINE_TYPE_ID
AND PUN.UN_NUMBER_ID (+) = POL.UN_NUMBER_ID
AND PUN.LANGUAGE(+) = USERENV('LANG')
AND PHC.HAZARD_CLASS_ID (+) = POL.HAZARD_CLASS_ID
AND PHC.LANGUAGE(+) = USERENV('LANG')
AND MUOM.UNIT_OF_MEASURE (+) = POL.UNIT_MEAS_LOOKUP_CODE
AND POL.ITEM_ID = MSI.INVENTORY_ITEM_ID (+)
AND NVL(MSI.ORGANIZATION_ID
, FSP.INVENTORY_ORGANIZATION_ID) = FSP.INVENTORY_ORGANIZATION_ID
AND FSP.ORG_ID = POL.ORG_ID

Columns