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