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.GCS_AGGREGATION_DYNAMIC_PKG dependencies on GCS_ENTRY_LINES

Line 89: INSERT /+ APPEND / INTO GCS_ENTRY_LINES

85: IF (l_bal_by_org_flag = 'Y') THEN -- Balancing by org
86:
87: -- Create entry lines
88: -- bug fix 5066467: removed ordered hint
89: INSERT /*+ APPEND */ INTO GCS_ENTRY_LINES
90: (entry_id, line_type_code,
91: company_cost_center_org_id, line_item_id, intercompany_id,
92: xtd_balance_e, ytd_balance_e,
93: ptd_debit_balance_e, ptd_credit_balance_e,

Line 169: -- Now we first select the rows from fb to gcs_entry_lines_gt table, RE/SUSPENSE will be handled in this step

165: END LOOP;
166:
167:
168: -- bug fix 5066467: rewrite the code for hanlding RE/SUSPENSE/CTA
169: -- Now we first select the rows from fb to gcs_entry_lines_gt table, RE/SUSPENSE will be handled in this step
170: -- Then we update gcs_entry_lines_gt for CTA lines
171: -- Lastly, we move everything from gcs_entry_lines_gt to gcs_entry_lines
172: INSERT INTO gcs_entry_lines_gt
173: (entry_id, line_item_id, company_cost_center_org_id, intercompany_id,

Line 170: -- Then we update gcs_entry_lines_gt for CTA lines

166:
167:
168: -- bug fix 5066467: rewrite the code for hanlding RE/SUSPENSE/CTA
169: -- Now we first select the rows from fb to gcs_entry_lines_gt table, RE/SUSPENSE will be handled in this step
170: -- Then we update gcs_entry_lines_gt for CTA lines
171: -- Lastly, we move everything from gcs_entry_lines_gt to gcs_entry_lines
172: INSERT INTO gcs_entry_lines_gt
173: (entry_id, line_item_id, company_cost_center_org_id, intercompany_id,
174: xtd_balance_e, ytd_balance_e,

Line 171: -- Lastly, we move everything from gcs_entry_lines_gt to gcs_entry_lines

167:
168: -- bug fix 5066467: rewrite the code for hanlding RE/SUSPENSE/CTA
169: -- Now we first select the rows from fb to gcs_entry_lines_gt table, RE/SUSPENSE will be handled in this step
170: -- Then we update gcs_entry_lines_gt for CTA lines
171: -- Lastly, we move everything from gcs_entry_lines_gt to gcs_entry_lines
172: INSERT INTO gcs_entry_lines_gt
173: (entry_id, line_item_id, company_cost_center_org_id, intercompany_id,
174: xtd_balance_e, ytd_balance_e,
175: ptd_debit_balance_e, ptd_credit_balance_e,

Line 172: INSERT INTO gcs_entry_lines_gt

168: -- bug fix 5066467: rewrite the code for hanlding RE/SUSPENSE/CTA
169: -- Now we first select the rows from fb to gcs_entry_lines_gt table, RE/SUSPENSE will be handled in this step
170: -- Then we update gcs_entry_lines_gt for CTA lines
171: -- Lastly, we move everything from gcs_entry_lines_gt to gcs_entry_lines
172: INSERT INTO gcs_entry_lines_gt
173: (entry_id, line_item_id, company_cost_center_org_id, intercompany_id,
174: xtd_balance_e, ytd_balance_e,
175: ptd_debit_balance_e, ptd_credit_balance_e,
176: ytd_debit_balance_e, ytd_credit_balance_e)

Line 240: UPDATE gcs_entry_lines_gt gelg

236: company_cost_center_org_id),
237: intercompany_id), intercompany_id),
238: fb.line_item_id;
239:
240: UPDATE gcs_entry_lines_gt gelg
241: SET company_cost_center_org_id = l_default_org_id,
242: intercompany_id = DECODE(intercompany_id, company_cost_center_org_id,
243: DECODE(l_intercompany_id, NULL, l_default_org_id),
244: intercompany_id)

Line 283: INSERT /+ append /INTO gcs_entry_lines

279: ))
280: GROUP BY
281: line_item_id, cr2.child_entity_id);
282:
283: INSERT /*+ append */INTO gcs_entry_lines
284: (entry_id, company_cost_center_org_id, line_item_id,
285: intercompany_id,
286: xtd_balance_e, ytd_balance_e,
287: ptd_debit_balance_e, ptd_credit_balance_e,

Line 300: FROM gcs_entry_lines_gt

296: SUM (ytd_debit_balance_e), SUM (ytd_credit_balance_e),
297: SYSDATE, gcs_aggregation_pkg.g_fnd_user_id, SYSDATE,
298: gcs_aggregation_pkg.g_fnd_user_id,
299: gcs_aggregation_pkg.g_fnd_login_id
300: FROM gcs_entry_lines_gt
301: GROUP BY entry_id,
302: company_cost_center_org_id,
303: line_item_id,
304: intercompany_id;