[Home] [Help]
View: IGI_INSTALMENT_AUDIT_V
Product: | IGI - Public Sector Financials International |
Description: | Stores information required for Instalment Terms requirement |
Implementation/DBA Data: |
APPS.IGI_INSTALMENT_AUDIT_V
|
View Text
SELECT JIA.INSTALMENT_AUDIT_ID
, JIA.RA_CUSTOMER_TRX_ID
, JIA.RA_TERM_ID
, RA.NAME
, JIA.FND_USER_ID
, FU.USER_NAME
, JIA.START_DATE
, JIA.CREATION_DATE
, JIA.CREATED_BY
, JIA.LAST_UPDATE_DATE
, JIA.LAST_UPDATED_BY
, JIA.LAST_UPDATE_LOGIN
, JIA.ROWID
FROM FND_USER FU
, IGI_INSTALMENT_AUDIT JIA
, RA_TERMS_VL RA
WHERE JIA.FND_USER_ID = FU.USER_ID
AND JIA.RA_TERM_ID = RA.TERM_ID
Columns
Name |
INSTALMENT_AUDIT_ID |
RA_CUSTOMER_TRX_ID |
RA_TERM_ID |
TERMS_NAME |
FND_USER_ID |
USER_NAME |
START_DATE |
CREATION_DATE |
CREATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_LOGIN |
ROW_ID |