View: AS_QUOTES_V

View Text

SELECT AS_QUOTES.ROWID ROW_ID
, AS_QUOTES.QUOTE_ID
, AS_QUOTES.LAST_UPDATE_DATE
, AS_QUOTES.LAST_UPDATED_BY
, AS_QUOTES.CREATION_DATE
, AS_QUOTES.CREATED_BY
, AS_QUOTES.LAST_UPDATE_LOGIN
, AS_QUOTES.REQUEST_ID
, AS_QUOTES.PROGRAM_APPLICATION_ID
, AS_QUOTES.PROGRAM_ID
, AS_QUOTES.PROGRAM_UPDATE_DATE
, AS_QUOTES.EMPLOYEE_PERSON_ID
, AS_QUOTES.PRICE_LIST_ID
, AS_QUOTES.QUOTE_STATUS
, AS_QUOTES.CUSTOMER_ID
, AS_QUOTES.ADDRESS_ID
, AS_QUOTES.QUOTE_NAME
, AS_QUOTES.QUOTE_NUMBER
, AS_QUOTES.QUOTE_VERSION
, AS_QUOTES.CURRENCY_CODE
, AS_QUOTES.TOTAL_QUOTE_PRICE
, AS_QUOTES.CONTACT_ID
, AS_QUOTES.DESCRIPTION
, AS_QUOTES.ORIGINAL_QUOTE_ID
, AS_QUOTES.QUOTE_START_DATE
, AS_QUOTES.QUOTE_END_DATE
, AS_QUOTES.QUOTE_LETTER_ID
, AS_QUOTES.EXCHANGE_RATE
, AS_QUOTES.EXCHANGE_TYPE_CODE
, AS_QUOTES.EXCHANGE_RATE_DATE
, AS_QUOTES.LEAD_ID
, AS_QUOTES.PROMOTION_ID
, AS_QUOTES.PURGE_ALLOWED_FLAG
, AS_QUOTES.ORDER_DATE
, AS_QUOTES.ORDER_TYPE_ID
, AS_QUOTES.TAX_EXEMPT_NUM
, AS_QUOTES.TAX_EXEMPT_REASON_CODE
, AS_QUOTES.TOTAL_LIST_PRICE
, AS_QUOTES.TOTAL_DISCOUNT_AMOUNT
, AS_QUOTES.TOTAL_DISCOUNT_PERCENT
, AS_QUOTES.DISCOUNT_MTHD_CODE
, AS_QUOTES.DISCOUNT_ID
, AS_QUOTES.TOTAL_TAX
, AS_QUOTES.SHIP_TO_SITE_USE_ID
, AS_QUOTES.SHIP_TO_CONTACT_ID
, AS_QUOTES.INVOICE_TO_SITE_USE_ID
, AS_QUOTES.INVOICE_TO_CONTACT_ID
, AS_QUOTES.ACCOUNTING_RULE_ID
, AS_QUOTES.INVOICING_RULE_ID
, AS_QUOTES.AGREEMENT_ID
, AS_QUOTES.PAYMENT_TERM_ID
, AS_QUOTES.PURCHASE_ORDER_NUM
, AS_QUOTES.SHIPMENT_PRIORITY_CODE
, AS_QUOTES.SHIP_METHOD_CODE
, AS_QUOTES.FREIGHT_TERMS_CODE
, AS_QUOTES.FOB_CODE
, AS_QUOTES.PAYMENT_TYPE_CODE
, AS_QUOTES.PAYMENT_AMOUNT
, AS_QUOTES.CHECK_NUMBER
, AS_QUOTES.CREDIT_CARD_CODE
, AS_QUOTES.CREDIT_CARD_HOLDER_NAME
, AS_QUOTES.CREDIT_CARD_NUMBER
, AS_QUOTES.CREDIT_CARD_EXPIRATION_DATE
, AS_QUOTES.CREDIT_CARD_APPROVAL_CODE
, AS_QUOTES.ATTRIBUTE_CATEGORY
, AS_QUOTES.ATTRIBUTE1
, AS_QUOTES.ATTRIBUTE2
, AS_QUOTES.ATTRIBUTE3
, AS_QUOTES.ATTRIBUTE4
, AS_QUOTES.ATTRIBUTE5
, AS_QUOTES.ATTRIBUTE6
, AS_QUOTES.ATTRIBUTE7
, AS_QUOTES.ATTRIBUTE8
, AS_QUOTES.ATTRIBUTE9
, AS_QUOTES.ATTRIBUTE10
, AS_QUOTES.ATTRIBUTE11
, AS_QUOTES.ATTRIBUTE12
, AS_QUOTES.ATTRIBUTE13
, AS_QUOTES.ATTRIBUTE14
, AS_QUOTES.ATTRIBUTE15
, AS_QUOTES.SHIPPING_COST
, SO_ORDER_TYPES.NAME ORDER_TYPE_NAME
, RA_RULES.NAME ACCOUNTING_RULE
, RA_RULES_A1.NAME INVOICING_RULE
, SO_PRICE_LISTS.NAME PRICE_LIST_NAME
, AS_LOOKUPS.MEANING STATUS_MEANING
, RA_CUSTOMERS.CUSTOMER_NAME
, RA_CUSTOMERS.CUSTOMER_NUMBER
, RA_ADDRESSES.ADDRESS1
, RA_ADDRESSES.ADDRESS2
, RA_ADDRESSES.ADDRESS3
, RA_ADDRESSES.ADDRESS4
, RA_ADDRESSES.COUNTRY COUNTRY_CODE
, TERR1.TERRITORY_SHORT_NAME COUNTRY
, RA_ADDRESSES.CITY
, RA_ADDRESSES.POSTAL_CODE
, RA_ADDRESSES.STATE
, RA_ADDRESSES.PROVINCE
, RA_ADDRESSES.COUNTY
, FND_CURRENCIES_TL.NAME CURRENCY_NAME
, RA_CONTACTS.FIRST_NAME CONTACT_FIRST_NAME
, RA_CONTACTS.LAST_NAME CONTACT_LAST_NAME
, RA_ADDRESSES_SHIP.ADDRESS1 SHIP_TO_ADDRESS1
, RA_ADDRESSES_SHIP.ADDRESS2 SHIP_TO_ADDRESS2
, RA_ADDRESSES_SHIP.ADDRESS3 SHIP_TO_ADDRESS3
, RA_ADDRESSES_SHIP.ADDRESS4 SHIP_TO_ADDRESS4
, RA_ADDRESSES_SHIP.COUNTRY SHIP_TO_COUNTRY_CODE
, TERR2.TERRITORY_SHORT_NAME SHIP_TO_COUNTRY
, RA_ADDRESSES_SHIP.CITY SHIP_TO_CITY
, RA_ADDRESSES_SHIP.POSTAL_CODE SHIP_TO_POSTAL_CODE
, RA_ADDRESSES_SHIP.STATE SHIP_TO_STATE
, RA_ADDRESSES_SHIP.PROVINCE SHIP_TO_PROVINCE
, RA_ADDRESSES_SHIP.COUNTY SHIP_TO_COUNTY
, RA_CONTACTS_SHIP.FIRST_NAME SHIP_TO_CONTACT_FIRST
, RA_CONTACTS_SHIP.LAST_NAME SHIP_TO_CONTACT_LAST
, AS_LEADS.LEAD_NUMBER
, AS_LEADS.DESCRIPTION LEAD_DESCRIPTION
, AS_PROMOTIONS.NAME PROMOTION_NAME
, AS_PROMOTIONS.CODE PROMOTION_CODE
, SO_DISCOUNTS.NAME DISCOUNT_NAME
, SO_AGREEMENTS.NAME AGREEMENT_NAME
, RA_ADDRESSES_INVOICE.ADDRESS1 INVOICE_TO_ADDRESS1
, RA_ADDRESSES_INVOICE.ADDRESS2 INVOICE_TO_ADDRESS2
, RA_ADDRESSES_INVOICE.ADDRESS3 INVOICE_TO_ADDRESS3
, RA_ADDRESSES_INVOICE.ADDRESS4 INVOICE_TO_ADDRESS4
, RA_ADDRESSES_INVOICE.COUNTRY INVOICE_TO_COUNTRY_CODE
, TERR3.TERRITORY_SHORT_NAME INVOICE_TO_COUNTRY
, RA_ADDRESSES_INVOICE.CITY INVOICE_TO_CITY
, RA_ADDRESSES_INVOICE.POSTAL_CODE INVOICE_TO_POSTAL_CODE
, RA_ADDRESSES_INVOICE.STATE INVOICE_TO_STATE
, RA_ADDRESSES_INVOICE.PROVINCE INVOICE_TO_PROVINCE
, RA_ADDRESSES_INVOICE.COUNTY INVOICE_TO_COUNTY
, RA_CONTACTS_INVOICE.FIRST_NAME INVOICE_TO_CONTACT_FIRST
, RA_CONTACTS_INVOICE.LAST_NAME INVOICE_TO_CONTACT_LAST
, PPF.FIRST_NAME SALESREP_FIRST_NAME
, PPF.LAST_NAME SALESREP_LAST_NAME
, AS_QUOTES.SALES_CHANNEL_CODE
, AS_QUOTES.TAX_EXEMPT_FLAG
, AS_QUOTES.SHIPPING_INSTRUCTIONS
, AS_QUOTES.PACKING_INSTRUCTIONS
, RA_ADDRESSES_SHIP.ADDRESS_ID
, RA_ADDRESSES_INVOICE.ADDRESS_ID
FROM SO_PRICE_LISTS
, RA_ADDRESSES
, RA_CUSTOMERS
, RA_CONTACTS
, FND_CURRENCIES_TL
, AS_LEADS
, SO_DISCOUNTS
, AS_PROMOTIONS
, PER_ALL_PEOPLE_F PPF
, SO_ORDER_TYPES
, SO_AGREEMENTS
, RA_RULES
, RA_RULES RA_RULES_A1
, RA_CONTACTS RA_CONTACTS_INVOICE
, RA_SITE_USES RA_SITE_USES_INVOICE
, RA_ADDRESSES RA_ADDRESSES_INVOICE
, FND_TERRITORIES_TL TERR3
, RA_CONTACTS RA_CONTACTS_SHIP
, RA_SITE_USES RA_SITE_USES_SHIP
, RA_ADDRESSES RA_ADDRESSES_SHIP
, FND_TERRITORIES_TL TERR2
, AS_QUOTES
, AS_LOOKUPS
, AS_PROMOTIONS AS_PROMOTIONS_A1
, FND_TERRITORIES_TL TERR1
WHERE AS_PROMOTIONS_A1.CODE (+) = 'L'
AND AS_LOOKUPS.LOOKUP_TYPE (+) = 'QUOTE_STATUS'
AND AS_QUOTES.QUOTE_STATUS = AS_LOOKUPS.LOOKUP_CODE (+)
AND AS_QUOTES.PRICE_LIST_ID = SO_PRICE_LISTS.PRICE_LIST_ID (+)
AND AS_QUOTES.CUSTOMER_ID = RA_CUSTOMERS.CUSTOMER_ID (+)
AND AS_QUOTES.ADDRESS_ID = RA_ADDRESSES.ADDRESS_ID (+)
AND AS_QUOTES.CONTACT_ID = RA_CONTACTS.CONTACT_ID (+)
AND AS_QUOTES.CURRENCY_CODE = FND_CURRENCIES_TL.CURRENCY_CODE (+)
AND FND_CURRENCIES_TL.LANGUAGE(+) = USERENV('LANG')
AND AS_QUOTES.LEAD_ID = AS_LEADS.LEAD_ID (+)
AND AS_QUOTES.PROMOTION_ID = AS_PROMOTIONS.PROMOTION_ID (+)
AND AS_QUOTES.DISCOUNT_ID = SO_DISCOUNTS.DISCOUNT_ID (+)
AND AS_QUOTES.SHIP_TO_SITE_USE_ID = RA_SITE_USES_SHIP.SITE_USE_ID(+)
AND RA_SITE_USES_SHIP.ADDRESS_ID = RA_ADDRESSES_SHIP.ADDRESS_ID (+)
AND AS_QUOTES.INVOICE_TO_SITE_USE_ID = RA_SITE_USES_INVOICE.SITE_USE_ID (+)
AND RA_SITE_USES_INVOICE.ADDRESS_ID = RA_ADDRESSES_INVOICE.ADDRESS_ID (+)
AND AS_QUOTES.INVOICE_TO_CONTACT_ID = RA_CONTACTS_INVOICE.CONTACT_ID (+)
AND AS_QUOTES.SHIP_TO_CONTACT_ID = RA_CONTACTS_SHIP.CONTACT_ID (+)
AND AS_QUOTES.AGREEMENT_ID = SO_AGREEMENTS.AGREEMENT_ID (+)
AND AS_QUOTES.ORDER_TYPE_ID = SO_ORDER_TYPES.ORDER_TYPE_ID (+)
AND AS_QUOTES.ACCOUNTING_RULE_ID = RA_RULES.RULE_ID (+)
AND AS_QUOTES.INVOICING_RULE_ID = RA_RULES_A1.RULE_ID (+)
AND AS_QUOTES.QUOTE_LETTER_ID = AS_PROMOTIONS_A1.PROMOTION_ID (+)
AND PPF.PERSON_ID (+) = AS_QUOTES.EMPLOYEE_PERSON_ID
AND SYSDATE BETWEEN PPF.EFFECTIVE_START_DATE
AND PPF.EFFECTIVE_END_DATE
AND RA_ADDRESSES.COUNTRY = TERR1.TERRITORY_CODE(+)
AND TERR1.LANGUAGE(+) = USERENV('LANG')
AND RA_ADDRESSES_SHIP.COUNTRY = TERR2.TERRITORY_CODE(+)
AND TERR2.LANGUAGE(+) = USERENV('LANG')
AND RA_ADDRESSES_INVOICE.COUNTRY = TERR3.TERRITORY_CODE(+)
AND TERR3.LANGUAGE(+) = USERENV('LANG')

Columns