[Home] [Help]
View: IGI_RPI_INVOICE_HISTORY_V
Product: | IGI - Public Sector Financials International |
Description: | Contains invoice history informaion for a single standing charge |
Implementation/DBA Data: |
APPS.IGI_RPI_INVOICE_HISTORY_V
|
View Text
SELECT SC.STANDING_CHARGE_ID STANDING_CHARGE_ID
, TX.TRX_NUMBER INVOICE_NUMBER
, TX.TRX_DATE INVOICE_DATE
, TX.COMMENTS COMMENTS
, TX.CREATION_DATE CREATION_DATE
, TX.CREATED_BY CREATED_BY
, TX.LAST_UPDATE_DATE LAST_UPDATE_DATE
, TX.LAST_UPDATED_BY LAST_UPDATED_BY
, TX.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, SUM(TL.EXTENDED_AMOUNT) AMOUNT
, TX.INVOICE_CURRENCY_CODE INVOICE_CURRENCY_CODE
FROM IGI_RPI_STANDING_CHARGES SC
, RA_CUSTOMER_TRX TX
, RA_CUSTOMER_TRX_LINES TL
WHERE TO_CHAR(SC.STANDING_CHARGE_ID) = TX.INTERFACE_HEADER_ATTRIBUTE1 AND TL.CUSTOMER_TRX_ID = TX.CUSTOMER_TRX_ID AND TX.INTERFACE_HEADER_CONTEXT = ( SELECT RPI_HEADER_CONTEXT_CODE
FROM IGI_AR_SYSTEM_OPTIONS ) GROUP BY SC.STANDING_CHARGE_ID
, TX.TRX_NUMBER
, TX.TRX_DATE
, TX.INVOICE_CURRENCY_CODE
, TX.COMMENTS
, TX.CREATION_DATE
, TX.CREATED_BY
, TX.LAST_UPDATE_DATE
, TX.LAST_UPDATED_BY
, TX.LAST_UPDATE_LOGIN
Columns
Name |
STANDING_CHARGE_ID |
INVOICE_NUMBER |
INVOICE_DATE |
COMMENTS |
CREATION_DATE |
CREATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_LOGIN |
AMOUNT |
INVOICE_CURRENCY_CODE |