VIEW: APPS.IGS_PE_TYP_INSTANCES

Source

View Text - Preformatted

SELECT tab.rowid row_id, tab.org_id org_id, tab.type_instance_id type_instance_id, tab.person_type_code person_type_code, tab.person_id person_id, tab.course_cd course_cd, tab.funnel_status funnel_status, tab.cc_version_number cc_version_number, tab.admission_appl_number admission_appl_number, tab.nominated_course_cd nominated_course_cd, tab.sequence_number sequence_number, tab.ncc_version_number ncc_version_number, tab.start_date start_date, tab.end_date end_date, tab.create_method create_method, tab.ended_by ended_by, tab.end_method end_method, tab.created_by created_by, tab.creation_date creation_date, tab.last_updated_by last_updated_by, tab.last_update_date last_update_date, tab.last_update_login last_update_login, typ.system_type FROM igs_pe_typ_instances_all tab , igs_pe_person_types typ WHERE TAB.PERSON_TYPE_CODE = TYP.PERSON_TYPE_CODE UNION ALL SELECT CHARTOROWID(NULL) ROW_ID, TO_NUMBER(NULL) , USG.PERSON_TYPE_USAGE_ID TYPE_INSTANCE_ID, MAP.PERSON_TYPE_CODE, PEO.PARTY_ID PERSON_ID, NULL , NULL , TO_NUMBER(NULL) , NULL , NULL , TO_NUMBER(NULL), TO_NUMBER(NULL), USG.EFFECTIVE_START_DATE START_DATE, USG.EFFECTIVE_END_DATE END_DATE, NULL , TO_NUMBER(NULL) , NULL , USG.CREATED_BY, USG.CREATION_DATE, USG.LAST_UPDATED_BY, USG.LAST_UPDATE_DATE, USG.LAST_UPDATE_LOGIN, MAP.SYSTEM_TYPE FROM PER_PERSON_TYPE_USAGES_F USG, PER_ALL_PEOPLE_F PEO, IGS_PE_PER_TYPE_MAP MAP WHERE USG.PERSON_ID = PEO.PERSON_ID AND USG.PERSON_TYPE_ID = MAP.PER_PERSON_TYPE_ID AND TRUNC(SYSDATE) BETWEEN PEO.EFFECTIVE_START_DATE and PEO.EFFECTIVE_END_DATE

View Text - HTML Formatted

SELECT TAB.ROWID ROW_ID
, TAB.ORG_ID ORG_ID
, TAB.TYPE_INSTANCE_ID TYPE_INSTANCE_ID
, TAB.PERSON_TYPE_CODE PERSON_TYPE_CODE
, TAB.PERSON_ID PERSON_ID
, TAB.COURSE_CD COURSE_CD
, TAB.FUNNEL_STATUS FUNNEL_STATUS
, TAB.CC_VERSION_NUMBER CC_VERSION_NUMBER
, TAB.ADMISSION_APPL_NUMBER ADMISSION_APPL_NUMBER
, TAB.NOMINATED_COURSE_CD NOMINATED_COURSE_CD
, TAB.SEQUENCE_NUMBER SEQUENCE_NUMBER
, TAB.NCC_VERSION_NUMBER NCC_VERSION_NUMBER
, TAB.START_DATE START_DATE
, TAB.END_DATE END_DATE
, TAB.CREATE_METHOD CREATE_METHOD
, TAB.ENDED_BY ENDED_BY
, TAB.END_METHOD END_METHOD
, TAB.CREATED_BY CREATED_BY
, TAB.CREATION_DATE CREATION_DATE
, TAB.LAST_UPDATED_BY LAST_UPDATED_BY
, TAB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, TAB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, TYP.SYSTEM_TYPE
FROM IGS_PE_TYP_INSTANCES_ALL TAB
, IGS_PE_PERSON_TYPES TYP
WHERE TAB.PERSON_TYPE_CODE = TYP.PERSON_TYPE_CODE UNION ALL SELECT CHARTOROWID(NULL) ROW_ID
, TO_NUMBER(NULL)
, USG.PERSON_TYPE_USAGE_ID TYPE_INSTANCE_ID
, MAP.PERSON_TYPE_CODE
, PEO.PARTY_ID PERSON_ID
, NULL
, NULL
, TO_NUMBER(NULL)
, NULL
, NULL
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, USG.EFFECTIVE_START_DATE START_DATE
, USG.EFFECTIVE_END_DATE END_DATE
, NULL
, TO_NUMBER(NULL)
, NULL
, USG.CREATED_BY
, USG.CREATION_DATE
, USG.LAST_UPDATED_BY
, USG.LAST_UPDATE_DATE
, USG.LAST_UPDATE_LOGIN
, MAP.SYSTEM_TYPE
FROM PER_PERSON_TYPE_USAGES_F USG
, PER_ALL_PEOPLE_F PEO
, IGS_PE_PER_TYPE_MAP MAP
WHERE USG.PERSON_ID = PEO.PERSON_ID
AND USG.PERSON_TYPE_ID = MAP.PER_PERSON_TYPE_ID
AND TRUNC(SYSDATE) BETWEEN PEO.EFFECTIVE_START_DATE
AND PEO.EFFECTIVE_END_DATE