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_FI_UPG_RETENTION dependencies on IGS_FI_F_TYP_CA_INST

Line 19: ftci_rec_account_cd igs_fi_f_typ_ca_inst.rec_account_cd%TYPE,

15: shtatiko 11-DEC-2003 Bug# 3288973, Created this process
16: ***************************************************************** */
17:
18: TYPE ret_invoice_rec IS RECORD( invoice_id igs_fi_inv_int_all.invoice_id%TYPE,
19: ftci_rec_account_cd igs_fi_f_typ_ca_inst.rec_account_cd%TYPE,
20: ftci_rec_gl_ccid igs_fi_f_typ_ca_inst.rec_gl_ccid%TYPE,
21: ftci_ret_account_cd igs_fi_f_typ_ca_inst.ret_account_cd%TYPE,
22: ftci_ret_gl_ccid igs_fi_f_typ_ca_inst.ret_gl_ccid%TYPE );
23: TYPE ret_invoice_tab_type IS TABLE OF ret_invoice_rec

Line 20: ftci_rec_gl_ccid igs_fi_f_typ_ca_inst.rec_gl_ccid%TYPE,

16: ***************************************************************** */
17:
18: TYPE ret_invoice_rec IS RECORD( invoice_id igs_fi_inv_int_all.invoice_id%TYPE,
19: ftci_rec_account_cd igs_fi_f_typ_ca_inst.rec_account_cd%TYPE,
20: ftci_rec_gl_ccid igs_fi_f_typ_ca_inst.rec_gl_ccid%TYPE,
21: ftci_ret_account_cd igs_fi_f_typ_ca_inst.ret_account_cd%TYPE,
22: ftci_ret_gl_ccid igs_fi_f_typ_ca_inst.ret_gl_ccid%TYPE );
23: TYPE ret_invoice_tab_type IS TABLE OF ret_invoice_rec
24: INDEX BY BINARY_INTEGER;

Line 21: ftci_ret_account_cd igs_fi_f_typ_ca_inst.ret_account_cd%TYPE,

17:
18: TYPE ret_invoice_rec IS RECORD( invoice_id igs_fi_inv_int_all.invoice_id%TYPE,
19: ftci_rec_account_cd igs_fi_f_typ_ca_inst.rec_account_cd%TYPE,
20: ftci_rec_gl_ccid igs_fi_f_typ_ca_inst.rec_gl_ccid%TYPE,
21: ftci_ret_account_cd igs_fi_f_typ_ca_inst.ret_account_cd%TYPE,
22: ftci_ret_gl_ccid igs_fi_f_typ_ca_inst.ret_gl_ccid%TYPE );
23: TYPE ret_invoice_tab_type IS TABLE OF ret_invoice_rec
24: INDEX BY BINARY_INTEGER;
25:

Line 22: ftci_ret_gl_ccid igs_fi_f_typ_ca_inst.ret_gl_ccid%TYPE );

18: TYPE ret_invoice_rec IS RECORD( invoice_id igs_fi_inv_int_all.invoice_id%TYPE,
19: ftci_rec_account_cd igs_fi_f_typ_ca_inst.rec_account_cd%TYPE,
20: ftci_rec_gl_ccid igs_fi_f_typ_ca_inst.rec_gl_ccid%TYPE,
21: ftci_ret_account_cd igs_fi_f_typ_ca_inst.ret_account_cd%TYPE,
22: ftci_ret_gl_ccid igs_fi_f_typ_ca_inst.ret_gl_ccid%TYPE );
23: TYPE ret_invoice_tab_type IS TABLE OF ret_invoice_rec
24: INDEX BY BINARY_INTEGER;
25:
26: FUNCTION find_invoice ( p_n_invoice_id igs_fi_inv_int_all.invoice_id%TYPE,

Line 95: skharida 13-Feb-2006 APPSPERF: bug 5018036, Replaced igs_fi_f_typ_ca_inst_lkp_v by a join of igs_fi_f_typ_ca_inst and igs_ca_inst

91: Known limitations,enhancements,remarks:
92: Change History
93: Who When What
94: abshriva 4-May-2006 Bug 5178077: Introduced igs_ge_gen_003.set_org_id
95: skharida 13-Feb-2006 APPSPERF: bug 5018036, Replaced igs_fi_f_typ_ca_inst_lkp_v by a join of igs_fi_f_typ_ca_inst and igs_ca_inst
96: svuppala 30-MAY-2005 Enh 3442712 - Done the TBH modifications by adding
97: new columns Unit_Type_Id, Unit_Level in igs_fi_invln_int_all
98:
99: shtatiko 11-DEC-2003 Bug# 3288973, Created this process

Line 107: -- Bug 5018036, SQL ID 14794917: replaced igs_fi_f_typ_ca_inst_lkp_v by a join of igs_fi_f_typ_ca_inst and igs_ca_inst

103: CURSOR c_sys_opt_rec_acct IS
104: SELECT rec_installed, rec_gl_ccid, rec_account_cd, accounting_method
105: FROM igs_fi_control_all;
106:
107: -- Bug 5018036, SQL ID 14794917: replaced igs_fi_f_typ_ca_inst_lkp_v by a join of igs_fi_f_typ_ca_inst and igs_ca_inst
108: CURSOR c_upd_charges IS
109: SELECT a.invoice_id,
110: a.fee_type,
111: a.fee_cal_type,

Line 125: igs_fi_f_typ_ca_inst c,

121: c.ret_gl_ccid ftci_ret_gl_ccid,
122: c.ret_account_cd ftci_ret_account_cd
123: FROM igs_fi_inv_int_all a,
124: igs_fi_invln_int_all b,
125: igs_fi_f_typ_ca_inst c,
126: igs_ca_inst ci
127: WHERE a.invoice_id = b.invoice_id
128: AND a.transaction_type = 'RETENTION'
129: AND b.error_account = 'Y'

Line 137: -- Bug 5018036: Instead using igs_fi_f_typ_ca_inst_lkp_v joined igs_fi_f_typ_ca_inst and igs_ca_inst

133: And ci.cal_type=c.fee_cal_type
134: And ci.sequence_number = c.fee_ci_sequence_number
135: ORDER BY a.fee_type, a.fee_cal_type, a.fee_ci_sequence_number;
136:
137: -- Bug 5018036: Instead using igs_fi_f_typ_ca_inst_lkp_v joined igs_fi_f_typ_ca_inst and igs_ca_inst
138: CURSOR c_upd_applications IS
139: SELECT app.invoice_id ,
140: app.application_id ,
141: inv.fee_type ,

Line 156: igs_fi_f_typ_ca_inst ftci,

152: ci.start_dt,
153: ci.end_dt
154: FROM igs_fi_applications app,
155: igs_fi_inv_int_all inv,
156: igs_fi_f_typ_ca_inst ftci,
157: igs_ca_inst ci
158: WHERE app.invoice_id = inv.invoice_id
159: AND inv.transaction_type = 'RETENTION'
160: AND inv.fee_type = ftci.fee_type