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.CST_UPD_GIR_MTA_WTA dependencies on GL_IMPORT_REFERENCES

Line 89: and exists (select 1 from gl_import_references jir

85: where gh.je_batch_id = p_je_batch_id
86: and gl.je_header_id = gh.je_header_id
87: and gh.je_category = 'MTL'
88: and gh.actual_flag = 'A'
89: and exists (select 1 from gl_import_references jir
90: where jir.je_header_id = gl.je_header_id
91: and jir.je_line_num = gl.je_line_num
92: and jir.gl_sl_link_table = 'MTA'
93: and (jir.gl_sl_link_id is null or p_rerun_mode = 'Y') --Flexible Logic

Line 139: or exists ( select 1 from gl_import_references R

135: or (sl.gl_dr_cr_flag = -1 and mta.base_transaction_value < 0)
136: )
137: and ( mta.gl_sl_link_id is null
138: --To correct data during During re-runs
139: or exists ( select 1 from gl_import_references R
140: where R.gl_sl_link_table = 'MTA'
141: and R.gl_sl_link_id = mta.gl_sl_link_id
142: and R.reference_3 is null )) --Support Flexible Logic
143: and mta.encumbrance_type_id is null

Line 190: --Deleting duplicate records from gl_import_references

186: IF je_header_id_tab.count = 0 THEN
187: EXIT;
188: END IF;
189:
190: --Deleting duplicate records from gl_import_references
191: l_stmnt_num := 10;
192: FORALL i IN 1..je_header_id_tab.COUNT
193: delete /*+ index(jir gl_import_references_n1) */
194: from gl_import_references jir

Line 193: delete /+ index(jir gl_import_references_n1) /

189:
190: --Deleting duplicate records from gl_import_references
191: l_stmnt_num := 10;
192: FORALL i IN 1..je_header_id_tab.COUNT
193: delete /*+ index(jir gl_import_references_n1) */
194: from gl_import_references jir
195: where jir.je_header_id = je_header_id_tab(i)
196: and jir.je_line_num = je_line_num_tab(i)
197: and exists

Line 194: from gl_import_references jir

190: --Deleting duplicate records from gl_import_references
191: l_stmnt_num := 10;
192: FORALL i IN 1..je_header_id_tab.COUNT
193: delete /*+ index(jir gl_import_references_n1) */
194: from gl_import_references jir
195: where jir.je_header_id = je_header_id_tab(i)
196: and jir.je_line_num = je_line_num_tab(i)
197: and exists
198: ( select /*+ index(jir1 gl_import_references_n1) */ 1

Line 198: ( select /+ index(jir1 gl_import_references_n1) / 1

194: from gl_import_references jir
195: where jir.je_header_id = je_header_id_tab(i)
196: and jir.je_line_num = je_line_num_tab(i)
197: and exists
198: ( select /*+ index(jir1 gl_import_references_n1) */ 1
199: from gl_import_references jir1
200: where jir1.je_header_id = jir.je_header_id
201: and jir1.je_line_num = jir.je_line_num
202: and jir1.je_batch_id = jir.je_batch_id

Line 199: from gl_import_references jir1

195: where jir.je_header_id = je_header_id_tab(i)
196: and jir.je_line_num = je_line_num_tab(i)
197: and exists
198: ( select /*+ index(jir1 gl_import_references_n1) */ 1
199: from gl_import_references jir1
200: where jir1.je_header_id = jir.je_header_id
201: and jir1.je_line_num = jir.je_line_num
202: and jir1.je_batch_id = jir.je_batch_id
203: and nvl(jir1.reference_1, -1) = nvl(jir.reference_1, -1)

Line 229: select /+ index(jir gl_import_references_n1) /

225: ledger_currency_code,
226: gir_rowid,
227: gl_sl_link_id
228: )
229: select /*+ index(jir gl_import_references_n1) */
230: je_header_id_tab(i),
231: je_line_num_tab(i),
232: nvl(jir.reference_1, -1),
233: code_combination_id_tab(i),

Line 240: from gl_import_references jir

236: gl_sign_flag_tab(i),
237: ledger_currency_code_tab(i),
238: jir.rowid,
239: nvl(jir.gl_sl_link_id, xla_gl_sl_link_id_s.nextval) --Support Flexible Logic
240: from gl_import_references jir
241: where jir.je_header_id = je_header_id_tab(i)
242: and jir.je_line_num = je_line_num_tab(i);
243:
244: debug(' L'||l_count||': Inserted '||SQL%ROWCOUNT||' rows in SL');

Line 325: update gl_import_references gir

321: END IF;
322:
323: l_stmnt_num := 60;
324: FORALL i in 1..gir_rowid_tab.count
325: update gl_import_references gir
326: set gir.gl_sl_link_id = gl_sl_link_id_tab(i)
327: where gir.rowid = gir_rowid_tab(i)
328: and gir.gl_sl_link_id is null; --Support Flexible Logic
329:

Line 430: and exists (select 1 from gl_import_references jir

426: where gh.je_batch_id = p_je_batch_id
427: and gl.je_header_id = gh.je_header_id
428: and gh.je_category = 'WIP'
429: and gh.actual_flag = 'A'
430: and exists (select 1 from gl_import_references jir
431: where jir.je_header_id = gl.je_header_id
432: and jir.je_line_num = gl.je_line_num
433: and jir.gl_sl_link_table = 'WTA'
434: and (jir.gl_sl_link_id is null or p_rerun_mode = 'Y') --Flexible Logic

Line 480: or exists ( select 1 from gl_import_references R

476: or (sl.gl_dr_cr_flag = -1 and wta.base_transaction_value < 0)
477: )
478: and ( wta.gl_sl_link_id is null
479: --To correct data during During re-runs
480: or exists ( select 1 from gl_import_references R
481: where R.gl_sl_link_table = 'WTA'
482: and R.gl_sl_link_id = wta.gl_sl_link_id
483: and R.reference_3 is null )) --Support Flexible Logic
484: order by sl.gl_sl_link_id;

Line 530: --Deleting duplicate records from gl_import_references

526: IF je_header_id_tab.count = 0 THEN
527: EXIT;
528: END IF;
529:
530: --Deleting duplicate records from gl_import_references
531: l_stmnt_num := 10;
532: FORALL i IN 1..je_header_id_tab.COUNT
533: delete /*+ index(jir gl_import_references_n1) */
534: from gl_import_references jir

Line 533: delete /+ index(jir gl_import_references_n1) /

529:
530: --Deleting duplicate records from gl_import_references
531: l_stmnt_num := 10;
532: FORALL i IN 1..je_header_id_tab.COUNT
533: delete /*+ index(jir gl_import_references_n1) */
534: from gl_import_references jir
535: where jir.je_header_id = je_header_id_tab(i)
536: and jir.je_line_num = je_line_num_tab(i)
537: and exists

Line 534: from gl_import_references jir

530: --Deleting duplicate records from gl_import_references
531: l_stmnt_num := 10;
532: FORALL i IN 1..je_header_id_tab.COUNT
533: delete /*+ index(jir gl_import_references_n1) */
534: from gl_import_references jir
535: where jir.je_header_id = je_header_id_tab(i)
536: and jir.je_line_num = je_line_num_tab(i)
537: and exists
538: ( select /*+ index(jir1 gl_import_references_n1) */ 1

Line 538: ( select /+ index(jir1 gl_import_references_n1) / 1

534: from gl_import_references jir
535: where jir.je_header_id = je_header_id_tab(i)
536: and jir.je_line_num = je_line_num_tab(i)
537: and exists
538: ( select /*+ index(jir1 gl_import_references_n1) */ 1
539: from gl_import_references jir1
540: where jir1.je_header_id = jir.je_header_id
541: and jir1.je_line_num = jir.je_line_num
542: and jir1.je_batch_id = jir.je_batch_id

Line 539: from gl_import_references jir1

535: where jir.je_header_id = je_header_id_tab(i)
536: and jir.je_line_num = je_line_num_tab(i)
537: and exists
538: ( select /*+ index(jir1 gl_import_references_n1) */ 1
539: from gl_import_references jir1
540: where jir1.je_header_id = jir.je_header_id
541: and jir1.je_line_num = jir.je_line_num
542: and jir1.je_batch_id = jir.je_batch_id
543: and nvl(jir1.reference_1, -1) = nvl(jir.reference_1, -1)

Line 569: select /+ index(jir gl_import_references_n1) /

565: ledger_currency_code,
566: gir_rowid,
567: gl_sl_link_id
568: )
569: select /*+ index(jir gl_import_references_n1) */
570: je_header_id_tab(i),
571: je_line_num_tab(i),
572: nvl(jir.reference_1, -1),
573: code_combination_id_tab(i),

Line 580: from gl_import_references jir

576: gl_sign_flag_tab(i),
577: ledger_currency_code_tab(i),
578: jir.rowid,
579: nvl(jir.gl_sl_link_id, xla_gl_sl_link_id_s.nextval) --Support Flexible Logic
580: from gl_import_references jir
581: where jir.je_header_id = je_header_id_tab(i)
582: and jir.je_line_num = je_line_num_tab(i);
583:
584: debug(' L'||l_count||': Inserted '||SQL%ROWCOUNT||' rows in SL');

Line 665: update gl_import_references gir

661: END IF;
662:
663: l_stmnt_num := 60;
664: FORALL i in 1..gir_rowid_tab.count
665: update gl_import_references gir
666: set gir.gl_sl_link_id = gl_sl_link_id_tab(i)
667: where gir.rowid = gir_rowid_tab(i)
668: and gir.gl_sl_link_id is null; --Support Flexible Logic
669: