Product: | AMS - Marketing |
---|---|
Description: | Order Headers |
Implementation/DBA Data: | Not implemented in this database |
SELECT OH.HEADER_ID
, OH.ORDER_TYPE_ID
, OT.NAME
, OH.ORDER_NUMBER
, OH.ORDER_SOURCE_ID
, OH.SOURCE_DOCUMENT_ID
, OH.SOURCE_DOCUMENT_TYPE_ID
, OH.ORIG_SYS_DOCUMENT_REF
, OH.ORDERED_DATE
, OH.REQUEST_DATE
, OH.PRICING_DATE
, OH.VERSION_NUMBER
, OH.EXPIRATION_DATE
, OH.SHIPMENT_PRIORITY_CODE
, OH.DEMAND_CLASS_CODE
, OH.PRICE_LIST_ID
, OH.TAX_EXEMPT_FLAG
, OH.TAX_EXEMPT_NUMBER
, OH.TAX_EXEMPT_REASON_CODE
, OH.CONVERSION_RATE
, OH.CONVERSION_TYPE_CODE
, OH.CONVERSION_RATE_DATE
, OH.PARTIAL_SHIPMENTS_ALLOWED
, OH.SHIP_TOLERANCE_ABOVE
, OH.SHIP_TOLERANCE_BELOW
, OH.TRANSACTIONAL_CURR_CODE
, OH.AGREEMENT_ID
, OH.TAX_POINT_CODE
, OH.CUST_PO_NUMBER
, OH.INVOICING_RULE_ID
, OH.ACCOUNTING_RULE_ID
, OH.PAYMENT_TERM_ID
, TERM.NAME
, OH.SHIPPING_METHOD_CODE
, OH.FREIGHT_CARRIER_CODE
, OH.FOB_POINT_CODE
, OH.FREIGHT_TERMS_CODE
, OH.SOLD_TO_ORG_ID
, ACCT.ACCOUNT_NAME
, CUST.PARTY_NAME
, OH.SOLD_FROM_ORG_ID
, OH.SHIP_FROM_ORG_ID
, OH.SHIP_TO_ORG_ID
, OH.INVOICE_TO_ORG_ID
, OH.DELIVER_TO_ORG_ID
, OH.SOLD_TO_CONTACT_ID
, OH.SHIP_TO_CONTACT_ID
, OH.INVOICE_TO_CONTACT_ID
, OH.DELIVER_TO_CONTACT_ID
, OH.CANCELLED_FLAG
, OH.OPEN_FLAG
, OH.BOOKED_FLAG
, OH.SALESREP_ID
, OH.RETURN_REASON_CODE
, OH.ORDER_DATE_TYPE_CODE
, OH.EARLIEST_SCHEDULE_LIMIT
, OH.LATEST_SCHEDULE_LIMIT
, OH.PAYMENT_TYPE_CODE
, OH.PAYMENT_AMOUNT
, OH.CHECK_NUMBER
, OH.CREDIT_CARD_CODE
, OH.CREDIT_CARD_NUMBER
, OH.CREDIT_CARD_EXPIRATION_DATE
, OH.SALES_CHANNEL_CODE
, OH.FIRST_ACK_CODE
, OH.FIRST_ACK_DATE
, OH.LAST_ACK_CODE
, OH.LAST_ACK_DATE
, OH.MARKETING_SOURCE_CODE_ID
, OH.ORDER_CATEGORY_CODE
, OH.SHIPPING_INSTRUCTIONS
, OH.PACKING_INSTRUCTIONS
, OH.ORG_ID
FROM OE_ORDER_HEADERS OH
, OE_TRANSACTION_TYPES_VL OT
, RA_TERMS_VL TERM
, HZ_CUST_ACCOUNTS ACCT
, HZ_PARTIES CUST
WHERE OH.ORDER_TYPE_ID = OT.TRANSACTION_TYPE_ID
AND OT.TRANSACTION_TYPE_CODE = 'ORDER'
AND OH.PAYMENT_TERM_ID = TERM.TERM_ID(+)
AND OH.SOLD_TO_ORG_ID = ACCT.CUST_ACCOUNT_ID
AND ACCT.PARTY_ID = CUST.PARTY_ID