54: sum(decode(sign(geg.output_amount), -1,
55: -1 *geg.output_amount, 0)),
56: sum(geg.output_amount),
57: sysdate,
58: fnd_global.user_id,
59: fnd_global.user_id,
60: sysdate,
61: fnd_global.login_id
62: FROM gcs_entries_gt geg
55: -1 *geg.output_amount, 0)),
56: sum(geg.output_amount),
57: sysdate,
58: fnd_global.user_id,
59: fnd_global.user_id,
60: sysdate,
61: fnd_global.login_id
62: FROM gcs_entries_gt geg
63: GROUP BY geg.tgt_line_item_id
57: sysdate,
58: fnd_global.user_id,
59: fnd_global.user_id,
60: sysdate,
61: fnd_global.login_id
62: FROM gcs_entries_gt geg
63: GROUP BY geg.tgt_line_item_id
64: ;
65:
89: sum(decode(sign(geg.output_amount), 1,
90: geg.output_amount, 0)),
91: -1 * sum(geg.output_amount),
92: sysdate,
93: fnd_global.user_id,
94: fnd_global.user_id,
95: sysdate,
96: fnd_global.login_id
97: FROM gcs_entries_gt geg
90: geg.output_amount, 0)),
91: -1 * sum(geg.output_amount),
92: sysdate,
93: fnd_global.user_id,
94: fnd_global.user_id,
95: sysdate,
96: fnd_global.login_id
97: FROM gcs_entries_gt geg
98: GROUP BY geg.off_line_item_id
92: sysdate,
93: fnd_global.user_id,
94: fnd_global.user_id,
95: sysdate,
96: fnd_global.login_id
97: FROM gcs_entries_gt geg
98: GROUP BY geg.off_line_item_id
99: ;
100: end if; --p_offset_flag = Y
120: sum(decode(sign(geg.output_amount), -1,
121: -1 *geg.output_amount, 0)),
122: sum(geg.output_amount),
123: sysdate,
124: fnd_global.user_id,
125: fnd_global.user_id,
126: sysdate,
127: fnd_global.login_id
128: FROM gcs_entries_gt geg
121: -1 *geg.output_amount, 0)),
122: sum(geg.output_amount),
123: sysdate,
124: fnd_global.user_id,
125: fnd_global.user_id,
126: sysdate,
127: fnd_global.login_id
128: FROM gcs_entries_gt geg
129: GROUP BY geg.src_company_cost_center_org_id, geg.tgt_line_item_id
123: sysdate,
124: fnd_global.user_id,
125: fnd_global.user_id,
126: sysdate,
127: fnd_global.login_id
128: FROM gcs_entries_gt geg
129: GROUP BY geg.src_company_cost_center_org_id, geg.tgt_line_item_id
130: ;
131:
155: sum(decode(sign(geg.output_amount), 1,
156: geg.output_amount, 0)),
157: -1 * sum(geg.output_amount),
158: sysdate,
159: fnd_global.user_id,
160: fnd_global.user_id,
161: sysdate,
162: fnd_global.login_id
163: FROM gcs_entries_gt geg
156: geg.output_amount, 0)),
157: -1 * sum(geg.output_amount),
158: sysdate,
159: fnd_global.user_id,
160: fnd_global.user_id,
161: sysdate,
162: fnd_global.login_id
163: FROM gcs_entries_gt geg
164: GROUP BY geg.src_company_cost_center_org_id, geg.off_line_item_id
158: sysdate,
159: fnd_global.user_id,
160: fnd_global.user_id,
161: sysdate,
162: fnd_global.login_id
163: FROM gcs_entries_gt geg
164: GROUP BY geg.src_company_cost_center_org_id, geg.off_line_item_id
165: ;
166: end if; --p_offset_flag = Y