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.

VIEW: APPS.OKX_QUOTE_HEADERS_V

Source

View Text - Preformatted


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

View Text - HTML Formatted

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