View: OKX_QUOTE_HEADERS_V

Product:	OKX - Contracts Integration
Description:	Quote header information
Implementation/DBA Data:	APPS.OKX_QUOTE_HEADERS_V

View Text

SELECT HDR.QUOTE_HEADER_ID ID1
, '#' ID2
, HDR.ORG_ID ORG_ID
, TO_CHAR(HDR.QUOTE_NUMBER) NAME
, HDR.QUOTE_NAME DESCRIPTION
, HDR.QUOTE_NUMBER QUOTE_NUMBER
, HDR.QUOTE_VERSION QUOTE_VERSION
, HDR.CURRENCY_CODE CURRENCY_CODE
, HDR.TOTAL_QUOTE_PRICE TOTAL_QUOTE_PRICE
, QS.STATUS_CODE B_STATUS
, HDR.CONTRACT_ID CONTRACT_ID
, DECODE(QS.STATUS_CODE
, 'ACCEPTED'
, 'A'
, 'I') STATUS
, HDR.QUOTE_SOURCE_CODE QUOTE_SOURCE_CODE
, HDR.QUOTE_EXPIRATION_DATE QUOTE_EXPIRATION_DATE
, HDR.PARTY_ID PARTY_ID
, HDR.CUST_ACCOUNT_ID CUST_ACCOUNT_ID
, HDR.ORG_CONTACT_ID ORG_CONTACT_ID
, HDR.ORDER_ID ORDER_ID
, QS.EFFECTIVE_START_DATE START_DATE_ACTIVE
, HDR.ORDER_TYPE_ID
, QS.EFFECTIVE_END_DATE END_DATE_ACTIVE
, HDR.PRICE_LIST_ID PRICE_LIST_ID
, HDR.INVOICING_RULE_ID INVOICING_RULE_ID
, HDR.INVOICE_TO_PARTY_SITE_ID INVOICE_TO_PARTY_SITE_ID
, HDR.INVOICE_TO_PARTY_ID INVOICE_TO_PARTY_ID
, HDR.EXCHANGE_RATE EXCHANGE_RATE
, HDR.EXCHANGE_RATE_DATE EXCHANGE_RATE_DATE
, HDR.EXCHANGE_TYPE_CODE EXCHANGE_TYPE_CODE
, HDR.TOTAL_LIST_PRICE TOTAL_LIST_PRICE
, HDR.TOTAL_ADJUSTED_AMOUNT TOTAL_ADJUSTED_AMOUNT
, HDR.RESOURCE_ID RESOURCE_ID
, HDR.INVOICE_TO_CUST_ACCOUNT_ID INVOICE_TO_CUST_ACCOUNT_ID
, HDR.LAST_UPDATE_DATE LAST_UPDATE_DATE
FROM ASO_QUOTE_STATUSES_B QS
, ASO_QUOTE_HEADERS_ALL HDR
WHERE QS.QUOTE_STATUS_ID = HDR.QUOTE_STATUS_ID

Columns