[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select 'N'
into l_elimtb_y_n
from gcs_entries_gt geg
where formula_text NOT LIKE '%ELIMTB%'
and rownum < 2;
insert into gcs_entry_lines
( entry_id,
company_cost_center_org_id,
intercompany_id,
ytd_debit_balance_e,
ytd_credit_balance_e,
ytd_balance_e,
creation_date,
created_by,
last_updated_by,
last_update_date,
last_update_login
)
SELECT p_entry_id,
min(geg.tgt_company_cost_center_org_id),
min(geg.tgt_intercompany_id),
sum(decode(sign(geg.output_amount), 1,
geg.output_amount, 0)),
sum(decode(sign(geg.output_amount), -1,
-1 *geg.output_amount, 0)),
sum(geg.output_amount),
sysdate,
fnd_global.user_id,
fnd_global.user_id,
sysdate,
fnd_global.login_id
FROM gcs_entries_gt geg
GROUP BY geg.tgt_line_item_id
;
insert into gcs_entry_lines
( entry_id,
company_cost_center_org_id,
intercompany_id,
ytd_debit_balance_e,
ytd_credit_balance_e,
ytd_balance_e,
creation_date,
created_by,
last_updated_by,
last_update_date,
last_update_login
)
SELECT p_entry_id,
min(geg.tgt_company_cost_center_org_id),
min(geg.tgt_intercompany_id),
sum(decode(sign(geg.output_amount), -1,
-1 * geg.output_amount, 0)),
sum(decode(sign(geg.output_amount), 1,
geg.output_amount, 0)),
-1 * sum(geg.output_amount),
sysdate,
fnd_global.user_id,
fnd_global.user_id,
sysdate,
fnd_global.login_id
FROM gcs_entries_gt geg
GROUP BY geg.off_line_item_id
;
insert into gcs_entry_lines
( entry_id,
company_cost_center_org_id,
intercompany_id,
ytd_debit_balance_e,
ytd_credit_balance_e,
ytd_balance_e,
creation_date,
created_by,
last_updated_by,
last_update_date,
last_update_login
)
SELECT p_entry_id,
geg.src_company_cost_center_org_id,
min(geg.tgt_intercompany_id),
sum(decode(sign(geg.output_amount), 1,
geg.output_amount, 0)),
sum(decode(sign(geg.output_amount), -1,
-1 *geg.output_amount, 0)),
sum(geg.output_amount),
sysdate,
fnd_global.user_id,
fnd_global.user_id,
sysdate,
fnd_global.login_id
FROM gcs_entries_gt geg
GROUP BY geg.src_company_cost_center_org_id, geg.tgt_line_item_id
;
insert into gcs_entry_lines
( entry_id,
company_cost_center_org_id,
intercompany_id,
ytd_debit_balance_e,
ytd_credit_balance_e,
ytd_balance_e,
creation_date,
created_by,
last_updated_by,
last_update_date,
last_update_login
)
SELECT p_entry_id,
geg.src_company_cost_center_org_id,
min(geg.tgt_intercompany_id),
sum(decode(sign(geg.output_amount), -1,
-1 * geg.output_amount, 0)),
sum(decode(sign(geg.output_amount), 1,
geg.output_amount, 0)),
-1 * sum(geg.output_amount),
sysdate,
fnd_global.user_id,
fnd_global.user_id,
sysdate,
fnd_global.login_id
FROM gcs_entries_gt geg
GROUP BY geg.src_company_cost_center_org_id, geg.off_line_item_id
;