VIEW: APPS.ASO_PVT_QUOTE_HEADERS_UI_V

Source

View Text - Preformatted

SELECT ASO_QUOTES.ROWID , ASO_QUOTES.QUOTE_HEADER_ID , ASO_QUOTES.ORDER_ID , ASO_QUOTES.ORG_ID , ASO_QUOTES.LAST_UPDATE_DATE , ASO_QUOTES.LAST_UPDATED_BY , ASO_QUOTES.CREATION_DATE , ASO_QUOTES.CREATED_BY , ASO_QUOTES.LAST_UPDATE_LOGIN , ASO_QUOTES.REQUEST_ID, ASO_QUOTES.PROGRAM_APPLICATION_ID , ASO_QUOTES.PROGRAM_ID , ASO_QUOTES.PROGRAM_UPDATE_DATE , ASO_QUOTES.ORIGINAL_SYSTEM_REFERENCE , ASO_QUOTES.EMPLOYEE_PERSON_ID , ASO_QUOTES.RESOURCE_ID, ASO_QUOTES.PRICE_LIST_ID , ASO_QUOTES.QUOTE_STATUS_ID , ASO_QUOTES.QUOTE_SOURCE_CODE , ASO_QUOTES.party_id sold_to_contact_party_id, ASO_QUOTES.CUST_ACCOUNT_ID sold_to_cust_acct_id, ASO_QUOTES.CUST_PARTY_ID, ASO_QUOTES.ORG_CONTACT_ID , ASO_QUOTES.PHONE_ID , ASO_QUOTES.QUOTE_NAME , ASO_QUOTES.QUOTE_NUMBER , ASO_QUOTES.QUOTE_VERSION , ASO_QUOTES.QUOTE_EXPIRATION_DATE , ASO_QUOTES.QUOTE_CATEGORY_CODE , ASO_QUOTES.CURRENCY_CODE , ASO_QUOTES.EXCHANGE_RATE , ASO_QUOTES.EXCHANGE_TYPE_CODE , ASO_QUOTES.EXCHANGE_RATE_DATE , ASO_QUOTES.ORIG_MKTG_SOURCE_CODE_ID , ASO_QUOTES.MARKETING_SOURCE_CODE_ID , ASO_QUOTES.ORDERED_DATE ORDERED_DATE , ASO_QUOTES.ORDER_TYPE_ID , ASO_QUOTES.TOTAL_LIST_PRICE , ASO_QUOTES.TOTAL_ADJUSTED_AMOUNT , ASO_QUOTES.TOTAL_ADJUSTED_PERCENT , ASO_QUOTES.TOTAL_TAX , ASO_QUOTES.SURCHARGE , ASO_QUOTES.TOTAL_SHIPPING_CHARGE , ASO_QUOTES.TOTAL_QUOTE_PRICE , ASO_QUOTES.ACCOUNTING_RULE_ID , ASO_QUOTES.INVOICING_RULE_ID , ASO_QUOTES.INVOICE_TO_PARTY_SITE_ID , ASO_QUOTES.INVOICE_TO_PARTY_ID, aso_quotes.invoice_TO_CUST_ACCOUNT_ID, ASO_QUOTES.INVOICE_TO_CUST_PARTY_ID, ASO_QUOTES.END_CUSTOMER_PARTY_ID, ASO_QUOTES.END_CUSTOMER_CUST_PARTY_ID, ASO_QUOTES.END_CUSTOMER_PARTY_SITE_ID, ASO_QUOTES.END_CUSTOMER_CUST_ACCOUNT_ID, ASO_QUOTES.AUTOMATIC_PRICE_FLAG, ASO_QUOTES.AUTOMATIC_TAX_FLAG, ASO_QUOTES.ASSISTANCE_REQUESTED, ASO_QUOTES.ASSISTANCE_REASON_CODE, ASO_QUOTES.HEADER_PAYNOW_CHARGES, ASO_QUOTES.CONTRACT_ID , ASO_QUOTES.PRICE_FROZEN_DATE , ASO_QUOTES.QUOTE_PASSWORD , ASO_QUOTES.PAYMENT_AMOUNT , ASO_QUOTES.SALES_CHANNEL_CODE , ASO_QUOTES.CONTRACT_TEMPLATE_ID, ASO_QUOTES.CONTRACT_TEMPLATE_MAJOR_VER, ASO_QUOTES.CONTRACT_REQUESTER_ID, ASO_QUOTES.CONTRACT_APPROVAL_LEVEL, ASO_QUOTES.PUBLISH_FLAG, ASO_QUOTES.RESOURCE_GRP_ID, ASO_QUOTES.SOLD_TO_PARTY_SITE_ID, ASO_QUOTES.QUOTE_TYPE, ASO_QUOTES.QUOTE_DESCRIPTION, ASO_QUOTES.display_arithmetic_operator, ASO_QUOTES.max_version_flag, ASO_QUOTES.object_version_number, ASO_QUOTES.pricing_status_indicator, ASO_QUOTES.tax_status_indicator, ASO_QUOTES.price_updated_date, ASO_QUOTES.tax_updated_date, ASO_QUOTES.recalculate_flag, ASO_QUOTES.price_request_id, 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, ASO_QUOTES.ATTRIBUTE16, ASO_QUOTES.ATTRIBUTE17, ASO_QUOTES.ATTRIBUTE18, ASO_QUOTES.ATTRIBUTE19, ASO_QUOTES.ATTRIBUTE20, ASO_QUOTES.credit_update_date FROM ASO_QUOTE_HEADERS ASO_QUOTES

View Text - HTML Formatted

SELECT ASO_QUOTES.ROWID
, ASO_QUOTES.QUOTE_HEADER_ID
, ASO_QUOTES.ORDER_ID
, ASO_QUOTES.ORG_ID
, ASO_QUOTES.LAST_UPDATE_DATE
, ASO_QUOTES.LAST_UPDATED_BY
, ASO_QUOTES.CREATION_DATE
, ASO_QUOTES.CREATED_BY
, ASO_QUOTES.LAST_UPDATE_LOGIN
, ASO_QUOTES.REQUEST_ID
, ASO_QUOTES.PROGRAM_APPLICATION_ID
, ASO_QUOTES.PROGRAM_ID
, ASO_QUOTES.PROGRAM_UPDATE_DATE
, ASO_QUOTES.ORIGINAL_SYSTEM_REFERENCE
, ASO_QUOTES.EMPLOYEE_PERSON_ID
, ASO_QUOTES.RESOURCE_ID
, ASO_QUOTES.PRICE_LIST_ID
, ASO_QUOTES.QUOTE_STATUS_ID
, ASO_QUOTES.QUOTE_SOURCE_CODE
, ASO_QUOTES.PARTY_ID SOLD_TO_CONTACT_PARTY_ID
, ASO_QUOTES.CUST_ACCOUNT_ID SOLD_TO_CUST_ACCT_ID
, ASO_QUOTES.CUST_PARTY_ID
, ASO_QUOTES.ORG_CONTACT_ID
, ASO_QUOTES.PHONE_ID
, ASO_QUOTES.QUOTE_NAME
, ASO_QUOTES.QUOTE_NUMBER
, ASO_QUOTES.QUOTE_VERSION
, ASO_QUOTES.QUOTE_EXPIRATION_DATE
, ASO_QUOTES.QUOTE_CATEGORY_CODE
, ASO_QUOTES.CURRENCY_CODE
, ASO_QUOTES.EXCHANGE_RATE
, ASO_QUOTES.EXCHANGE_TYPE_CODE
, ASO_QUOTES.EXCHANGE_RATE_DATE
, ASO_QUOTES.ORIG_MKTG_SOURCE_CODE_ID
, ASO_QUOTES.MARKETING_SOURCE_CODE_ID
, ASO_QUOTES.ORDERED_DATE ORDERED_DATE
, ASO_QUOTES.ORDER_TYPE_ID
, ASO_QUOTES.TOTAL_LIST_PRICE
, ASO_QUOTES.TOTAL_ADJUSTED_AMOUNT
, ASO_QUOTES.TOTAL_ADJUSTED_PERCENT
, ASO_QUOTES.TOTAL_TAX
, ASO_QUOTES.SURCHARGE
, ASO_QUOTES.TOTAL_SHIPPING_CHARGE
, ASO_QUOTES.TOTAL_QUOTE_PRICE
, ASO_QUOTES.ACCOUNTING_RULE_ID
, ASO_QUOTES.INVOICING_RULE_ID
, ASO_QUOTES.INVOICE_TO_PARTY_SITE_ID
, ASO_QUOTES.INVOICE_TO_PARTY_ID
, ASO_QUOTES.INVOICE_TO_CUST_ACCOUNT_ID
, ASO_QUOTES.INVOICE_TO_CUST_PARTY_ID
, ASO_QUOTES.END_CUSTOMER_PARTY_ID
, ASO_QUOTES.END_CUSTOMER_CUST_PARTY_ID
, ASO_QUOTES.END_CUSTOMER_PARTY_SITE_ID
, ASO_QUOTES.END_CUSTOMER_CUST_ACCOUNT_ID
, ASO_QUOTES.AUTOMATIC_PRICE_FLAG
, ASO_QUOTES.AUTOMATIC_TAX_FLAG
, ASO_QUOTES.ASSISTANCE_REQUESTED
, ASO_QUOTES.ASSISTANCE_REASON_CODE
, ASO_QUOTES.HEADER_PAYNOW_CHARGES
, ASO_QUOTES.CONTRACT_ID
, ASO_QUOTES.PRICE_FROZEN_DATE
, ASO_QUOTES.QUOTE_PASSWORD
, ASO_QUOTES.PAYMENT_AMOUNT
, ASO_QUOTES.SALES_CHANNEL_CODE
, ASO_QUOTES.CONTRACT_TEMPLATE_ID
, ASO_QUOTES.CONTRACT_TEMPLATE_MAJOR_VER
, ASO_QUOTES.CONTRACT_REQUESTER_ID
, ASO_QUOTES.CONTRACT_APPROVAL_LEVEL
, ASO_QUOTES.PUBLISH_FLAG
, ASO_QUOTES.RESOURCE_GRP_ID
, ASO_QUOTES.SOLD_TO_PARTY_SITE_ID
, ASO_QUOTES.QUOTE_TYPE
, ASO_QUOTES.QUOTE_DESCRIPTION
, ASO_QUOTES.DISPLAY_ARITHMETIC_OPERATOR
, ASO_QUOTES.MAX_VERSION_FLAG
, ASO_QUOTES.OBJECT_VERSION_NUMBER
, ASO_QUOTES.PRICING_STATUS_INDICATOR
, ASO_QUOTES.TAX_STATUS_INDICATOR
, ASO_QUOTES.PRICE_UPDATED_DATE
, ASO_QUOTES.TAX_UPDATED_DATE
, ASO_QUOTES.RECALCULATE_FLAG
, ASO_QUOTES.PRICE_REQUEST_ID
, 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
, ASO_QUOTES.ATTRIBUTE16
, ASO_QUOTES.ATTRIBUTE17
, ASO_QUOTES.ATTRIBUTE18
, ASO_QUOTES.ATTRIBUTE19
, ASO_QUOTES.ATTRIBUTE20
, ASO_QUOTES.CREDIT_UPDATE_DATE
FROM ASO_QUOTE_HEADERS ASO_QUOTES