VIEW: APPS.IGSFV_PERSON_HOLDS

Source

View Text - Preformatted

SELECT PEN.PERSON_ID PERSON_ID, PEN.ENCUMBRANCE_TYPE HOLD_TYPE, PEN.START_DT EFFECTIVE_START_DATE, PEN.EXPIRY_DT EXPIRY_DATE, PEN.COMMENTS NOTES, PEN.SPO_COURSE_CD PROG_OUTCOME_PROGRAM_CODE, PEN.SPO_SEQUENCE_NUMBER PROG_OUTCOME_SEQUENCE_NUMBER, PEN.CAL_TYPE CALENDAR_TYPE, PEN.SEQUENCE_NUMBER SEQUENCE_NUMBER, HP1.PARTY_NUMBER PERSON_NUMBER, ENT.DESCRIPTION HOLD_TYPE_DESCRIPTION, HP2.PARTY_NUMBER AUTHORIZING_PERSON_NUMBER, CA.ALTERNATE_CODE TERM, PEN.AUTHORISING_PERSON_ID AUTHORIZING_PERSON_ID, PEN.AUTH_RESP_ID AUTH_RESP_ID, R.RESPONSIBILITY_NAME AUTH_RESP_NAME, PEN.CREATED_BY, PEN.CREATION_DATE, PEN.LAST_UPDATED_BY, PEN.LAST_UPDATE_DATE, '_LA:EXTERNAL_REFERENCE:IGS_LOOKUP_VALUES:PE_EXT_REF:MEANING' FROM IGS_PE_PERS_ENCUMB PEN, HZ_PARTIES HP1, IGS_FI_ENCMB_TYPE_ALL ENT, HZ_PARTIES HP2, IGS_CA_INST_ALL CA , FND_RESPONSIBILITY_VL R WHERE PEN.ENCUMBRANCE_TYPE = ENT.ENCUMBRANCE_TYPE AND PEN.PERSON_ID = HP1.PARTY_ID AND PEN.AUTHORISING_PERSON_ID = HP2.PARTY_ID (+) AND PEN.CAL_TYPE = CA.CAL_TYPE(+) AND PEN.SEQUENCE_NUMBER = CA.SEQUENCE_NUMBER(+) AND PEN.AUTH_RESP_ID = R.RESPONSIBILITY_ID (+) WITH READ ONLY

View Text - HTML Formatted

SELECT PEN.PERSON_ID PERSON_ID
, PEN.ENCUMBRANCE_TYPE HOLD_TYPE
, PEN.START_DT EFFECTIVE_START_DATE
, PEN.EXPIRY_DT EXPIRY_DATE
, PEN.COMMENTS NOTES
, PEN.SPO_COURSE_CD PROG_OUTCOME_PROGRAM_CODE
, PEN.SPO_SEQUENCE_NUMBER PROG_OUTCOME_SEQUENCE_NUMBER
, PEN.CAL_TYPE CALENDAR_TYPE
, PEN.SEQUENCE_NUMBER SEQUENCE_NUMBER
, HP1.PARTY_NUMBER PERSON_NUMBER
, ENT.DESCRIPTION HOLD_TYPE_DESCRIPTION
, HP2.PARTY_NUMBER AUTHORIZING_PERSON_NUMBER
, CA.ALTERNATE_CODE TERM
, PEN.AUTHORISING_PERSON_ID AUTHORIZING_PERSON_ID
, PEN.AUTH_RESP_ID AUTH_RESP_ID
, R.RESPONSIBILITY_NAME AUTH_RESP_NAME
, PEN.CREATED_BY
, PEN.CREATION_DATE
, PEN.LAST_UPDATED_BY
, PEN.LAST_UPDATE_DATE
, '_LA:EXTERNAL_REFERENCE:IGS_LOOKUP_VALUES:PE_EXT_REF:MEANING'
FROM IGS_PE_PERS_ENCUMB PEN
, HZ_PARTIES HP1
, IGS_FI_ENCMB_TYPE_ALL ENT
, HZ_PARTIES HP2
, IGS_CA_INST_ALL CA
, FND_RESPONSIBILITY_VL R
WHERE PEN.ENCUMBRANCE_TYPE = ENT.ENCUMBRANCE_TYPE
AND PEN.PERSON_ID = HP1.PARTY_ID
AND PEN.AUTHORISING_PERSON_ID = HP2.PARTY_ID (+)
AND PEN.CAL_TYPE = CA.CAL_TYPE(+)
AND PEN.SEQUENCE_NUMBER = CA.SEQUENCE_NUMBER(+)
AND PEN.AUTH_RESP_ID = R.RESPONSIBILITY_ID (+) WITH READ ONLY