eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.IGF_AW_COA_HIST_V

Source

View Text - Preformatted


SELECT COA.ROWID, COA.COAH_ID, COA.BASE_ID, HZ.PARTY_NUMBER, HZ.PERSON_LAST_NAME||','||HZ.PERSON_FIRST_NAME PERSON_NAME, PIT.API_PERSON_ID SSN, COA.TRAN_DATE, COA.ITEM_CODE, FA.CI_CAL_TYPE, FA.CI_SEQUENCE_NUMBER, COA.LD_CAL_TYPE, COA.LD_SEQUENCE_NUMBER, CA.ALTERNATE_CODE, COA.OPERATION_TXT, LK.MEANING, COA.OLD_VALUE, COA.NEW_VALUE, COA.REQUEST_ID, COA.LAST_UPDATED_BY, FND.USER_NAME LAST_UPDATED_USER FROM IGF_AW_COA_HIST COA, IGS_CA_INST CA, IGF_AP_FA_BASE_REC FA, FND_USER FND, IGF_LOOKUPS_VIEW LK, HZ_PARTIES HZ, (SELECT API_PERSON_ID, PE_PERSON_ID FROM IGS_PE_PERSON_ID_TYP PIT_2, IGS_PE_ALT_PERS_ID API_2 WHERE API_2.PERSON_ID_TYPE = PIT_2.PERSON_ID_TYPE AND PIT_2.S_PERSON_ID_TYPE = 'SSN' AND SYSDATE BETWEEN API_2.START_DT AND NVL(API_2.END_DT, SYSDATE) ) PIT WHERE CA.CAL_TYPE = COA.LD_CAL_TYPE AND CA.SEQUENCE_NUMBER = COA.LD_SEQUENCE_NUMBER AND FA.BASE_ID = COA.BASE_ID AND FND.USER_ID = COA.LAST_UPDATED_BY AND LK.LOOKUP_TYPE = 'IGF_AW_DML_OPERATION' AND COA.OPERATION_TXT = LK.LOOKUP_CODE AND LK.ENABLED_FLAG = 'Y' AND HZ.PARTY_ID = FA.PERSON_ID AND PIT.PE_PERSON_ID = FA.PERSON_ID

View Text - HTML Formatted

SELECT COA.ROWID
, COA.COAH_ID
, COA.BASE_ID
, HZ.PARTY_NUMBER
, HZ.PERSON_LAST_NAME||'
, '||HZ.PERSON_FIRST_NAME PERSON_NAME
, PIT.API_PERSON_ID SSN
, COA.TRAN_DATE
, COA.ITEM_CODE
, FA.CI_CAL_TYPE
, FA.CI_SEQUENCE_NUMBER
, COA.LD_CAL_TYPE
, COA.LD_SEQUENCE_NUMBER
, CA.ALTERNATE_CODE
, COA.OPERATION_TXT
, LK.MEANING
, COA.OLD_VALUE
, COA.NEW_VALUE
, COA.REQUEST_ID
, COA.LAST_UPDATED_BY
, FND.USER_NAME LAST_UPDATED_USER
FROM IGF_AW_COA_HIST COA
, IGS_CA_INST CA
, IGF_AP_FA_BASE_REC FA
, FND_USER FND
, IGF_LOOKUPS_VIEW LK
, HZ_PARTIES HZ
, (SELECT API_PERSON_ID
, PE_PERSON_ID
FROM IGS_PE_PERSON_ID_TYP PIT_2
, IGS_PE_ALT_PERS_ID API_2
WHERE API_2.PERSON_ID_TYPE = PIT_2.PERSON_ID_TYPE
AND PIT_2.S_PERSON_ID_TYPE = 'SSN'
AND SYSDATE BETWEEN API_2.START_DT
AND NVL(API_2.END_DT
, SYSDATE) ) PIT
WHERE CA.CAL_TYPE = COA.LD_CAL_TYPE
AND CA.SEQUENCE_NUMBER = COA.LD_SEQUENCE_NUMBER
AND FA.BASE_ID = COA.BASE_ID
AND FND.USER_ID = COA.LAST_UPDATED_BY
AND LK.LOOKUP_TYPE = 'IGF_AW_DML_OPERATION'
AND COA.OPERATION_TXT = LK.LOOKUP_CODE
AND LK.ENABLED_FLAG = 'Y'
AND HZ.PARTY_ID = FA.PERSON_ID
AND PIT.PE_PERSON_ID = FA.PERSON_ID