VIEW: APPS.IGS_EN_CAT_PRC_DTL_V

Source

View Text - Preformatted

SELECT ecp.ROWID ROW_ID, ecp.ENROLMENT_CAT, ec.DESCRIPTION, ecp.ENR_METHOD_TYPE, emt.DESCRIPTION, ecp.S_STUDENT_COMM_TYPE, lkup.MEANING , TO_CHAR(NULL), /**ecp.PRODUCE_PACKAGE_IND,**/ ecp.PERSON_ADD_ALLOW_IND, ecp.COURSE_ADD_ALLOW_IND, ecp.CREATED_BY, ecp.CREATION_DATE, ecp.LAST_UPDATED_BY, ecp.LAST_UPDATE_DATE, ecp.LAST_UPDATE_LOGIN, ecp.CONFIG_MIN_CP_VALDN, ecp.ENFORCE_DATE_ALIAS , CA.DESCRIPTION FROM IGS_EN_CAT_PRC_DTL ecp, IGS_EN_ENROLMENT_CAT ec, IGS_EN_METHOD_TYPE emt, IGS_LOOKUPS_VIEW lkup, IGS_CA_DA CA WHERE ecp.ENROLMENT_CAT = ec.ENROLMENT_CAT AND ecp.ENR_METHOD_TYPE = emt.ENR_METHOD_TYPE AND ecp.S_STUDENT_COMM_TYPE = lkup.lookup_code AND lkup.lookup_type = 'VS_EN_COMMENCE' AND ecp.ENFORCE_DATE_ALIAS = CA.DT_ALIAS(+)

View Text - HTML Formatted

SELECT ECP.ROWID ROW_ID
, ECP.ENROLMENT_CAT
, EC.DESCRIPTION
, ECP.ENR_METHOD_TYPE
, EMT.DESCRIPTION
, ECP.S_STUDENT_COMM_TYPE
, LKUP.MEANING
, TO_CHAR(NULL)
, /**ECP.PRODUCE_PACKAGE_IND
, **/ ECP.PERSON_ADD_ALLOW_IND
, ECP.COURSE_ADD_ALLOW_IND
, ECP.CREATED_BY
, ECP.CREATION_DATE
, ECP.LAST_UPDATED_BY
, ECP.LAST_UPDATE_DATE
, ECP.LAST_UPDATE_LOGIN
, ECP.CONFIG_MIN_CP_VALDN
, ECP.ENFORCE_DATE_ALIAS
, CA.DESCRIPTION
FROM IGS_EN_CAT_PRC_DTL ECP
, IGS_EN_ENROLMENT_CAT EC
, IGS_EN_METHOD_TYPE EMT
, IGS_LOOKUPS_VIEW LKUP
, IGS_CA_DA CA
WHERE ECP.ENROLMENT_CAT = EC.ENROLMENT_CAT
AND ECP.ENR_METHOD_TYPE = EMT.ENR_METHOD_TYPE
AND ECP.S_STUDENT_COMM_TYPE = LKUP.LOOKUP_CODE
AND LKUP.LOOKUP_TYPE = 'VS_EN_COMMENCE'
AND ECP.ENFORCE_DATE_ALIAS = CA.DT_ALIAS(+)