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.

APPS.IGS_AS_SS_DOC_REQUEST dependencies on IGS_CA_DA_INST_V

Line 13: igs_ca_da_inst_v daiv,

9: CURSOR c_ftci
10: IS
11: SELECT ftci.fee_cal_type, ftci.fee_ci_sequence_number
12: FROM igs_fi_f_typ_ca_inst ftci,
13: igs_ca_da_inst_v daiv,
14: igs_ca_da_inst_v daiv1,
15: igs_fi_fee_type ft,
16: igs_fi_fee_str_stat stat
17: WHERE ftci.fee_type = ft.fee_type

Line 14: igs_ca_da_inst_v daiv1,

10: IS
11: SELECT ftci.fee_cal_type, ftci.fee_ci_sequence_number
12: FROM igs_fi_f_typ_ca_inst ftci,
13: igs_ca_da_inst_v daiv,
14: igs_ca_da_inst_v daiv1,
15: igs_fi_fee_type ft,
16: igs_fi_fee_str_stat stat
17: WHERE ftci.fee_type = ft.fee_type
18: AND ft.s_fee_type = 'DOCUMENT'

Line 727: igs_ca_da_inst_v daiv,

723: ftci.fee_ci_sequence_number,
724: ftci.fee_type,
725: ft.description description
726: FROM igs_fi_f_typ_ca_inst ftci,
727: igs_ca_da_inst_v daiv,
728: igs_ca_da_inst_v daiv1,
729: igs_fi_fee_type ft,
730: igs_fi_fee_str_stat stat
731: WHERE ftci.fee_type = ft.fee_type

Line 728: igs_ca_da_inst_v daiv1,

724: ftci.fee_type,
725: ft.description description
726: FROM igs_fi_f_typ_ca_inst ftci,
727: igs_ca_da_inst_v daiv,
728: igs_ca_da_inst_v daiv1,
729: igs_fi_fee_type ft,
730: igs_fi_fee_str_stat stat
731: WHERE ftci.fee_type = ft.fee_type
732: AND ft.s_fee_type = 'DOCUMENT'

Line 2022: FROM igs_ca_da_inst_v daiv,

2018: ci.sequence_number,
2019: ci.description,
2020: NVL(
2021: ( SELECT MIN(daiv.alias_val)
2022: FROM igs_ca_da_inst_v daiv,
2023: igs_en_cal_conf secc
2024: WHERE secc.s_control_num = 1 AND
2025: daiv.cal_type = ci.cal_type AND
2026: daiv.ci_sequence_number= ci.sequence_number AND

Line 2071: FROM igs_ca_da_inst_v daiv,

2067: ci.end_dt ,
2068: NVL(
2069: (
2070: SELECT MIN(daiv.alias_val)
2071: FROM igs_ca_da_inst_v daiv,
2072: igs_en_cal_conf secc
2073: WHERE secc.s_control_num = 1 AND
2074: daiv.cal_type = ci.cal_type AND
2075: daiv.ci_sequence_number= ci.sequence_number AND

Line 2115: FROM igs_ca_da_inst_v daiv,

2111: ci.end_dt ,
2112: NVL(
2113: (
2114: SELECT MIN(daiv.alias_val)
2115: FROM igs_ca_da_inst_v daiv,
2116: igs_en_cal_conf secc
2117: WHERE secc.s_control_num = 1 AND
2118: daiv.cal_type = ci.cal_type AND
2119: daiv.ci_sequence_number= ci.sequence_number AND

Line 2517: igs_ca_da_inst_v daiv,

2513: ftci.fee_ci_sequence_number,
2514: ftci.fee_type,
2515: ft.description description
2516: FROM igs_fi_f_typ_ca_inst ftci,
2517: igs_ca_da_inst_v daiv,
2518: igs_ca_da_inst_v daiv1,
2519: igs_fi_fee_type ft,
2520: igs_fi_fee_str_stat stat
2521: WHERE ftci.fee_type = ft.fee_type

Line 2518: igs_ca_da_inst_v daiv1,

2514: ftci.fee_type,
2515: ft.description description
2516: FROM igs_fi_f_typ_ca_inst ftci,
2517: igs_ca_da_inst_v daiv,
2518: igs_ca_da_inst_v daiv1,
2519: igs_fi_fee_type ft,
2520: igs_fi_fee_str_stat stat
2521: WHERE ftci.fee_type = ft.fee_type
2522: AND ft.s_fee_type = 'DOCUMENT'