Product: | OE - Order Entry |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | Not implemented in this database |
SELECT HEADER.ORDER_NUMBER
, ORDER_TYPE.NAME
, '_LA:HEADER.SHIP_PARTIAL_FLAG:SO_LOOKUPS:YES_NO:MEANING'
, HEADER.SHIPPING_INSTRUCTIONS
, HEADER.PACKING_INSTRUCTIONS
, '_LA:HEADER.SALES_CHANNEL_CODE:SO_LOOKUPS:SALES_CHANNEL:MEANING'
, HEADER.CONVERSION_TYPE_CODE
, HEADER.CONVERSION_RATE
, HEADER.CONVERSION_DATE
, '_LA:HEADER.TAX_EXEMPT_FLAG:SO_LOOKUPS:YES_NO:MEANING'
, HEADER.TAX_EXEMPT_NUM
, '_LA:HEADER.TAX_EXEMPT_REASON_CODE:AR_LOOKUPS:TAX_REASON:MEANING'
, '_LA:HEADER.ORDER_CATEGORY:SO_LOOKUPS:ORDER_CATEGORY:MEANING'
, HEADER.ORIGINAL_SYSTEM_REFERENCE
, HEADER.DATE_ORDERED
, HEADER.DATE_REQUESTED_CURRENT
, '_LA:HEADER.OPEN_FLAG:SO_LOOKUPS:YES_NO:MEANING'
, '_LA:HEADER.CANCELLED_FLAG:SO_LOOKUPS:YES_NO:MEANING'
, '_LA:HEADER.DEMAND_CLASS_CODE:FND_COMMON_LOOKUPS:DEMAND_CLASS:MEANING'
, HEADER.PURCHASE_ORDER_NUM
, '_LA:HEADER.SHIPMENT_PRIORITY_CODE:SO_LOOKUPS:SHIPMENT_PRIORITY:MEANING'
, HEADER.SHIP_METHOD_CODE /* FK=CARRIER */
, '_LA:HEADER.FREIGHT_TERMS_CODE:SO_LOOKUPS:FREIGHT_TERMS:MEANING'
, '_LA:HEADER.FOB_CODE:AR_LOOKUPS:FOB:MEANING'
, '_DF:OE:SO_HEADERS:HEADER'
, HEADER.HEADER_ID
, HEADER.ORDER_TYPE_ID
, HEADER.CYCLE_ID
, HEADER.SALESREP_ID
, HEADER.CUSTOMER_ID
, HEADER.AGREEMENT_ID
, HEADER.ORDERED_BY_CONTACT_ID
, HEADER.INVOICE_TO_CONTACT_ID
, HEADER.INVOICE_TO_SITE_USE_ID
, HEADER.SHIP_TO_CONTACT_ID
, HEADER.SHIP_TO_SITE_USE_ID
, HEADER.WAREHOUSE_ID
, HEADER.INVOICING_RULE_ID
, HEADER.ACCOUNTING_RULE_ID
, HEADER.TERMS_ID
, HEADER.PRICE_LIST_ID
, HEADER.CURRENCY_CODE
, HEADER.SOURCE_HEADER_ID
, HEADER.ORG_ID
, HEADER.LAST_UPDATE_DATE
, HEADER.LAST_UPDATED_BY
, HEADER.CREATION_DATE
, HEADER.CREATED_BY
FROM SO_HEADERS_ALL HEADER
, SO_ORDER_TYPES_ALL ORDER_TYPE
WHERE HEADER.ORDER_TYPE_ID = ORDER_TYPE.ORDER_TYPE_ID WITH READ ONLY