View: OE_RA_CUST_TRX_HDR_V

Product:	ONT - Order Management
Description:	This will be used by the Invoices / Credit Memos tab in Addition Order Information screen.
Implementation/DBA Data:	APPS.OE_RA_CUST_TRX_HDR_V

View Text

SELECT RCT.CUSTOMER_TRX_ID CUSTOMER_TRX_ID
, RCT.TRX_NUMBER TRX_NUMBER
, RBS.NAME BATCH_SOURCE
, RCTT.NAME TYPE
, RCT.TRX_DATE TRX_DATE
, OE_INVOICE_PUB.INVOICE_BALANCE(RCT.CUSTOMER_TRX_ID) BALANCE
, SUM(RCTL.EXTENDED_AMOUNT) INVOICE_AMOUNT
, RCT.CREATION_DATE
, RCT.CREATED_BY
, RCT.LAST_UPDATE_DATE
, RCT.LAST_UPDATED_BY
, RCT.LAST_UPDATE_LOGIN
, RCT.ROWID ROW_ID
, RCTL.INTERFACE_LINE_ATTRIBUTE1 ORDER_NUMBER
, RCTL.INTERFACE_LINE_ATTRIBUTE2 ORDER_TYPE
, RCTL.ORG_ID
FROM RA_CUSTOMER_TRX_ALL RCT
, RA_BATCH_SOURCES_ALL RBS
, RA_CUST_TRX_TYPES_ALL RCTT
, RA_CUSTOMER_TRX_LINES RCTL
WHERE RBS.BATCH_SOURCE_ID(+) = RCT.BATCH_SOURCE_ID
AND RCTT.CUST_TRX_TYPE_ID = RCT.CUST_TRX_TYPE_ID
AND RCTL.CUSTOMER_TRX_ID = RCT.CUSTOMER_TRX_ID
AND RCTL.INTERFACE_LINE_CONTEXT = 'ORDER ENTRY'
AND RCTL.LINE_TYPE <> 'TAX'
AND RCTT.ORG_ID = RCT.ORG_ID
AND RCTL.ORG_ID = RCT.ORG_ID
AND RBS.ORG_ID(+) = RCT.ORG_ID GROUP BY RCT.CUSTOMER_TRX_ID
, RCT.TRX_NUMBER
, RBS.NAME
, RCTT.NAME
, RCT.TRX_DATE
, RCT.CREATION_DATE
, RCT.CREATED_BY
, RCT.LAST_UPDATE_DATE
, RCT.LAST_UPDATED_BY
, RCT.LAST_UPDATE_LOGIN
, RCT.ROWID
, RCTL.INTERFACE_LINE_ATTRIBUTE1
, RCTL.INTERFACE_LINE_ATTRIBUTE2
, RCTL.ORG_ID

Columns