VIEW: APPS.IGS_PR_PRG_RU_CA_TYPE_CI_V

Source

View Text - Preformatted

SELECT PRCTV.PROGRESSION_RULE_CAT , PRCTV.PRA_SEQUENCE_NUMBER , PRCTV.PRG_CAL_TYPE , CI.SEQUENCE_NUMBER , PRCTV.START_EFFECTIVE_PERIOD , PRCTV.NUM_OF_APPLICATIONS FROM IGS_PR_RU_CA_TYPE_V PRCTV, IGS_PR_RU_APPL PRA, IGS_CA_INST CI, IGS_CA_STAT CS WHERE PRA.PROGRESSION_RULE_CAT = PRCTV.PROGRESSION_RULE_CAT AND PRA.SEQUENCE_NUMBER = PRCTV.PRA_SEQUENCE_NUMBER AND PRA.LOGICAL_DELETE_DT IS NULL AND CI.CAL_TYPE = PRCTV.PRG_CAL_TYPE AND CS.CAL_STATUS = CI.CAL_STATUS AND CS.S_CAL_STATUS = 'ACTIVE' AND (( PRCTV.START_SEQUENCE_NUMBER IS NULL OR EXISTS ( SELECT 'x' FROM IGS_CA_INST SCI WHERE SCI.CAL_TYPE = PRCTV.PRG_CAL_TYPE AND SCI.SEQUENCE_NUMBER = PRCTV.START_SEQUENCE_NUMBER AND SCI.START_DT <= CI.START_DT ) ) AND ( PRCTV.END_SEQUENCE_NUMBER IS NULL OR EXISTS ( SELECT 'x' FROM IGS_CA_INST SCI WHERE SCI.CAL_TYPE = PRCTV.PRG_CAL_TYPE AND SCI.SEQUENCE_NUMBER = PRCTV.END_SEQUENCE_NUMBER AND SCI.START_DT >= CI.START_DT ) ) )

View Text - HTML Formatted

SELECT PRCTV.PROGRESSION_RULE_CAT
, PRCTV.PRA_SEQUENCE_NUMBER
, PRCTV.PRG_CAL_TYPE
, CI.SEQUENCE_NUMBER
, PRCTV.START_EFFECTIVE_PERIOD
, PRCTV.NUM_OF_APPLICATIONS
FROM IGS_PR_RU_CA_TYPE_V PRCTV
, IGS_PR_RU_APPL PRA
, IGS_CA_INST CI
, IGS_CA_STAT CS
WHERE PRA.PROGRESSION_RULE_CAT = PRCTV.PROGRESSION_RULE_CAT
AND PRA.SEQUENCE_NUMBER = PRCTV.PRA_SEQUENCE_NUMBER
AND PRA.LOGICAL_DELETE_DT IS NULL
AND CI.CAL_TYPE = PRCTV.PRG_CAL_TYPE
AND CS.CAL_STATUS = CI.CAL_STATUS
AND CS.S_CAL_STATUS = 'ACTIVE'
AND (( PRCTV.START_SEQUENCE_NUMBER IS NULL OR EXISTS ( SELECT 'X'
FROM IGS_CA_INST SCI
WHERE SCI.CAL_TYPE = PRCTV.PRG_CAL_TYPE
AND SCI.SEQUENCE_NUMBER = PRCTV.START_SEQUENCE_NUMBER
AND SCI.START_DT <= CI.START_DT ) )
AND ( PRCTV.END_SEQUENCE_NUMBER IS NULL OR EXISTS ( SELECT 'X'
FROM IGS_CA_INST SCI
WHERE SCI.CAL_TYPE = PRCTV.PRG_CAL_TYPE
AND SCI.SEQUENCE_NUMBER = PRCTV.END_SEQUENCE_NUMBER
AND SCI.START_DT >= CI.START_DT ) ) )