VIEW: APPS.IGSFV_AD_ADM_APPL_REQ

Source

View Text - Preformatted

SELECT apr.APLINS_ADMREQ_ID, apr.PERSON_ID, p.PARTY_NUMBER, pp.PERSON_NAME, apr.ADMISSION_APPL_NUMBER, apr.COURSE_CD, apr.SEQUENCE_NUMBER, apr.TRACKING_ID, trst.TRACKING_STEP_ID, trst.TRACKING_STEP_NUMBER, trst.DESCRIPTION, trst.COMPLETION_DT, trst.ACTION_DAYS, '_LA:trst.STEP_COMPLETION_IND:IGS_LOOKUP_VALUES:YES_NO:MEANING', '_LA:trst.BY_PASS_IND:IGS_LOOKUP_VALUES:YES_NO:MEANING', tri.TRACKING_STATUS, tri.TRACKING_TYPE, trt.DESCRIPTION, '_LA:trt.S_TRACKING_TYPE:IGS_LOOKUP_VALUES:TRACKING_TYPE:MEANING', apr.created_by, apr.creation_date, apr.last_updated_by, apr.last_update_date FROM IGS_AD_APLINS_ADMREQ apr, HZ_PARTIES P, HZ_PERSON_PROFILES PP, IGS_TR_ITEM_ALL TRI, IGS_TR_TYPE_ALL TRT, IGS_TR_STEP trst WHERE apr.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 apr.TRACKING_ID = tri.TRACKING_ID AND tri.TRACKING_TYPE = trt.TRACKING_TYPE AND tri.TRACKING_ID = trst.TRACKING_ID WITH READ ONLY

View Text - HTML Formatted

SELECT APR.APLINS_ADMREQ_ID
, APR.PERSON_ID
, P.PARTY_NUMBER
, PP.PERSON_NAME
, APR.ADMISSION_APPL_NUMBER
, APR.COURSE_CD
, APR.SEQUENCE_NUMBER
, APR.TRACKING_ID
, TRST.TRACKING_STEP_ID
, TRST.TRACKING_STEP_NUMBER
, TRST.DESCRIPTION
, TRST.COMPLETION_DT
, TRST.ACTION_DAYS
, '_LA:TRST.STEP_COMPLETION_IND:IGS_LOOKUP_VALUES:YES_NO:MEANING'
, '_LA:TRST.BY_PASS_IND:IGS_LOOKUP_VALUES:YES_NO:MEANING'
, TRI.TRACKING_STATUS
, TRI.TRACKING_TYPE
, TRT.DESCRIPTION
, '_LA:TRT.S_TRACKING_TYPE:IGS_LOOKUP_VALUES:TRACKING_TYPE:MEANING'
, APR.CREATED_BY
, APR.CREATION_DATE
, APR.LAST_UPDATED_BY
, APR.LAST_UPDATE_DATE
FROM IGS_AD_APLINS_ADMREQ APR
, HZ_PARTIES P
, HZ_PERSON_PROFILES PP
, IGS_TR_ITEM_ALL TRI
, IGS_TR_TYPE_ALL TRT
, IGS_TR_STEP TRST
WHERE APR.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 APR.TRACKING_ID = TRI.TRACKING_ID
AND TRI.TRACKING_TYPE = TRT.TRACKING_TYPE
AND TRI.TRACKING_ID = TRST.TRACKING_ID WITH READ ONLY