View: POFV_QUOTATION_LINES

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

View Text

SELECT QL.PO_LINE_ID
, QL.LINE_NUM
, QL.PO_HEADER_ID
, QU.SEGMENT1
, QL.ORG_ID
, OP.NAME
, LT.LINE_TYPE
, QL.ITEM_DESCRIPTION
, QL.UNIT_PRICE
, QL.MAX_ORDER_QUANTITY
, QL.MIN_ORDER_QUANTITY
, QL.NOTE_TO_VENDOR
, QL.VENDOR_PRODUCT_NUM
, '_DF:PO:PO_LINES:QL'
, QL.ITEM_ID
, '_KF:INV:MSTK:SI'
, QL.ITEM_REVISION
, SI.ORGANIZATION_ID
, MP.ORGANIZATION_CODE
, QL.CATEGORY_ID
, '_KF:INV:MCAT:CT'
, QL.UNIT_MEAS_LOOKUP_CODE
, UM.UOM_CLASS
, UM.DESCRIPTION
, QL.PROJECT_ID
, PJ.NAME
, QL.TASK_ID
, TK.TASK_NAME
, QL.HAZARD_CLASS_ID
, HC.HAZARD_CLASS
, QL.UN_NUMBER_ID
, UN.UN_NUMBER
, QL.FROM_HEADER_ID
, FH.SEGMENT1
, QL.FROM_LINE_ID
, FL.LINE_NUM
, QL.CREATION_DATE
, QL.CREATED_BY
, QL.LAST_UPDATE_DATE
, QL.LAST_UPDATED_BY
FROM PO_LINES_ALL QL
, PO_HEADERS_ALL QU
, HR_ALL_ORGANIZATION_UNITS OP
, PO_HAZARD_CLASSES HC
, PO_UN_NUMBERS UN
, MTL_CATEGORIES CT
, MTL_ITEM_REVISIONS IR
, MTL_SYSTEM_ITEMS SI
, FINANCIALS_SYSTEM_PARAMS_ALL FP
, MTL_PARAMETERS MP
, PO_LINE_TYPES LT
, MTL_UNITS_OF_MEASURE UM
, PA_PROJECTS_ALL PJ
, PA_TASKS TK
, PO_HEADERS_ALL FH
, PO_LINES_ALL FL
WHERE QU.TYPE_LOOKUP_CODE = 'QUOTATION'
AND QU.ORG_ID = FP.ORG_ID
AND FP.INVENTORY_ORGANIZATION_ID = MP.ORGANIZATION_ID
AND QL.PO_HEADER_ID = QU.PO_HEADER_ID
AND QL.ORG_ID = OP.ORGANIZATION_ID
AND QL.HAZARD_CLASS_ID = HC.HAZARD_CLASS_ID(+)
AND QL.UN_NUMBER_ID = UN.UN_NUMBER_ID(+)
AND QL.CATEGORY_ID = CT.CATEGORY_ID(+)
AND QL.ITEM_REVISION = IR.REVISION(+)
AND QL.ITEM_ID = IR.INVENTORY_ITEM_ID(+)
AND NVL(IR.ORGANIZATION_ID
, FP.INVENTORY_ORGANIZATION_ID) = FP.INVENTORY_ORGANIZATION_ID
AND QL.ITEM_ID = SI.INVENTORY_ITEM_ID(+)
AND NVL(SI.ORGANIZATION_ID
, FP.INVENTORY_ORGANIZATION_ID) = FP.INVENTORY_ORGANIZATION_ID
AND QL.LINE_TYPE_ID = LT.LINE_TYPE_ID(+)
AND QL.UNIT_MEAS_LOOKUP_CODE = UM.UNIT_OF_MEASURE(+)
AND QL.PROJECT_ID = PJ.PROJECT_ID(+)
AND QL.TASK_ID = TK.TASK_ID(+)
AND QL.FROM_HEADER_ID = FH.PO_HEADER_ID(+)
AND QL.FROM_LINE_ID = FL.PO_LINE_ID(+)
AND '_SEC:QL.ORG_ID' IS NOT NULL WITH READ ONLY

Columns