[Home] [Help]
View: IGF_SL_CL_SETUP_ORG_V
View Text
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
Columns
Name |
CAL_TYPE |
SEQUENCE_NUMBER |
ALTERNATE_CODE |
START_DATE |
END_DATE |
PARTY_ID |
ORG_UNIT_CD |
ORG_UNIT_CD_DESC |