VIEW: APPS.IGS_EN_ELGB_OVR_V

Source

View Text - Preformatted

SELECT EOA.ROWID ROW_ID, EOA.ELGB_OVERRIDE_ID, EOA.PERSON_ID, P.PARTY_NUMBER, PP.PERSON_NAME, L1.MEANING, PP.DATE_OF_BIRTH, EOA.CAL_TYPE, EOA.CI_SEQUENCE_NUMBER, CI.START_DT, CI.END_DT, CI. ALTERNATE_CODE, SUBSTR(IGS_EN_GEN_014.ENRS_GET_ACAD_ALT_CD (CI.CAL_TYPE,CI.SEQUENCE_NUMBER),1,10), EOA.ORG_ID, EOA.CREATED_BY, EOA.CREATION_DATE, EOA.LAST_UPDATED_BY, EOA.LAST_UPDATE_DATE, EOA.LAST_UPDATE_LOGIN, CI.DESCRIPTION CI_DESCRIPTION FROM IGS_EN_ELGB_OVR EOA, HZ_PARTIES P, HZ_PERSON_PROFILES PP, FND_LOOKUP_VALUES L1, IGS_CA_INST CI WHERE EOA.PERSON_ID = P.PARTY_ID AND P.PARTY_ID = PP.PARTY_ID (+) AND PP.CONTENT_SOURCE_TYPE (+) = 'USER_ENTERED' AND SYSDATE BETWEEN PP.EFFECTIVE_START_DATE AND NVL(PP.EFFECTIVE_END_DATE,SYSDATE) AND PP.GENDER = L1.LOOKUP_CODE (+) AND L1.LOOKUP_TYPE (+) = 'HZ_GENDER' AND L1.LANGUAGE(+) = USERENV('LANG') AND L1.VIEW_APPLICATION_ID(+) = 222 AND L1.SECURITY_GROUP_ID(+) = 0 AND L1.ENABLED_FLAG = 'Y' AND (EOA.CAL_TYPE = CI.CAL_TYPE AND EOA.CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER)

View Text - HTML Formatted

SELECT EOA.ROWID ROW_ID
, EOA.ELGB_OVERRIDE_ID
, EOA.PERSON_ID
, P.PARTY_NUMBER
, PP.PERSON_NAME
, L1.MEANING
, PP.DATE_OF_BIRTH
, EOA.CAL_TYPE
, EOA.CI_SEQUENCE_NUMBER
, CI.START_DT
, CI.END_DT
, CI. ALTERNATE_CODE
, SUBSTR(IGS_EN_GEN_014.ENRS_GET_ACAD_ALT_CD (CI.CAL_TYPE
, CI.SEQUENCE_NUMBER)
, 1
, 10)
, EOA.ORG_ID
, EOA.CREATED_BY
, EOA.CREATION_DATE
, EOA.LAST_UPDATED_BY
, EOA.LAST_UPDATE_DATE
, EOA.LAST_UPDATE_LOGIN
, CI.DESCRIPTION CI_DESCRIPTION
FROM IGS_EN_ELGB_OVR EOA
, HZ_PARTIES P
, HZ_PERSON_PROFILES PP
, FND_LOOKUP_VALUES L1
, IGS_CA_INST CI
WHERE EOA.PERSON_ID = P.PARTY_ID
AND P.PARTY_ID = PP.PARTY_ID (+)
AND PP.CONTENT_SOURCE_TYPE (+) = 'USER_ENTERED'
AND SYSDATE BETWEEN PP.EFFECTIVE_START_DATE
AND NVL(PP.EFFECTIVE_END_DATE
, SYSDATE)
AND PP.GENDER = L1.LOOKUP_CODE (+)
AND L1.LOOKUP_TYPE (+) = 'HZ_GENDER'
AND L1.LANGUAGE(+) = USERENV('LANG')
AND L1.VIEW_APPLICATION_ID(+) = 222
AND L1.SECURITY_GROUP_ID(+) = 0
AND L1.ENABLED_FLAG = 'Y'
AND (EOA.CAL_TYPE = CI.CAL_TYPE
AND EOA.CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER)