View: ASO_QUOTE_HEADERS_V

Product:	ASO - Order Capture
Description:	quotations
Implementation/DBA Data:	APPS.ASO_QUOTE_HEADERS_V

View Text

SELECT ASO_QUOTES.ROWID ROW_ID
, ASO_QUOTES.QUOTE_HEADER_ID QUOTE_HEADER_ID
, ASO_QUOTES.ORDER_ID ORDER_ID
, ASO_QUOTES.ORG_ID ORG_ID
, ASO_QUOTES.LAST_UPDATE_DATE LAST_UPDATE_DATE
, ASO_QUOTES.LAST_UPDATED_BY LAST_UPDATED_BY
, ASO_QUOTES.CREATION_DATE CREATION_DATE
, ASO_QUOTES.CREATED_BY CREATED_BY
, ASO_QUOTES.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, ASO_QUOTES.REQUEST_ID REQUEST_ID
, ASO_QUOTES.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, ASO_QUOTES.PROGRAM_ID PROGRAM_ID
, ASO_QUOTES.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, ASO_QUOTES.ORIGINAL_SYSTEM_REFERENCE ORIGINAL_SYSTEM_REFERENCE
, ASO_QUOTES.EMPLOYEE_PERSON_ID EMPLOYEE_PERSON_ID
, ASO_QUOTES.RESOURCE_ID
, NULL SALESREP_FIRST_NAME
, NULL SALESREP_LAST_NAME
, SALES.NAME SALESREP_FULL_NAME
, ASO_QUOTES.PRICE_LIST_ID PRICE_LIST_ID
, I_PRICE_LISTS.NAME PRICE_LIST_NAME
, ASO_QUOTES.QUOTE_STATUS_ID QUOTE_STATUS_ID
, ASO_STATUS_VL.STATUS_CODE QUOTE_STATUS_CODE
, ASO_STATUS_VL.MEANING QUOTE_STATUS
, ASO_STATUS_VL.UPDATE_ALLOWED_FLAG UPDATE_ALLOWED_FLAG
, ASO_STATUS_VL.AUTO_VERSION_FLAG AUTO_VERSION_FLAG
, ASO_QUOTES.QUOTE_SOURCE_CODE QUOTE_SOURCE_CODE
, ASO_QUOTES.PARTY_ID PARTY_ID
, DECODE(I_PARTIES.PARTY_TYPE
, 'PERSON'
, NULL
, I_PARTIES.PARTY_NAME) ORGANIZATION_NAME
, I_PARTIES.PARTY_TYPE PARTY_TYPE
, DECODE(I_PARTIES.PARTY_TYPE
, 'ORGANIZATION'
, I_CONTACT.PERSON_FIRST_NAME
, I_PARTIES.PERSON_FIRST_NAME) PERSON_FIRST_NAME
, DECODE(I_PARTIES.PARTY_TYPE
, 'ORGANIZATION'
, I_CONTACT.PERSON_MIDDLE_NAME
, I_PARTIES.PERSON_MIDDLE_NAME) PERSON_MIDDLE_NAME
, DECODE(I_PARTIES.PARTY_TYPE
, 'ORGANIZATION'
, I_CONTACT.PERSON_LAST_NAME
, I_PARTIES.PERSON_LAST_NAME) PERSON_LAST_NAME
, ASO_QUOTES.CUST_ACCOUNT_ID CUST_ACCOUNT_ID
, I_ACCTS.ACCOUNT_NUMBER ACCOUNT_NUMBER
, ASO_QUOTES.ORG_CONTACT_ID ORG_CONTACT_ID
, ASO_QUOTES.PHONE_ID PHONE_ID
, I_PHONE.PHONE_AREA_CODE PHONE_AREA_CODE
, I_PHONE.PHONE_NUMBER PHONE_NUMBER
, I_PHONE.PHONE_AREA_CODE || DECODE(I_PHONE.PHONE_AREA_CODE
, NULL
, ''
, ' ' ) || I_PHONE.PHONE_NUMBER FULL_PHONE_NUMBER
, I_PHONE.PHONE_EXTENSION PHONE_EXTENSION
, I_PHONE.PHONE_LINE_TYPE PHONE_LINE_TYPE
, ASO_QUOTES.CONTRACT_TEMPLATE_ID CONTRACT_TEMPLATE_ID
, ASO_QUOTES.QUOTE_NAME QUOTE_NAME
, ASO_QUOTES.CONTRACT_TEMPLATE_MAJOR_VER CONTRACT_TEMPLATE_MAJOR_VER
, ASO_QUOTES.CONTRACT_REQUESTER_ID CONTRACT_REQUESTER_ID
, ASO_QUOTES.QUOTE_NUMBER QUOTE_NUMBER
, ASO_QUOTES.CONTRACT_APPROVAL_LEVEL CONTRACT_APPROVAL_LEVEL
, ASO_QUOTES.PUBLISH_FLAG PUBLISH_FLAG
, ASO_QUOTES.QUOTE_VERSION QUOTE_VERSION
, ASO_QUOTES.RESOURCE_GRP_ID RESOURCE_GRP_ID
, ASO_QUOTES.SOLD_TO_PARTY_SITE_ID SOLD_TO_PARTY_SITE_ID
, ASO_QUOTES.QUOTE_EXPIRATION_DATE QUOTE_EXPIRATION_DATE
, ASO_QUOTES.QUOTE_CATEGORY_CODE QUOTE_CATEGORY_CODE
, ASO_QUOTES.CURRENCY_CODE CURRENCY_CODE
, ASO_QUOTES.EXCHANGE_RATE EXCHANGE_RATE
, ASO_QUOTES.EXCHANGE_TYPE_CODE EXCHANGE_TYPE_CODE
, ASO_QUOTES.EXCHANGE_RATE_DATE EXCHANGE_RATE_DATE
, ASO_QUOTES.ORIG_MKTG_SOURCE_CODE_ID ORIG_MKTG_SOURCE_CODE_ID
, ASO_QUOTES.MARKETING_SOURCE_CODE_ID MARKETING_SOURCE_CODE_ID
, NULL
, NULL
, ASO_QUOTES.ORDERED_DATE ORDERED_DATE
, ASO_QUOTES.ORDER_TYPE_ID ORDER_TYPE_ID
, I_ORDER_TYPES.NAME ORDER_TYPE_NAME
, NULL
, NULL
, NULL
, ASO_QUOTES.TOTAL_LIST_PRICE TOTAL_LIST_PRICE
, ASO_QUOTES.TOTAL_ADJUSTED_AMOUNT TOTAL_ADJUSTED_AMOUNT
, ASO_QUOTES.TOTAL_ADJUSTED_PERCENT TOTAL_ADJUSTED_PERCENT
, ASO_QUOTES.TOTAL_TAX TOTAL_TAX
, ASO_QUOTES.SURCHARGE SURCHARGE
, ASO_QUOTES.TOTAL_SHIPPING_CHARGE TOTAL_SHIPPING_CHARGE
, ASO_QUOTES.TOTAL_QUOTE_PRICE TOTAL_QUOTE_PRICE
, ASO_QUOTES.ACCOUNTING_RULE_ID ACCOUNTING_RULE_ID
, ASO_QUOTES.INVOICING_RULE_ID INVOICING_RULE_ID
, ASO_QUOTES.INVOICE_TO_PARTY_ID INVOICE_TO_PARTY_ID
, ASO_QUOTES.INVOICE_TO_PARTY_SITE_ID INVOICE_TO_PARTY_SITE_ID
, ASO_QUOTES.INVOICE_TO_CUST_ACCOUNT_ID INVOICE_TO_CUST_ACCOUNT_ID
, I_ACCTS_INV.CUSTOMER_NAME INVOICE_TO_CUST_NAME
, I_INVOICE_PARTIES.PARTY_NAME INVOICE_TO_PARTY_NAME
, I_INVOICE_PARTIES.PERSON_FIRST_NAME INVOICE_TO_CONTACT_FIRST_NAME
, I_INVOICE_PARTIES.PERSON_MIDDLE_NAME INVOICE_TO_CONTACT_MIDDLE_NAME
, I_INVOICE_PARTIES.PERSON_LAST_NAME INVOICE_TO_CONTACT_LAST_NAME
, I_INVOICE_LOCATIONS.ADDRESS1 INVOICE_TO_ADDRESS1
, I_INVOICE_LOCATIONS.ADDRESS2 INVOICE_TO_ADDRESS2
, I_INVOICE_LOCATIONS.ADDRESS3 INVOICE_TO_ADDRESS3
, I_INVOICE_LOCATIONS.ADDRESS4 INVOICE_TO_ADDRESS4
, I_INVOICE_LOCATIONS.COUNTRY_CODE INVOICE_TO_COUNTRY_CODE
, I_INVOICE_LOCATIONS.COUNTRY INVOICE_TO_COUNTRY
, I_INVOICE_LOCATIONS.CITY INVOICE_TO_CITY
, I_INVOICE_LOCATIONS.POSTAL_CODE INVOICE_TO_POSTAL_CODE
, I_INVOICE_LOCATIONS.STATE INVOICE_TO_STATE
, I_INVOICE_LOCATIONS.PROVINCE INVOICE_TO_PROVINCE
, I_INVOICE_LOCATIONS.COUNTY INVOICE_TO_COUNTY
, ASO_QUOTES.CONTRACT_ID CONTRACT_ID
, ASO_QUOTES.PRICE_FROZEN_DATE PRICE_FROZEN_DATE
, ASO_QUOTES.QUOTE_PASSWORD QUOTE_PASSWORD
, ASO_QUOTES.PAYMENT_AMOUNT PAYMENT_AMOUNT
, ASO_QUOTES.SALES_CHANNEL_CODE SALES_CHANNEL_CODE
, ASO_QUOTES.MAX_VERSION_FLAG MAX_VERSION_FLAG
, ASO_QUOTES.DISPLAY_ARITHMETIC_OPERATOR DISPLAY_ARITHMETIC_OPERATOR
, ASO_QUOTES.QUOTE_TYPE
, ASO_QUOTES.ATTRIBUTE_CATEGORY
, ASO_QUOTES.ATTRIBUTE1
, ASO_QUOTES.ATTRIBUTE2
, ASO_QUOTES.ATTRIBUTE3
, ASO_QUOTES.ATTRIBUTE4
, ASO_QUOTES.ATTRIBUTE5
, ASO_QUOTES.ATTRIBUTE6
, ASO_QUOTES.ATTRIBUTE7
, ASO_QUOTES.ATTRIBUTE8
, ASO_QUOTES.ATTRIBUTE9
, ASO_QUOTES.ATTRIBUTE10
, ASO_QUOTES.ATTRIBUTE11
, ASO_QUOTES.ATTRIBUTE12
, ASO_QUOTES.ATTRIBUTE13
, ASO_QUOTES.ATTRIBUTE14
, ASO_QUOTES.ATTRIBUTE15
, I_PARTIES.PARTY_NAME PARTY_NAME
FROM ASO_I_CONTACT_POINTS_V I_PHONE
, ASO_I_CURRENCIES_V I_CURRENCY
, ASO_I_ORDER_TYPES_V I_ORDER_TYPES
, ASO_I_ORG_CONTACT_NW_V I_CONTACT
, ASO_I_PRICE_LISTS_V I_PRICE_LISTS
, ASO_QUOTE_HEADERS_ALL ASO_QUOTES
, ASO_QUOTE_STATUSES_VL ASO_STATUS_VL
, ASO_I_PARTIES_V I_INVOICE_PARTIES
, ASO_I_PARTY_SITES_V I_INVOICE_LOCATIONS
, ASO_I_PARTIES_V I_PARTIES
, ASO_I_CUST_ACCOUNTS_V I_ACCTS
, ASO_I_CUST_ACCOUNTS_V I_ACCTS_INV
, JTF_RS_SRP_VL SALES
WHERE ASO_QUOTES.QUOTE_STATUS_ID = ASO_STATUS_VL.QUOTE_STATUS_ID(+)
AND ASO_QUOTES.PRICE_LIST_ID = I_PRICE_LISTS.PRICE_LIST_ID(+)
AND ASO_QUOTES.PARTY_ID = I_PARTIES.PARTY_ID(+)
AND ASO_QUOTES.ORG_CONTACT_ID = I_CONTACT.ORG_CONTACT_ID(+)
AND ASO_QUOTES.CURRENCY_CODE = I_CURRENCY.CURRENCY_CODE(+)
AND ASO_QUOTES.INVOICE_TO_PARTY_SITE_ID = I_INVOICE_LOCATIONS.PARTY_SITE_ID (+)
AND ASO_QUOTES.INVOICE_TO_PARTY_ID = I_INVOICE_PARTIES.PARTY_ID (+)
AND ASO_QUOTES.ORDER_TYPE_ID = I_ORDER_TYPES.ORDER_TYPE_ID (+)
AND SALES.PERSON_ID (+) = ASO_QUOTES.EMPLOYEE_PERSON_ID
AND SALES.RESOURCE_ID (+) = ASO_QUOTES.RESOURCE_ID
AND I_ACCTS.CUST_ACCOUNT_ID(+) = ASO_QUOTES.CUST_ACCOUNT_ID
AND I_ACCTS_INV.CUST_ACCOUNT_ID(+) = ASO_QUOTES.INVOICE_TO_CUST_ACCOUNT_ID
AND ASO_QUOTES.PHONE_ID = I_PHONE.CONTACT_POINT_ID(+) ORDER BY QUOTE_NUMBER
, QUOTE_VERSION DESC

Columns