eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

VIEW: APPS.IGS_PR_RU_CA_TYPE_V

Source

View Text - Preformatted


SELECT prct.progression_rule_cat, pra.sequence_number pra_sequence_number, prct.prg_cal_type, prct.start_sequence_number, prct.end_sequence_number, prct.start_effective_period, prct.num_of_applications, pra.s_relation_type, prct.pra_sequence_number original_pra_sequence_number, prct.CREATED_BY, prct.CREATION_DATE, prct.LAST_UPDATED_BY, prct.LAST_UPDATE_DATE, prct.LAST_UPDATE_LOGIN FROM IGS_PR_RU_APPL pra, IGS_PR_RU_CA_TYPE prct WHERE prct.progression_rule_cat = pra.progression_rule_cat AND prct.pra_sequence_number = pra.sequence_number UNION SELECT prct.progression_rule_cat, pra.sequence_number pra_sequence_number, prct.prg_cal_type, prct.start_sequence_number, prct.end_sequence_number, prct.start_effective_period, prct.num_of_applications, pra.s_relation_type, prct.pra_sequence_number original_pra_sequence_number, prct.CREATED_BY, prct.CREATION_DATE, prct.LAST_UPDATED_BY, prct.LAST_UPDATE_DATE, prct.LAST_UPDATE_LOGIN FROM IGS_PR_RU_APPL pra, IGS_PR_RU_APPL pra1, IGS_PR_RU_CA_TYPE prct WHERE pra.progression_rule_cd IS NOT NULL AND pra.s_relation_type IN ('CRV','OU','CTY','SCA','PRO','SPO') AND NOT EXISTS ( SELECT 'x' FROM IGS_PR_RU_CA_TYPE prct1 WHERE prct1.progression_rule_cat = pra.progression_rule_cat AND prct1.pra_sequence_number = pra.sequence_number ) AND pra1.s_relation_type = 'PRR' AND pra1.progression_rule_cat = pra.progression_rule_cat AND pra1.progression_rule_cd = pra.progression_rule_cd AND prct.progression_rule_cat = pra1.progression_rule_cat AND prct.pra_sequence_number = pra1.sequence_number UNION SELECT prct.progression_rule_cat, pra.sequence_number pra_sequence_number, prct.prg_cal_type, prct.start_sequence_number, prct.end_sequence_number, prct.start_effective_period, prct.num_of_applications, pra.s_relation_type, prct.pra_sequence_number original_pra_sequence_number, prct.CREATED_BY, prct.CREATION_DATE, prct.LAST_UPDATED_BY, prct.LAST_UPDATE_DATE, prct.LAST_UPDATE_LOGIN FROM IGS_PR_RU_APPL pra, IGS_PR_RU_APPL pra1, IGS_PR_RU_CA_TYPE prct WHERE pra.s_relation_type IN ('PRR','CRV','OU','CTY','SCA','PRO','SPO') AND NOT EXISTS ( SELECT 'x' FROM IGS_PR_RU_CA_TYPE prct1 WHERE prct1.progression_rule_cat = pra.progression_rule_cat AND prct1.pra_sequence_number = pra.sequence_number ) AND NOT EXISTS ( SELECT 'x' FROM IGS_PR_RU_APPL pra2, IGS_PR_RU_CA_TYPE prct2 WHERE pra2.s_relation_type = 'PRR' AND pra2.progression_rule_cat = pra.progression_rule_cat AND pra2.progression_rule_cd = pra.progression_rule_cd AND prct2.progression_rule_cat = pra2.progression_rule_cat AND prct2.pra_sequence_number = pra2.sequence_number ) AND pra1.s_relation_type = 'PRGC' AND pra1.progression_rule_cat = pra.progression_rule_cat AND prct.progression_rule_cat = pra1.progression_rule_cat AND prct.pra_sequence_number = pra1.sequence_number

View Text - HTML Formatted

SELECT PRCT.PROGRESSION_RULE_CAT
, PRA.SEQUENCE_NUMBER PRA_SEQUENCE_NUMBER
, PRCT.PRG_CAL_TYPE
, PRCT.START_SEQUENCE_NUMBER
, PRCT.END_SEQUENCE_NUMBER
, PRCT.START_EFFECTIVE_PERIOD
, PRCT.NUM_OF_APPLICATIONS
, PRA.S_RELATION_TYPE
, PRCT.PRA_SEQUENCE_NUMBER ORIGINAL_PRA_SEQUENCE_NUMBER
, PRCT.CREATED_BY
, PRCT.CREATION_DATE
, PRCT.LAST_UPDATED_BY
, PRCT.LAST_UPDATE_DATE
, PRCT.LAST_UPDATE_LOGIN
FROM IGS_PR_RU_APPL PRA
, IGS_PR_RU_CA_TYPE PRCT
WHERE PRCT.PROGRESSION_RULE_CAT = PRA.PROGRESSION_RULE_CAT
AND PRCT.PRA_SEQUENCE_NUMBER = PRA.SEQUENCE_NUMBER UNION SELECT PRCT.PROGRESSION_RULE_CAT
, PRA.SEQUENCE_NUMBER PRA_SEQUENCE_NUMBER
, PRCT.PRG_CAL_TYPE
, PRCT.START_SEQUENCE_NUMBER
, PRCT.END_SEQUENCE_NUMBER
, PRCT.START_EFFECTIVE_PERIOD
, PRCT.NUM_OF_APPLICATIONS
, PRA.S_RELATION_TYPE
, PRCT.PRA_SEQUENCE_NUMBER ORIGINAL_PRA_SEQUENCE_NUMBER
, PRCT.CREATED_BY
, PRCT.CREATION_DATE
, PRCT.LAST_UPDATED_BY
, PRCT.LAST_UPDATE_DATE
, PRCT.LAST_UPDATE_LOGIN
FROM IGS_PR_RU_APPL PRA
, IGS_PR_RU_APPL PRA1
, IGS_PR_RU_CA_TYPE PRCT
WHERE PRA.PROGRESSION_RULE_CD IS NOT NULL
AND PRA.S_RELATION_TYPE IN ('CRV'
, 'OU'
, 'CTY'
, 'SCA'
, 'PRO'
, 'SPO')
AND NOT EXISTS ( SELECT 'X'
FROM IGS_PR_RU_CA_TYPE PRCT1
WHERE PRCT1.PROGRESSION_RULE_CAT = PRA.PROGRESSION_RULE_CAT
AND PRCT1.PRA_SEQUENCE_NUMBER = PRA.SEQUENCE_NUMBER )
AND PRA1.S_RELATION_TYPE = 'PRR'
AND PRA1.PROGRESSION_RULE_CAT = PRA.PROGRESSION_RULE_CAT
AND PRA1.PROGRESSION_RULE_CD = PRA.PROGRESSION_RULE_CD
AND PRCT.PROGRESSION_RULE_CAT = PRA1.PROGRESSION_RULE_CAT
AND PRCT.PRA_SEQUENCE_NUMBER = PRA1.SEQUENCE_NUMBER UNION SELECT PRCT.PROGRESSION_RULE_CAT
, PRA.SEQUENCE_NUMBER PRA_SEQUENCE_NUMBER
, PRCT.PRG_CAL_TYPE
, PRCT.START_SEQUENCE_NUMBER
, PRCT.END_SEQUENCE_NUMBER
, PRCT.START_EFFECTIVE_PERIOD
, PRCT.NUM_OF_APPLICATIONS
, PRA.S_RELATION_TYPE
, PRCT.PRA_SEQUENCE_NUMBER ORIGINAL_PRA_SEQUENCE_NUMBER
, PRCT.CREATED_BY
, PRCT.CREATION_DATE
, PRCT.LAST_UPDATED_BY
, PRCT.LAST_UPDATE_DATE
, PRCT.LAST_UPDATE_LOGIN
FROM IGS_PR_RU_APPL PRA
, IGS_PR_RU_APPL PRA1
, IGS_PR_RU_CA_TYPE PRCT
WHERE PRA.S_RELATION_TYPE IN ('PRR'
, 'CRV'
, 'OU'
, 'CTY'
, 'SCA'
, 'PRO'
, 'SPO')
AND NOT EXISTS ( SELECT 'X'
FROM IGS_PR_RU_CA_TYPE PRCT1
WHERE PRCT1.PROGRESSION_RULE_CAT = PRA.PROGRESSION_RULE_CAT
AND PRCT1.PRA_SEQUENCE_NUMBER = PRA.SEQUENCE_NUMBER )
AND NOT EXISTS ( SELECT 'X'
FROM IGS_PR_RU_APPL PRA2
, IGS_PR_RU_CA_TYPE PRCT2
WHERE PRA2.S_RELATION_TYPE = 'PRR'
AND PRA2.PROGRESSION_RULE_CAT = PRA.PROGRESSION_RULE_CAT
AND PRA2.PROGRESSION_RULE_CD = PRA.PROGRESSION_RULE_CD
AND PRCT2.PROGRESSION_RULE_CAT = PRA2.PROGRESSION_RULE_CAT
AND PRCT2.PRA_SEQUENCE_NUMBER = PRA2.SEQUENCE_NUMBER )
AND PRA1.S_RELATION_TYPE = 'PRGC'
AND PRA1.PROGRESSION_RULE_CAT = PRA.PROGRESSION_RULE_CAT
AND PRCT.PROGRESSION_RULE_CAT = PRA1.PROGRESSION_RULE_CAT
AND PRCT.PRA_SEQUENCE_NUMBER = PRA1.SEQUENCE_NUMBER