eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: POBV_RFQ_LINES

Product:	PO - Purchasing
Description:	- Retrofitted
Implementation/DBA Data:	APPS.POBV_RFQ_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
, 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

Columns

Name
RFQ_LINE_ID
LINE_NUMBER
RFQ_ID
RFQ_DOCUMENT_NUMBER
OPERATING_UNIT_ID
OPERATING_UNIT_NAME
LINE_TYPE
ITEM_DESCRIPTION
UNIT_PRICE
MAXIMUM_ORDER_QUANTITY
MINIMUM_ORDER_QUANTITY
SUPPLIER_NOTE
SUPPLIER_PRODUCT_NUMBER
ITEM_ID
ITEM_REVISION
CATEGORY_ID
UNIT_OF_MEASURE
PROJECT_ID
TASK_ID
HAZARD_CLASS_ID
UN_NUMBER_ID
CREATED_DATE
CREATED_BY
LAST_UPDATED_DATE
LAST_UPDATED_BY