Product: | AS - Sales Foundation |
---|---|
Description: | Order history header details view |
Implementation/DBA Data: | Not implemented in this database |
SELECT HEAD.ROWID ROW_ID
, HEAD.HEADER_ID
, HEAD.LAST_UPDATE_DATE
, HEAD.LAST_UPDATED_BY
, HEAD.CREATION_DATE
, HEAD.CREATED_BY
, HEAD.LAST_UPDATE_LOGIN
, HEAD.CUSTOMER_ID
, CUST.CUSTOMER_NAME
, CUST.CUSTOMER_NUMBER
, HEAD.ORDER_NUMBER
, OT.ORDER_TYPE_ID
, OT.NAME ORDER_TYPE
, HEAD.CURRENCY_CODE
, HEAD.S1_DATE BOOKED_DATE
, HEAD.PURCHASE_ORDER_NUM PO_NUMBER
, SOL.MEANING SALES_CHANNEL
, HEAD.AGREEMENT_ID
, A.NAME AGREEMENT
, SALE.NAME SALESREP
, CONT.CONTACT_ID
, CONT.FIRST_NAME CONTACT_FIRST_NAME
, CONT.LAST_NAME CONTACT_LAST_NAME
, RS.NAME COMMENTS
, HEAD.ATTRIBUTE1
, HEAD.ATTRIBUTE2
, HEAD.ATTRIBUTE3
, HEAD.ATTRIBUTE4
, HEAD.ATTRIBUTE5
, HEAD.ATTRIBUTE6
, HEAD.ATTRIBUTE7
, HEAD.ATTRIBUTE8
, HEAD.ATTRIBUTE9
, HEAD.ATTRIBUTE10
, HEAD.ATTRIBUTE11
, HEAD.ATTRIBUTE12
, HEAD.ATTRIBUTE13
, HEAD.ATTRIBUTE14
, HEAD.ATTRIBUTE15
, HEAD.CONTEXT
, HEAD.REQUEST_ID
, HEAD.PROGRAM_APPLICATION_ID
, HEAD.PROGRAM_ID
, HEAD.PROGRAM_UPDATE_DATE
, HEAD.ORDER_CATEGORY
, HEAD.ORIGINAL_SYSTEM_SOURCE_CODE
, HEAD.ORIGINAL_SYSTEM_REFERENCE
, HEAD.SOURCE_HEADER_ID
, HEAD.CYCLE_ID
, HEAD.DATE_ORDERED
, HEAD.OPEN_FLAG
, HEAD.CANCELLED_FLAG
, HEAD.ORDERED_BY_CONTACT_ID
, HEAD.SHIP_TO_SITE_USE_ID
, HEAD.SHIP_TO_CONTACT_ID
, HEAD.INVOICE_TO_SITE_USE_ID
, HEAD.INVOICE_TO_CONTACT_ID
, HEAD.PURCHASE_ORDER_NUM
, HEAD.DATE_REQUESTED_CURRENT
, HEAD.SHIPMENT_PRIORITY_CODE
, HEAD.SHIP_METHOD_CODE
, HEAD.FREIGHT_TERMS_CODE
, HEAD.FOB_CODE
, HEAD.SHIP_PARTIAL_FLAG
, HEAD.WAREHOUSE_ID
, HEAD.DEMAND_CLASS_CODE
, HEAD.SHIPPING_INSTRUCTIONS
, HEAD.PACKING_INSTRUCTIONS
, HEAD.SALESREP_ID
, HEAD.SALES_CHANNEL_CODE
, HEAD.PRICE_LIST_ID
, HEAD.CONVERSION_TYPE_CODE
, HEAD.CONVERSION_RATE
, HEAD.CONVERSION_DATE
, HEAD.TERMS_ID
, HEAD.INVOICING_RULE_ID
, HEAD.ACCOUNTING_RULE_ID
, HEAD.TAX_EXEMPT_NUM
, HEAD.TAX_EXEMPT_REASON_CODE
, HEAD.PAYMENT_TYPE_CODE
, HEAD.PAYMENT_AMOUNT
, HEAD.CHECK_NUMBER
, HEAD.CREDIT_CARD_CODE
, HEAD.CREDIT_CARD_HOLDER_NAME
, HEAD.CREDIT_CARD_NUMBER
, HEAD.CREDIT_CARD_EXPIRATION_DATE
, HEAD.CREDIT_CARD_APPROVAL_CODE
, HEAD.DATE_SVRID
, HEAD.ENTRY_STATUS_SVRID
, HEAD.TYPE_SVRID
, HEAD.CUSTOMER_SVRID
, HEAD.CONTACT_SVRID
, HEAD.SHIP_TO_SVRID
, HEAD.SHIP_TO_CONTACT_SVRID
, HEAD.INVOICE_TO_SVRID
, HEAD.INVOICE_TO_CONTACT_SVRID
, HEAD.AGREEMENT_SVRID
, HEAD.PO_NUMBER_SVRID
, HEAD.REQUEST_DATE_SVRID
, HEAD.SALESPERSON_SVRID
, HEAD.SALES_CHANNEL_SVRID
, HEAD.PRICE_LIST_SVRID
, HEAD.CURRENCY_SVRID
, HEAD.CONVERSION_TYPE_SVRID
, HEAD.CONVERSION_DATE_SVRID
, HEAD.CONVERSION_RATE_SVRID
, HEAD.INVOICING_RULE_SVRID
, HEAD.ACCOUNTING_RULE_SVRID
, HEAD.PAYMENT_TERMS_SVRID
, HEAD.TAX_EXEMPT_NUMBER_SVRID
, HEAD.TAX_EXEMPT_REASON_SVRID
, HEAD.SHIPMENT_PRIORITY_SVRID
, HEAD.FREIGHT_CARRIER_SVRID
, HEAD.FREIGHT_TERMS_SVRID
, HEAD.FOB_SVRID
, HEAD.SHIP_PARTIAL_SVRID
, HEAD.WAREHOUSE_SVRID
, HEAD.DEMAND_CLASS_SVRID
, HEAD.PACKING_INSTRUCTIONS_SVRID
, HEAD.SHIPPING_INSTRUCTIONS_SVRID
, HEAD.PAYMENT_TYPE_SVRID
, HEAD.PAYMENT_AMOUNT_SVRID
, HEAD.CHECK_NUMBER_SVRID
, HEAD.CREDIT_CARD_SVRID
, HEAD.CREDIT_CARD_HOLDER_SVRID
, HEAD.CREDIT_CARD_NUMBER_SVRID
, HEAD.CREDIT_CARD_EXP_DATE_SVRID
, HEAD.CREDIT_CARD_APP_CODE_SVRID
, HEAD.DF_SVRID
, HEAD.S1
, HEAD.S1_DATE
, HEAD.S2
, HEAD.S2_DATE
, HEAD.S3
, HEAD.S3_DATE
, HEAD.S4
, HEAD.S4_DATE
, HEAD.S5
, HEAD.S5_DATE
, HEAD.S6
, HEAD.S6_DATE
, HEAD.S7
, HEAD.S7_DATE
, HEAD.S8
, HEAD.S8_DATE
, HEAD.S9
, HEAD.S9_DATE
, HEAD.S10
, HEAD.S10_DATE
, HEAD.S11
, HEAD.S11_DATE
, HEAD.S12
, HEAD.S12_DATE
, HEAD.S13
, HEAD.S13_DATE
, HEAD.S14
, HEAD.S14_DATE
, HEAD.S15
, HEAD.S15_DATE
, HEAD.S16
, HEAD.S16_DATE
, HEAD.S17
, HEAD.S17_DATE
, HEAD.S18
, HEAD.S18_DATE
, HEAD.S19
, HEAD.S19_DATE
, HEAD.S20
, HEAD.S20_DATE
, HEAD.S21
, HEAD.S21_DATE
, HEAD.S22
, HEAD.S22_DATE
, HEAD.S23
, HEAD.S23_DATE
, HEAD.S24
, HEAD.S24_DATE
, HEAD.S25
, HEAD.S25_DATE
, HEAD.S26
, HEAD.S26_DATE
, HEAD.S27
, HEAD.S27_DATE
, HEAD.S28
, HEAD.S28_DATE
, HEAD.S29
, HEAD.S29_DATE
, HEAD.S30
, HEAD.S30_DATE
, HEAD.TAX_EXEMPT_FLAG
, HEAD.ORG_ID
, HEAD.WH_UPDATE_DATE
, OT.NAME
FROM SO_AGREEMENTS_VL A
, SO_LOOKUPS SOL
, SO_RESULTS_VL RS
, RA_CUSTOMERS CUST
, RA_CONTACTS CONT
, RA_SALESREPS SALE
, SO_ORDER_TYPES OT
, SO_HEADERS HEAD
WHERE HEAD.ORDER_TYPE_ID = OT.ORDER_TYPE_ID
AND HEAD.CUSTOMER_ID = CUST.CUSTOMER_ID
AND HEAD.SALES_CHANNEL_CODE = SOL.LOOKUP_CODE(+)
AND SOL.LOOKUP_TYPE(+) = 'SALES_CHANNEL'
AND HEAD.AGREEMENT_ID = A.AGREEMENT_ID(+)
AND HEAD.SALESREP_ID = SALE.SALESREP_ID(+)
AND HEAD.ORDERED_BY_CONTACT_ID = CONT.CONTACT_ID(+)
AND NVL(HEAD.S1
, 5) = RS.RESULT_ID(+)