VIEW: APPS.IGS_DA_RQST_V

Source

View Text - Preformatted

SELECT dr.ROWID, dr.batch_id, dr.request_type_id, dr.request_mode, (SELECT meaning FROM igs_lookups_view WHERE lookup_type = 'IGS_DA_SELECTION_MODE' AND lookup_code = dr.request_mode) request_mode_meaning, dr.program_comparison_type, (SELECT meaning FROM igs_lookups_view WHERE lookup_type = 'IGS_DA_PROG_COMP' AND lookup_code = dr.program_comparison_type) program_comp_type_meaning, dr.request_status, (SELECT meaning FROM igs_lookups_view WHERE lookup_type = 'IGS_DA_RQST_STATUS' AND lookup_code = dr.request_status) request_status_meaning, dr.person_id_group_id, pgrp.group_cd, pgrp.description group_cd_desc, dr.person_id, pbv.party_number, pbv.party_name, dr.requestor_id, pbv1.party_number, pbv1.party_name, dr.student_release_ind, dr.special_program, (SELECT meaning FROM igs_lookups_view WHERE lookup_type = 'IGS_DA_SPCL_PRGMS' AND lookup_code = dr.special_program) special_program_meaning, dr.special_program_catalog, (SELECT meaning FROM igs_lookups_view WHERE lookup_type = 'IGS_DA_SPCL_PRGM_CATS' AND lookup_code = dr.special_program_catalog) special_prog_catalog_meaning, reqt.request_name, dr.attribute_category, dr.attribute1, dr.attribute2, dr.attribute3, dr.attribute4, dr.attribute5, dr.attribute6, dr.attribute7, dr.attribute8, dr.attribute9, dr.attribute10, dr.attribute11, dr.attribute12, dr.attribute13, dr.attribute14, dr.attribute15, dr.attribute16, dr.attribute17, dr.attribute18, dr.attribute19, dr.attribute20, dr.creation_date, dr.created_by, dr.last_update_login, dr.last_updated_by, dr.last_update_date FROM igs_da_rqst dr, hz_parties pbv, hz_parties pbv1, igs_da_cnfg_req_typ reqt, igs_pe_persid_group_all pgrp WHERE dr.person_id = pbv.party_id(+) AND dr.requestor_id = pbv1.party_id AND dr.request_type_id = reqt.request_type_id AND pgrp.GROUP_ID(+) = dr.person_id_group_id UNION ALL SELECT dr.ROWID, dr.batch_id, dr.request_type_id, dr.request_mode, (SELECT meaning FROM igs_lookups_view WHERE lookup_type = 'IGS_DA_SELECTION_MODE' AND lookup_code = dr.request_mode) request_mode_meaning, dr.program_comparison_type, (SELECT meaning FROM igs_lookups_view WHERE lookup_type = 'IGS_DA_PROG_COMP' AND lookup_code = dr.program_comparison_type) program_comp_type_meaning, dr.request_status, (SELECT meaning FROM igs_lookups_view WHERE lookup_type = 'IGS_DA_RQST_STATUS' AND lookup_code = dr.request_status) request_status_meaning, dr.person_id_group_id, NULL, NULL, dr.person_id, pbv.party_number, pbv.party_name, dr.requestor_id, pbv1.party_number, pbv1.party_name, dr.student_release_ind, dr.special_program, (SELECT meaning FROM igs_lookups_view WHERE lookup_type = 'IGS_DA_SPCL_PRGMS' AND lookup_code = dr.special_program) special_program_meaning, dr.special_program_catalog, (SELECT meaning FROM igs_lookups_view WHERE lookup_type = 'IGS_DA_SPCL_PRGM_CATS' AND lookup_code = dr.special_program_catalog) special_prog_catalog_meaning, reqt.request_name, dr.attribute_category, dr.attribute1, dr.attribute2, dr.attribute3, dr.attribute4, dr.attribute5, dr.attribute6, dr.attribute7, dr.attribute8, dr.attribute9, dr.attribute10, dr.attribute11, dr.attribute12, dr.attribute13, dr.attribute14, dr.attribute15, dr.attribute16, dr.attribute17, dr.attribute18, dr.attribute19, dr.attribute20, dr.creation_date, dr.created_by, dr.last_update_login, dr.last_updated_by, dr.last_update_date FROM igs_da_rqst dr, igs_da_req_stdnts stdnts, hz_parties pbv, hz_parties pbv1, igs_da_cnfg_req_typ reqt WHERE dr.batch_id = stdnts.batch_id AND dr.requestor_id = pbv1.party_id AND dr.request_type_id = reqt.request_type_id AND dr.person_id IS NULL AND dr.person_id_group_id IS NULL

View Text - HTML Formatted

SELECT DR.ROWID
, DR.BATCH_ID
, DR.REQUEST_TYPE_ID
, DR.REQUEST_MODE
, (SELECT MEANING
FROM IGS_LOOKUPS_VIEW
WHERE LOOKUP_TYPE = 'IGS_DA_SELECTION_MODE'
AND LOOKUP_CODE = DR.REQUEST_MODE) REQUEST_MODE_MEANING
, DR.PROGRAM_COMPARISON_TYPE
, (SELECT MEANING
FROM IGS_LOOKUPS_VIEW
WHERE LOOKUP_TYPE = 'IGS_DA_PROG_COMP'
AND LOOKUP_CODE = DR.PROGRAM_COMPARISON_TYPE) PROGRAM_COMP_TYPE_MEANING
, DR.REQUEST_STATUS
, (SELECT MEANING
FROM IGS_LOOKUPS_VIEW
WHERE LOOKUP_TYPE = 'IGS_DA_RQST_STATUS'
AND LOOKUP_CODE = DR.REQUEST_STATUS) REQUEST_STATUS_MEANING
, DR.PERSON_ID_GROUP_ID
, PGRP.GROUP_CD
, PGRP.DESCRIPTION GROUP_CD_DESC
, DR.PERSON_ID
, PBV.PARTY_NUMBER
, PBV.PARTY_NAME
, DR.REQUESTOR_ID
, PBV1.PARTY_NUMBER
, PBV1.PARTY_NAME
, DR.STUDENT_RELEASE_IND
, DR.SPECIAL_PROGRAM
, (SELECT MEANING
FROM IGS_LOOKUPS_VIEW
WHERE LOOKUP_TYPE = 'IGS_DA_SPCL_PRGMS'
AND LOOKUP_CODE = DR.SPECIAL_PROGRAM) SPECIAL_PROGRAM_MEANING
, DR.SPECIAL_PROGRAM_CATALOG
, (SELECT MEANING
FROM IGS_LOOKUPS_VIEW
WHERE LOOKUP_TYPE = 'IGS_DA_SPCL_PRGM_CATS'
AND LOOKUP_CODE = DR.SPECIAL_PROGRAM_CATALOG) SPECIAL_PROG_CATALOG_MEANING
, REQT.REQUEST_NAME
, DR.ATTRIBUTE_CATEGORY
, DR.ATTRIBUTE1
, DR.ATTRIBUTE2
, DR.ATTRIBUTE3
, DR.ATTRIBUTE4
, DR.ATTRIBUTE5
, DR.ATTRIBUTE6
, DR.ATTRIBUTE7
, DR.ATTRIBUTE8
, DR.ATTRIBUTE9
, DR.ATTRIBUTE10
, DR.ATTRIBUTE11
, DR.ATTRIBUTE12
, DR.ATTRIBUTE13
, DR.ATTRIBUTE14
, DR.ATTRIBUTE15
, DR.ATTRIBUTE16
, DR.ATTRIBUTE17
, DR.ATTRIBUTE18
, DR.ATTRIBUTE19
, DR.ATTRIBUTE20
, DR.CREATION_DATE
, DR.CREATED_BY
, DR.LAST_UPDATE_LOGIN
, DR.LAST_UPDATED_BY
, DR.LAST_UPDATE_DATE
FROM IGS_DA_RQST DR
, HZ_PARTIES PBV
, HZ_PARTIES PBV1
, IGS_DA_CNFG_REQ_TYP REQT
, IGS_PE_PERSID_GROUP_ALL PGRP
WHERE DR.PERSON_ID = PBV.PARTY_ID(+)
AND DR.REQUESTOR_ID = PBV1.PARTY_ID
AND DR.REQUEST_TYPE_ID = REQT.REQUEST_TYPE_ID
AND PGRP.GROUP_ID(+) = DR.PERSON_ID_GROUP_ID UNION ALL SELECT DR.ROWID
, DR.BATCH_ID
, DR.REQUEST_TYPE_ID
, DR.REQUEST_MODE
, (SELECT MEANING
FROM IGS_LOOKUPS_VIEW
WHERE LOOKUP_TYPE = 'IGS_DA_SELECTION_MODE'
AND LOOKUP_CODE = DR.REQUEST_MODE) REQUEST_MODE_MEANING
, DR.PROGRAM_COMPARISON_TYPE
, (SELECT MEANING
FROM IGS_LOOKUPS_VIEW
WHERE LOOKUP_TYPE = 'IGS_DA_PROG_COMP'
AND LOOKUP_CODE = DR.PROGRAM_COMPARISON_TYPE) PROGRAM_COMP_TYPE_MEANING
, DR.REQUEST_STATUS
, (SELECT MEANING
FROM IGS_LOOKUPS_VIEW
WHERE LOOKUP_TYPE = 'IGS_DA_RQST_STATUS'
AND LOOKUP_CODE = DR.REQUEST_STATUS) REQUEST_STATUS_MEANING
, DR.PERSON_ID_GROUP_ID
, NULL
, NULL
, DR.PERSON_ID
, PBV.PARTY_NUMBER
, PBV.PARTY_NAME
, DR.REQUESTOR_ID
, PBV1.PARTY_NUMBER
, PBV1.PARTY_NAME
, DR.STUDENT_RELEASE_IND
, DR.SPECIAL_PROGRAM
, (SELECT MEANING
FROM IGS_LOOKUPS_VIEW
WHERE LOOKUP_TYPE = 'IGS_DA_SPCL_PRGMS'
AND LOOKUP_CODE = DR.SPECIAL_PROGRAM) SPECIAL_PROGRAM_MEANING
, DR.SPECIAL_PROGRAM_CATALOG
, (SELECT MEANING
FROM IGS_LOOKUPS_VIEW
WHERE LOOKUP_TYPE = 'IGS_DA_SPCL_PRGM_CATS'
AND LOOKUP_CODE = DR.SPECIAL_PROGRAM_CATALOG) SPECIAL_PROG_CATALOG_MEANING
, REQT.REQUEST_NAME
, DR.ATTRIBUTE_CATEGORY
, DR.ATTRIBUTE1
, DR.ATTRIBUTE2
, DR.ATTRIBUTE3
, DR.ATTRIBUTE4
, DR.ATTRIBUTE5
, DR.ATTRIBUTE6
, DR.ATTRIBUTE7
, DR.ATTRIBUTE8
, DR.ATTRIBUTE9
, DR.ATTRIBUTE10
, DR.ATTRIBUTE11
, DR.ATTRIBUTE12
, DR.ATTRIBUTE13
, DR.ATTRIBUTE14
, DR.ATTRIBUTE15
, DR.ATTRIBUTE16
, DR.ATTRIBUTE17
, DR.ATTRIBUTE18
, DR.ATTRIBUTE19
, DR.ATTRIBUTE20
, DR.CREATION_DATE
, DR.CREATED_BY
, DR.LAST_UPDATE_LOGIN
, DR.LAST_UPDATED_BY
, DR.LAST_UPDATE_DATE
FROM IGS_DA_RQST DR
, IGS_DA_REQ_STDNTS STDNTS
, HZ_PARTIES PBV
, HZ_PARTIES PBV1
, IGS_DA_CNFG_REQ_TYP REQT
WHERE DR.BATCH_ID = STDNTS.BATCH_ID
AND DR.REQUESTOR_ID = PBV1.PARTY_ID
AND DR.REQUEST_TYPE_ID = REQT.REQUEST_TYPE_ID
AND DR.PERSON_ID IS NULL
AND DR.PERSON_ID_GROUP_ID IS NULL