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_SL_CL_SETUP_ORG_V

Source

View Text - Preformatted


SELECT DISTINCT AWDYR.CI_CAL_TYPE, AWDYR.CI_SEQUENCE_NUMBER, CA.ALTERNATE_CODE, CA.START_DT, CA.END_DT, CLSET.PARTY_ID, ORGV.PARTY_NUMBER, ORGV.PARTY_NAME FROM IGF_AP_BATCH_AW_MAP AWDYR, IGF_SL_CL_SETUP CLSET, IGS_OR_INST_ORG_BASE_V ORGV, IGS_CA_INST CA WHERE AWDYR.CI_CAL_TYPE = CA.CAL_TYPE AND AWDYR.CI_SEQUENCE_NUMBER = CA.SEQUENCE_NUMBER AND AWDYR.CI_CAL_TYPE = CLSET.CI_CAL_TYPE AND AWDYR.CI_SEQUENCE_NUMBER = CLSET.CI_SEQUENCE_NUMBER AND ORGV.PARTY_ID = CLSET.PARTY_ID

View Text - HTML Formatted

SELECT DISTINCT AWDYR.CI_CAL_TYPE
, AWDYR.CI_SEQUENCE_NUMBER
, CA.ALTERNATE_CODE
, CA.START_DT
, CA.END_DT
, CLSET.PARTY_ID
, ORGV.PARTY_NUMBER
, ORGV.PARTY_NAME
FROM IGF_AP_BATCH_AW_MAP AWDYR
, IGF_SL_CL_SETUP CLSET
, IGS_OR_INST_ORG_BASE_V ORGV
, IGS_CA_INST CA
WHERE AWDYR.CI_CAL_TYPE = CA.CAL_TYPE
AND AWDYR.CI_SEQUENCE_NUMBER = CA.SEQUENCE_NUMBER
AND AWDYR.CI_CAL_TYPE = CLSET.CI_CAL_TYPE
AND AWDYR.CI_SEQUENCE_NUMBER = CLSET.CI_SEQUENCE_NUMBER
AND ORGV.PARTY_ID = CLSET.PARTY_ID