[Home] [Help]
View: OE_RA_CUSTOMER_TRX_PERF_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.INTERFACE_LINE_ATTRIBUTE6 LINE_ID
FROM RA_CUSTOMER_TRX_ALL RCT
, RA_BATCH_SOURCES_ALL RBS
, RA_CUST_TRX_TYPES_ALL RCTT
, RA_CUSTOMER_TRX_LINES_ALL 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_ATTRIBUTE6 = OE_INVOICE_PUB.GET_LINE_ID()
AND RCTL.INTERFACE_LINE_CONTEXT IN (FND_PROFILE.VALUE('ONT_SOURCE_CODE')
, 'INTERCOMPANY')
AND RBS.ORG_ID(+) = RCT.ORG_ID
AND RCTT.ORG_ID = RCT.ORG_ID
AND RCTL.ORG_ID = RCT.ORG_ID
AND RCTL.LINE_TYPE <> 'TAX' 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.INTERFACE_LINE_ATTRIBUTE6
Columns
Name |
CUSTOMER_TRX_ID |
TRX_NUMBER |
BATCH_SOURCE |
TYPE |
TRX_DATE |
BALANCE |
INVOICE_AMOUNT |
CREATION_DATE |
CREATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_LOGIN |
ROW_ID |
ORDER_NUMBER |
ORDER_TYPE |
LINE_ID |