[Home] [Help]
| Product: | OE - Order Entry |
|---|---|
| Description: | |
| Implementation/DBA Data: | Not implemented in this database |
SELECT DISTINCT TRX.TRX_NUMBER INVOICE_NUMBER
, TRX.TRX_DATE INVOICE_DATE
, HD.ORDER_NUMBER
, HD.HEADER_ID
, HD.ORDER_CATEGORY
, SL.MEANING ORDER_CATEGORY_DESC
, OT.NAME ORDER_TYPE
, HD.ORDER_TYPE_ID
, HD.PURCHASE_ORDER_NUM
, HD.ORIGINAL_SYSTEM_SOURCE_CODE
, HD.ORIGINAL_SYSTEM_REFERENCE
, RC.CUSTOMER_NAME
, HD.CUSTOMER_ID
, RC.CUSTOMER_NUMBER
, HD.DATE_ORDERED
, HD.SHIP_METHOD_CODE
, TRX.BILL_TO_CUSTOMER_ID
FROM RA_CUSTOMERS RC
, SO_ORDER_TYPES OT
, SO_HEADERS HD
, SO_LOOKUPS SL
, RA_CUSTOMER_TRX TRX
, SO_LINES L
, RA_CUSTOMER_TRX_LINES TRXL
WHERE HD.HEADER_ID = L.HEADER_ID
AND HD.ORDER_TYPE_ID = OT.ORDER_TYPE_ID
AND (L.CREDIT_INVOICE_LINE_ID = TRXL.CUSTOMER_TRX_LINE_ID OR L.LINE_ID = DECODE(RTRIM(TRXL.INTERFACE_LINE_ATTRIBUTE6
, '0123456789')
, NULL
, TO_NUMBER(TRXL.INTERFACE_LINE_ATTRIBUTE6)
, NULL))
AND TRX.CUSTOMER_TRX_ID = TRXL.CUSTOMER_TRX_ID
AND HD.CUSTOMER_ID = RC.CUSTOMER_ID
AND SL.LOOKUP_CODE = HD.ORDER_CATEGORY
AND SL.LOOKUP_TYPE = 'ORDER_CATEGORY'