[Home] [Help]
View: IGI_EXP_AR_TRX_AMOUNTS_V
Product: | IGI - Public Sector Financials International |
Description: | Returns the total transaction amount for Receivables transactions. Used by views IGI_EXP_AVAILABLE_TRANSACTIONS_V and IGI_EXP_DU_LINES_V. |
Implementation/DBA Data: |
APPS.IGI_EXP_AR_TRX_AMOUNTS_V
|
View Text
SELECT RCT.CUSTOMER_TRX_ID
, SUM(RCTL.EXTENDED_AMOUNT) TRX_AMOUNT
, RCT.CREATION_DATE
, RCT.CREATED_BY
, RCT.LAST_UPDATE_LOGIN
, RCT.LAST_UPDATE_DATE
, RCT.LAST_UPDATED_BY
, RCT.ORG_ID
FROM RA_CUSTOMER_TRX RCT
, RA_CUSTOMER_TRX_LINES RCTL
WHERE RCT.CUSTOMER_TRX_ID = RCTL.CUSTOMER_TRX_ID GROUP BY RCT.CUSTOMER_TRX_ID
, RCT.CREATION_DATE
, RCT.CREATED_BY
, RCT.LAST_UPDATE_LOGIN
, RCT.LAST_UPDATE_DATE
, RCT.LAST_UPDATED_BY
, RCT.ORG_ID
Columns
Name |
CUSTOMER_TRX_ID |
TRX_AMOUNT |
CREATION_DATE |
CREATED_BY |
LAST_UPDATE_LOGIN |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
ORG_ID |