VIEW: ASO.ASO_QUOTE_HEADERS_ALL#

Source

View Text - Preformatted

select QUOTE_HEADER_ID QUOTE_HEADER_ID, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, ORG_ID ORG_ID, QUOTE_NAME QUOTE_NAME, QUOTE_NUMBER QUOTE_NUMBER, QUOTE_VERSION QUOTE_VERSION, QUOTE_STATUS_ID QUOTE_STATUS_ID, QUOTE_SOURCE_CODE QUOTE_SOURCE_CODE, QUOTE_EXPIRATION_DATE QUOTE_EXPIRATION_DATE, PRICE_FROZEN_DATE PRICE_FROZEN_DATE, QUOTE_PASSWORD QUOTE_PASSWORD, ORIGINAL_SYSTEM_REFERENCE ORIGINAL_SYSTEM_REFERENCE, PARTY_ID PARTY_ID, CUST_ACCOUNT_ID CUST_ACCOUNT_ID, ORG_CONTACT_ID ORG_CONTACT_ID, PHONE_ID PHONE_ID, INVOICE_TO_PARTY_SITE_ID INVOICE_TO_PARTY_SITE_ID, INVOICE_TO_PARTY_ID INVOICE_TO_PARTY_ID, ORIG_MKTG_SOURCE_CODE_ID ORIG_MKTG_SOURCE_CODE_ID, MARKETING_SOURCE_CODE_ID MARKETING_SOURCE_CODE_ID, ORDER_TYPE_ID ORDER_TYPE_ID, QUOTE_CATEGORY_CODE QUOTE_CATEGORY_CODE, ORDERED_DATE ORDERED_DATE, ACCOUNTING_RULE_ID ACCOUNTING_RULE_ID, INVOICING_RULE_ID INVOICING_RULE_ID, EMPLOYEE_PERSON_ID EMPLOYEE_PERSON_ID, PRICE_LIST_ID PRICE_LIST_ID, CURRENCY_CODE CURRENCY_CODE, TOTAL_LIST_PRICE TOTAL_LIST_PRICE, TOTAL_ADJUSTED_AMOUNT TOTAL_ADJUSTED_AMOUNT, TOTAL_ADJUSTED_PERCENT TOTAL_ADJUSTED_PERCENT, TOTAL_TAX TOTAL_TAX, TOTAL_SHIPPING_CHARGE TOTAL_SHIPPING_CHARGE, SURCHARGE SURCHARGE, TOTAL_QUOTE_PRICE TOTAL_QUOTE_PRICE, PAYMENT_AMOUNT PAYMENT_AMOUNT, EXCHANGE_RATE EXCHANGE_RATE, EXCHANGE_TYPE_CODE EXCHANGE_TYPE_CODE, EXCHANGE_RATE_DATE EXCHANGE_RATE_DATE, CONTRACT_ID CONTRACT_ID, SALES_CHANNEL_CODE SALES_CHANNEL_CODE, ORDER_ID ORDER_ID, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, SECURITY_GROUP_ID SECURITY_GROUP_ID, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, INVOICE_TO_CUST_ACCOUNT_ID INVOICE_TO_CUST_ACCOUNT_ID, RESOURCE_ID RESOURCE_ID, CONTRACT_TEMPLATE_ID CONTRACT_TEMPLATE_ID, CONTRACT_TEMPLATE_MAJOR_VER CONTRACT_TEMPLATE_MAJOR_VER, CONTRACT_REQUESTER_ID CONTRACT_REQUESTER_ID, CONTRACT_APPROVAL_LEVEL CONTRACT_APPROVAL_LEVEL, PUBLISH_FLAG PUBLISH_FLAG, RESOURCE_GRP_ID RESOURCE_GRP_ID, SOLD_TO_PARTY_SITE_ID SOLD_TO_PARTY_SITE_ID, DISPLAY_ARITHMETIC_OPERATOR DISPLAY_ARITHMETIC_OPERATOR, MAX_VERSION_FLAG MAX_VERSION_FLAG, QUOTE_DESCRIPTION QUOTE_DESCRIPTION, QUOTE_TYPE QUOTE_TYPE, MINISITE_ID MINISITE_ID, CUST_PARTY_ID CUST_PARTY_ID, INVOICE_TO_CUST_PARTY_ID INVOICE_TO_CUST_PARTY_ID, PRICING_STATUS_INDICATOR PRICING_STATUS_INDICATOR, TAX_STATUS_INDICATOR TAX_STATUS_INDICATOR, PRICE_UPDATED_DATE PRICE_UPDATED_DATE, TAX_UPDATED_DATE TAX_UPDATED_DATE, RECALCULATE_FLAG RECALCULATE_FLAG, PRICE_REQUEST_ID PRICE_REQUEST_ID, CREDIT_UPDATE_DATE CREDIT_UPDATE_DATE, CUSTOMER_NAME_AND_TITLE CUSTOMER_NAME_AND_TITLE, CUSTOMER_SIGNATURE_DATE CUSTOMER_SIGNATURE_DATE, SUPPLIER_NAME_AND_TITLE SUPPLIER_NAME_AND_TITLE, SUPPLIER_SIGNATURE_DATE SUPPLIER_SIGNATURE_DATE, END_CUSTOMER_PARTY_ID END_CUSTOMER_PARTY_ID, END_CUSTOMER_PARTY_SITE_ID END_CUSTOMER_PARTY_SITE_ID, END_CUSTOMER_CUST_ACCOUNT_ID END_CUSTOMER_CUST_ACCOUNT_ID, END_CUSTOMER_CUST_PARTY_ID END_CUSTOMER_CUST_PARTY_ID, AUTOMATIC_PRICE_FLAG AUTOMATIC_PRICE_FLAG, AUTOMATIC_TAX_FLAG AUTOMATIC_TAX_FLAG, ASSISTANCE_REQUESTED ASSISTANCE_REQUESTED, ASSISTANCE_REASON_CODE ASSISTANCE_REASON_CODE, HEADER_PAYNOW_CHARGES HEADER_PAYNOW_CHARGES, ATTRIBUTE16 ATTRIBUTE16, ATTRIBUTE17 ATTRIBUTE17, ATTRIBUTE18 ATTRIBUTE18, ATTRIBUTE19 ATTRIBUTE19, ATTRIBUTE20 ATTRIBUTE20 from "ASO"."ASO_QUOTE_HEADERS_ALL"

View Text - HTML Formatted

SELECT QUOTE_HEADER_ID QUOTE_HEADER_ID
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, ORG_ID ORG_ID
, QUOTE_NAME QUOTE_NAME
, QUOTE_NUMBER QUOTE_NUMBER
, QUOTE_VERSION QUOTE_VERSION
, QUOTE_STATUS_ID QUOTE_STATUS_ID
, QUOTE_SOURCE_CODE QUOTE_SOURCE_CODE
, QUOTE_EXPIRATION_DATE QUOTE_EXPIRATION_DATE
, PRICE_FROZEN_DATE PRICE_FROZEN_DATE
, QUOTE_PASSWORD QUOTE_PASSWORD
, ORIGINAL_SYSTEM_REFERENCE ORIGINAL_SYSTEM_REFERENCE
, PARTY_ID PARTY_ID
, CUST_ACCOUNT_ID CUST_ACCOUNT_ID
, ORG_CONTACT_ID ORG_CONTACT_ID
, PHONE_ID PHONE_ID
, INVOICE_TO_PARTY_SITE_ID INVOICE_TO_PARTY_SITE_ID
, INVOICE_TO_PARTY_ID INVOICE_TO_PARTY_ID
, ORIG_MKTG_SOURCE_CODE_ID ORIG_MKTG_SOURCE_CODE_ID
, MARKETING_SOURCE_CODE_ID MARKETING_SOURCE_CODE_ID
, ORDER_TYPE_ID ORDER_TYPE_ID
, QUOTE_CATEGORY_CODE QUOTE_CATEGORY_CODE
, ORDERED_DATE ORDERED_DATE
, ACCOUNTING_RULE_ID ACCOUNTING_RULE_ID
, INVOICING_RULE_ID INVOICING_RULE_ID
, EMPLOYEE_PERSON_ID EMPLOYEE_PERSON_ID
, PRICE_LIST_ID PRICE_LIST_ID
, CURRENCY_CODE CURRENCY_CODE
, TOTAL_LIST_PRICE TOTAL_LIST_PRICE
, TOTAL_ADJUSTED_AMOUNT TOTAL_ADJUSTED_AMOUNT
, TOTAL_ADJUSTED_PERCENT TOTAL_ADJUSTED_PERCENT
, TOTAL_TAX TOTAL_TAX
, TOTAL_SHIPPING_CHARGE TOTAL_SHIPPING_CHARGE
, SURCHARGE SURCHARGE
, TOTAL_QUOTE_PRICE TOTAL_QUOTE_PRICE
, PAYMENT_AMOUNT PAYMENT_AMOUNT
, EXCHANGE_RATE EXCHANGE_RATE
, EXCHANGE_TYPE_CODE EXCHANGE_TYPE_CODE
, EXCHANGE_RATE_DATE EXCHANGE_RATE_DATE
, CONTRACT_ID CONTRACT_ID
, SALES_CHANNEL_CODE SALES_CHANNEL_CODE
, ORDER_ID ORDER_ID
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, INVOICE_TO_CUST_ACCOUNT_ID INVOICE_TO_CUST_ACCOUNT_ID
, RESOURCE_ID RESOURCE_ID
, CONTRACT_TEMPLATE_ID CONTRACT_TEMPLATE_ID
, CONTRACT_TEMPLATE_MAJOR_VER CONTRACT_TEMPLATE_MAJOR_VER
, CONTRACT_REQUESTER_ID CONTRACT_REQUESTER_ID
, CONTRACT_APPROVAL_LEVEL CONTRACT_APPROVAL_LEVEL
, PUBLISH_FLAG PUBLISH_FLAG
, RESOURCE_GRP_ID RESOURCE_GRP_ID
, SOLD_TO_PARTY_SITE_ID SOLD_TO_PARTY_SITE_ID
, DISPLAY_ARITHMETIC_OPERATOR DISPLAY_ARITHMETIC_OPERATOR
, MAX_VERSION_FLAG MAX_VERSION_FLAG
, QUOTE_DESCRIPTION QUOTE_DESCRIPTION
, QUOTE_TYPE QUOTE_TYPE
, MINISITE_ID MINISITE_ID
, CUST_PARTY_ID CUST_PARTY_ID
, INVOICE_TO_CUST_PARTY_ID INVOICE_TO_CUST_PARTY_ID
, PRICING_STATUS_INDICATOR PRICING_STATUS_INDICATOR
, TAX_STATUS_INDICATOR TAX_STATUS_INDICATOR
, PRICE_UPDATED_DATE PRICE_UPDATED_DATE
, TAX_UPDATED_DATE TAX_UPDATED_DATE
, RECALCULATE_FLAG RECALCULATE_FLAG
, PRICE_REQUEST_ID PRICE_REQUEST_ID
, CREDIT_UPDATE_DATE CREDIT_UPDATE_DATE
, CUSTOMER_NAME_AND_TITLE CUSTOMER_NAME_AND_TITLE
, CUSTOMER_SIGNATURE_DATE CUSTOMER_SIGNATURE_DATE
, SUPPLIER_NAME_AND_TITLE SUPPLIER_NAME_AND_TITLE
, SUPPLIER_SIGNATURE_DATE SUPPLIER_SIGNATURE_DATE
, END_CUSTOMER_PARTY_ID END_CUSTOMER_PARTY_ID
, END_CUSTOMER_PARTY_SITE_ID END_CUSTOMER_PARTY_SITE_ID
, END_CUSTOMER_CUST_ACCOUNT_ID END_CUSTOMER_CUST_ACCOUNT_ID
, END_CUSTOMER_CUST_PARTY_ID END_CUSTOMER_CUST_PARTY_ID
, AUTOMATIC_PRICE_FLAG AUTOMATIC_PRICE_FLAG
, AUTOMATIC_TAX_FLAG AUTOMATIC_TAX_FLAG
, ASSISTANCE_REQUESTED ASSISTANCE_REQUESTED
, ASSISTANCE_REASON_CODE ASSISTANCE_REASON_CODE
, HEADER_PAYNOW_CHARGES HEADER_PAYNOW_CHARGES
, ATTRIBUTE16 ATTRIBUTE16
, ATTRIBUTE17 ATTRIBUTE17
, ATTRIBUTE18 ATTRIBUTE18
, ATTRIBUTE19 ATTRIBUTE19
, ATTRIBUTE20 ATTRIBUTE20
FROM "ASO"."ASO_QUOTE_HEADERS_ALL"