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.

[Home] [Help]

APPS.GCS_AGGREGATION_DYNAMIC_PKG dependencies on GCS_ENTRY_LINES_GT

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 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;