Product: | PO - Purchasing |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.POBV_RFQ_LINES |
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.CREATION_DATE
, QL.CREATED_BY
, QL.LAST_UPDATE_DATE
, QL.LAST_UPDATED_BY
FROM PO_LINES_ALL QL
, PO_HEADERS_ALL QU
, PO_LINE_TYPES LT
, HR_ALL_ORGANIZATION_UNITS OP
WHERE QU.TYPE_LOOKUP_CODE = 'RFQ'
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(+)
AND '_SEC:QL.ORG_ID' IS NOT NULL WITH READ ONLY