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.IGF_SP_GEN_001 dependencies on IGS_FI_CR_TYPES_ALL

Line 139: igs_fi_cr_types_all cr

135: IS
136: SELECT appl.amount_applied AS amount_applied
137: FROM igs_fi_applications appl,
138: igs_fi_credits_all crd,
139: igs_fi_cr_types_all cr
140: WHERE appl.invoice_id = cp_n_invoice_id
141: AND appl.application_type = 'APP'
142: AND crd.credit_id = appl.credit_id
143: AND crd.credit_type_id = cr.credit_type_id

Line 153: igs_fi_cr_types_all cr

149: IS
150: SELECT igs_fi_gen_007.get_sum_appl_amnt (appl.application_id) amount_applied , application_id
151: FROM igs_fi_applications appl,
152: igs_fi_credits_all crd,
153: igs_fi_cr_types_all cr
154: WHERE appl.invoice_id = cp_n_invoice_id
155: AND appl.application_type = 'APP'
156: AND crd.credit_id = appl.credit_id
157: AND crd.status = 'CLEARED'

Line 173: igs_fi_cr_types_all cr

169: IS
170: SELECT appl.amount_applied AS amount_applied, appl.credit_id as credit_id
171: FROM igs_fi_applications appl,
172: igs_fi_credits_all crd,
173: igs_fi_cr_types_all cr
174: WHERE appl.invoice_id = cp_n_invoice_id
175: AND appl.application_type = 'APP'
176: AND crd.credit_id = appl.credit_id
177: AND crd.fee_cal_type = cp_v_fee_cal_type