View: POBV_QUOTATIONS

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

View Text

SELECT QU.PO_HEADER_ID
, QU.SEGMENT1
, QU.ORG_ID
, OP.NAME
, '_LA:QU.QUOTATION_CLASS_CODE:PO_LOOKUP_CODES:QUOTATION CLASS:DISPLAYED_FIELD'
, QT.TYPE_NAME
, '_LA:QU.STATUS_LOOKUP_CODE:PO_LOOKUP_CODES:RFQ/QUOTE STATUS:DISPLAYED_FIELD'
, QU.COMMENTS
, QU.START_DATE
, QU.END_DATE
, '_LA:QU.APPROVAL_REQUIRED_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD'
, '_LA:QU.FREIGHT_TERMS_LOOKUP_CODE:PO_LOOKUP_CODES:FREIGHT TERMS:DISPLAYED_FIELD'
, '_LA:QU.FOB_LOOKUP_CODE:AR_LOOKUPS:FOB:MEANING'
, QU.RATE
, QU.RATE_DATE
, '_LA:QU.REPLY_METHOD_LOOKUP_CODE:PO_LOOKUP_CODES:REPLY/RECEIVE VIA:DISPLAYED_FIELD'
, QU.REPLY_DATE
, QU.QUOTE_WARNING_DELAY
, QU.NOTE_TO_VENDOR
, QU.QUOTE_VENDOR_QUOTE_NUMBER
, QU.PRINT_COUNT
, QU.PRINTED_DATE
, QU.VENDOR_ID
, QU.VENDOR_SITE_ID
, QU.VENDOR_CONTACT_ID
, QU.AGENT_ID
, QU.BILL_TO_LOCATION_ID
, QU.SHIP_TO_LOCATION_ID
, QU.CURRENCY_CODE
, QU.RATE_TYPE
, QU.FROM_HEADER_ID
, QU.FROM_TYPE_LOOKUP_CODE
, QU.TERMS_ID
, QU.SHIP_VIA_LOOKUP_CODE
, QU.CREATION_DATE
, QU.CREATED_BY
, QU.LAST_UPDATE_DATE
, QU.LAST_UPDATED_BY
FROM PO_HEADERS_ALL QU
, PO_DOCUMENT_TYPES_ALL QT
, HR_ALL_ORGANIZATION_UNITS OP
WHERE QU.TYPE_LOOKUP_CODE = 'QUOTATION'
AND QU.QUOTE_TYPE_LOOKUP_CODE = QT.DOCUMENT_SUBTYPE(+)
AND QU.ORG_ID = OP.ORGANIZATION_ID
AND '_SEC:QU.ORG_ID' IS NOT NULL WITH READ ONLY

Columns