99: company_cost_center_org_id, line_item_id, intercompany_id,
100: sum(xtd_balance_e), sum(ytd_balance_e),
101: sum(ptd_debit_balance_e), sum(ptd_credit_balance_e),
102: sum(ytd_debit_balance_e), sum(ytd_credit_balance_e),
103: sysdate, GCS_AGGREGATION_PKG.g_fnd_user_id,
104: sysdate, GCS_AGGREGATION_PKG.g_fnd_user_id,
105: GCS_AGGREGATION_PKG.g_fnd_login_id
106: FROM
107: GCS_HIERARCHIES_B ghb,
100: sum(xtd_balance_e), sum(ytd_balance_e),
101: sum(ptd_debit_balance_e), sum(ptd_credit_balance_e),
102: sum(ytd_debit_balance_e), sum(ytd_credit_balance_e),
103: sysdate, GCS_AGGREGATION_PKG.g_fnd_user_id,
104: sysdate, GCS_AGGREGATION_PKG.g_fnd_user_id,
105: GCS_AGGREGATION_PKG.g_fnd_login_id
106: FROM
107: GCS_HIERARCHIES_B ghb,
108: FEM_BALANCES fb,
101: sum(ptd_debit_balance_e), sum(ptd_credit_balance_e),
102: sum(ytd_debit_balance_e), sum(ytd_credit_balance_e),
103: sysdate, GCS_AGGREGATION_PKG.g_fnd_user_id,
104: sysdate, GCS_AGGREGATION_PKG.g_fnd_user_id,
105: GCS_AGGREGATION_PKG.g_fnd_login_id
106: FROM
107: GCS_HIERARCHIES_B ghb,
108: FEM_BALANCES fb,
109: GCS_CONS_RELATIONSHIPS gcr,
293:
294: SUM (xtd_balance_e), SUM (ytd_balance_e),
295: SUM (ptd_debit_balance_e), SUM (ptd_credit_balance_e),
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,
294: SUM (xtd_balance_e), SUM (ytd_balance_e),
295: SUM (ptd_debit_balance_e), SUM (ptd_credit_balance_e),
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,
295: SUM (ptd_debit_balance_e), SUM (ptd_credit_balance_e),
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,