Product: | BIC - Customer Intelligence (obsolete) |
---|---|
Description: | Sales Quotes Detail view - returns sales quotes detail lines, address, contacts |
Implementation/DBA Data: | Not implemented in this database |
SELECT QU.CUSTOMER_ID
, QU.ORG_ID
, QU.QUOTE_NAME
, QU.QUOTE_NUMBER
, QU.QUOTE_STATUS
, QU.QUOTE_VERSION
, QU.DESCRIPTION
, QU.SALES_CHANNEL_CODE
, QU.PROMOTION_ID
, QU.TOTAL_QUOTE_PRICE
, QU.TOTAL_LIST_PRICE
, QU.TOTAL_DISCOUNT_AMOUNT
, QU.TOTAL_DISCOUNT_PERCENT
, QU.QUOTE_START_DATE
, QU.QUOTE_END_DATE
, QU.APPROVAL_FLAG
, QU.APPROVAL_DATE
, QU.EMPLOYEE_PERSON_ID
, QU.AGREEMENT_ID
, QU.PAYMENT_TERM_ID
, QU.PAYMENT_TYPE_CODE
, QU.PAYMENT_AMOUNT
, OT.NAME ORDER_TYPE
, QU.ORDER_DATE
, SAS.CONTACT_ADDRESS SHIPTO_ADDRESS
, CONS.CONTACT_NAME SHIPTO_CONTACT_NAME
, CONS.CONTACT_PHONE SHIPTO_CONTACT_PHONE
, SAI.CONTACT_ADDRESS INVOICETO_ADDRESS
, CONI.CONTACT_NAME INVOICETO_CONTACT_NAME
, CONI.CONTACT_PHONE INVOICETO_CONTACT_PHONE
, QU.SHIPMENT_PRIORITY_CODE
, QU.SHIP_METHOD_CODE
, QUL.LINE_NUMBER
, QUL.QUOTE_ID
, QUL.INVENTORY_ITEM_ID
, QUL.ORGANIZATION_ID
, QUL.LINE_QUOTE_PRICE
, QUL.CURRENCY_CODE
, QUL.UOM_CODE
, QUL.QUANTITY
, QUL.SHIPPED_QUANTITY
, QUL.LINE_LIST_PRICE
, QUL.LINE_DISCOUNT_AMOUNT
, QUL.LINE_DISCOUNT_PERCENT
, QUL.LINE_DISCOUNT_MTHD_CODE
, QUL.START_DATE_ACTIVE
, QUL.END_DATE_ACTIVE
FROM AS_QUOTES_ALL QU
, OE_ORDER_TYPES_V OT
, BIC_SITE_ADDRESS_V SAS
, BIC_CONTACTS_V CONS
, BIC_SITE_ADDRESS_V SAI
, BIC_CONTACTS_V CONI
, AS_QUOTE_LINES_ALL QUL
WHERE QUL.QUOTE_ID (+) = QU.QUOTE_ID
AND QUL.ORG_ID (+) = QU.ORG_ID
AND QU.ORDER_TYPE_ID = OT.ORDER_TYPE_ID (+)
AND QU.SHIP_TO_SITE_USE_ID = SAS.SITE_USE_ID (+)
AND QU.SHIP_TO_CONTACT_ID = CONS.PARTY_ID (+)
AND QU.INVOICE_TO_SITE_USE_ID = SAI.SITE_USE_ID (+)
AND QU.INVOICE_TO_CONTACT_ID = CONI.PARTY_ID (+) WITH READ ONLY