VIEW: APPS.POBV_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, ql.ITEM_ID, ql.ITEM_REVISION, ql.CATEGORY_ID, ql.UNIT_MEAS_LOOKUP_CODE, ql.PROJECT_ID, ql.TASK_ID, ql.HAZARD_CLASS_ID, ql.UN_NUMBER_ID, ql.FROM_HEADER_ID, ql.FROM_LINE_ID, 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, PO_LINE_TYPES LT, HR_ALL_ORGANIZATION_UNITS OP WHERE QU.TYPE_LOOKUP_CODE = 'QUOTATION' AND QL.PO_HEADER_ID = QU.PO_HEADER_ID AND QL.ORG_ID = OP.ORGANIZATION_ID AND QL.LINE_TYPE_ID = LT.LINE_TYPE_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
, QL.ITEM_ID
, QL.ITEM_REVISION
, QL.CATEGORY_ID
, QL.UNIT_MEAS_LOOKUP_CODE
, QL.PROJECT_ID
, QL.TASK_ID
, QL.HAZARD_CLASS_ID
, QL.UN_NUMBER_ID
, QL.FROM_HEADER_ID
, QL.FROM_LINE_ID
, 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
, PO_LINE_TYPES LT
, HR_ALL_ORGANIZATION_UNITS OP
WHERE QU.TYPE_LOOKUP_CODE = 'QUOTATION'
AND QL.PO_HEADER_ID = QU.PO_HEADER_ID
AND QL.ORG_ID = OP.ORGANIZATION_ID
AND QL.LINE_TYPE_ID = LT.LINE_TYPE_ID(+) WITH READ ONLY