VIEW: APPS.POFV_QUOTATION_LINES

Source

View Text - Preformatted

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, ql.RETAINAGE_RATE, ql.MAX_RETAINAGE_AMOUNT, ql.PROGRESS_PAYMENT_RATE, ql.RECOUPMENT_RATE, ql.TAX_ATTRIBUTE_UPDATE_CODE 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(+) WITH READ ONLY

View Text - HTML Formatted

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
, QL.RETAINAGE_RATE
, QL.MAX_RETAINAGE_AMOUNT
, QL.PROGRESS_PAYMENT_RATE
, QL.RECOUPMENT_RATE
, QL.TAX_ATTRIBUTE_UPDATE_CODE
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(+) WITH READ ONLY