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_TEMPLATES_DYNAMIC_PKG dependencies on GCS_ENTRY_LINES

Line 205: 'MERGE INTO gcs_entry_lines gel

201:
202: IF org_tracking_flag = 'Y' AND secondary_dimension_column IS NOT NULL
203: THEN
204: l_merge_statement :=
205: 'MERGE INTO gcs_entry_lines gel
206: USING (
207: SELECT gel_1.company_cost_center_org_id,
208:
209: SUM ( NVL (gel_1.ytd_credit_balance_e, 0)

Line 212: FROM gcs_dimension_templates gdt, gcs_entry_lines gel_1, fem_ln_items_attr flia,

208:
209: SUM ( NVL (gel_1.ytd_credit_balance_e, 0)
210: - NVL (gel_1.ytd_debit_balance_e, 0)
211: ) amount
212: FROM gcs_dimension_templates gdt, gcs_entry_lines gel_1, fem_ln_items_attr flia,
213: fem_ext_acct_types_attr feata
214: WHERE gdt.hierarchy_id = :1
215: AND gdt.template_code = ''RE''
216: AND gel_1.entry_id = :2

Line 286: 'MERGE INTO gcs_entry_lines gel

282: fnd_global.login_id;
283: ELSIF secondary_dimension_column IS NOT NULL
284: THEN
285: l_merge_statement :=
286: 'MERGE INTO gcs_entry_lines gel
287: USING (
288: SELECT :6 company_cost_center_org_id,
289:
290: SUM ( NVL (gel_1.ytd_credit_balance_e, 0)

Line 292: FROM gcs_dimension_templates gdt, gcs_entry_lines gel_1, fem_ln_items_attr flia,

288: SELECT :6 company_cost_center_org_id,
289:
290: SUM ( NVL (gel_1.ytd_credit_balance_e, 0)
291: - NVL (gel_1.ytd_debit_balance_e, 0)) amount
292: FROM gcs_dimension_templates gdt, gcs_entry_lines gel_1, fem_ln_items_attr flia,
293: fem_ext_acct_types_attr feata
294: WHERE gdt.hierarchy_id = :1
295: AND gdt.template_code = ''RE''
296: AND gel_1.entry_id = :2

Line 367: 'MERGE INTO gcs_entry_lines gel

363: fnd_global.login_id;
364: ELSIF org_tracking_flag = 'Y'
365: THEN
366: l_merge_statement :=
367: 'MERGE INTO gcs_entry_lines gel
368: USING (SELECT gel_1.company_cost_center_org_id,
369: SUM ( NVL (gel_1.ytd_credit_balance_e, 0)
370: - NVL (gel_1.ytd_debit_balance_e, 0)
371: ) amount

Line 372: FROM gcs_dimension_templates gdt, gcs_entry_lines gel_1, fem_ln_items_attr flia,

368: USING (SELECT gel_1.company_cost_center_org_id,
369: SUM ( NVL (gel_1.ytd_credit_balance_e, 0)
370: - NVL (gel_1.ytd_debit_balance_e, 0)
371: ) amount
372: FROM gcs_dimension_templates gdt, gcs_entry_lines gel_1, fem_ln_items_attr flia,
373: fem_ext_acct_types_attr feata
374: WHERE gdt.hierarchy_id = :1
375: AND gdt.template_code = ''RE''
376: AND gel_1.entry_id = :2

Line 444: 'MERGE INTO gcs_entry_lines gel

440: fnd_global.user_id,
441: fnd_global.login_id;
442: ELSE
443: l_merge_statement :=
444: 'MERGE INTO gcs_entry_lines gel
445: USING (SELECT :6 company_cost_center_org_id,
446: SUM ( NVL (gel_1.ytd_credit_balance_e, 0)
447: - NVL (gel_1.ytd_debit_balance_e, 0)
448: ) amount

Line 449: FROM gcs_dimension_templates gdt, gcs_entry_lines gel_1, fem_ln_items_attr flia,

445: USING (SELECT :6 company_cost_center_org_id,
446: SUM ( NVL (gel_1.ytd_credit_balance_e, 0)
447: - NVL (gel_1.ytd_debit_balance_e, 0)
448: ) amount
449: FROM gcs_dimension_templates gdt, gcs_entry_lines gel_1, fem_ln_items_attr flia,
450: fem_ext_acct_types_attr feata
451: WHERE gdt.hierarchy_id = :1
452: AND gdt.template_code = ''RE''
453: AND gel_1.entry_id = :2

Line 705: 'MERGE INTO gcs_entry_lines gel

701:
702: IF org_tracking_flag = 'Y' AND secondary_dimension_column IS NOT NULL
703: THEN
704: l_merge_statement :=
705: 'MERGE INTO gcs_entry_lines gel
706: USING (
707: SELECT fb.company_cost_center_org_id,
708:
709: SUM ( NVL (fb.ytd_credit_balance_e, 0)

Line 790: 'MERGE INTO gcs_entry_lines gel

786: fnd_global.login_id;
787: ELSIF secondary_dimension_column IS NOT NULL
788: THEN
789: l_merge_statement :=
790: 'MERGE INTO gcs_entry_lines gel
791: USING (
792: SELECT :6 company_cost_center_org_id,
793:
794: SUM ( NVL (fb.ytd_credit_balance_e, 0)

Line 876: 'MERGE INTO gcs_entry_lines gel

872: fnd_global.login_id;
873: ELSIF org_tracking_flag = 'Y'
874: THEN
875: l_merge_statement :=
876: 'MERGE INTO gcs_entry_lines gel
877: USING (SELECT fb.company_cost_center_org_id,
878: SUM ( NVL (fb.ytd_credit_balance_e, 0)
879: - NVL (fb.ytd_debit_balance_e, 0)
880: ) amount

Line 957: 'MERGE INTO gcs_entry_lines gel

953: fnd_global.user_id,
954: fnd_global.login_id;
955: ELSE
956: l_merge_statement :=
957: 'MERGE INTO gcs_entry_lines gel
958: USING (SELECT :6 company_cost_center_org_id,
959: SUM ( NVL (fb.ytd_credit_balance_e, 0)
960: - NVL (fb.ytd_debit_balance_e, 0)
961: ) amount

Line 1312: 'MERGE INTO gcs_entry_lines gel

1308:
1309: IF org_tracking_flag = 'Y' AND secondary_dimension_column IS NOT NULL
1310: THEN
1311: l_merge_statement :=
1312: 'MERGE INTO gcs_entry_lines gel
1313: USING (
1314: SELECT gel_1.company_cost_center_org_id,
1315:
1316: SUM ( NVL (gel_1.ytd_credit_balance_e, 0)

Line 1322: FROM gcs_entry_lines gel_1

1318: ) ytd_amount,
1319: SUM ( NVL (gel_1.ptd_credit_balance_e, 0)
1320: - NVL (gel_1.ptd_debit_balance_e, 0)
1321: ) ptd_amount
1322: FROM gcs_entry_lines gel_1
1323: WHERE gel_1.entry_id = :2
1324: GROUP BY gel_1.company_cost_center_org_id, '||secondary_dimension_column||'
1325: HAVING SUM ( NVL (gel_1.ytd_credit_balance_e, 0) - NVL (gel_1.ytd_debit_balance_e, 0) ) <>0 ) src
1326: ON ( gel.entry_id = :2

Line 1404: 'MERGE INTO gcs_entry_lines gel

1400:
1401: ELSIF secondary_dimension_column IS NOT NULL
1402: THEN
1403: l_merge_statement :=
1404: 'MERGE INTO gcs_entry_lines gel
1405: USING (
1406: SELECT :6 company_cost_center_org_id,
1407:
1408: SUM ( NVL (gel_1.ytd_credit_balance_e, 0)

Line 1412: FROM gcs_entry_lines gel_1

1408: SUM ( NVL (gel_1.ytd_credit_balance_e, 0)
1409: - NVL (gel_1.ytd_debit_balance_e, 0)) ytd_amount,
1410: SUM ( NVL (gel_1.ptd_credit_balance_e, 0)
1411: - NVL (gel_1.ptd_debit_balance_e, 0)) ptd_amount
1412: FROM gcs_entry_lines gel_1
1413: WHERE gel_1.entry_id = :2
1414: GROUP BY '||secondary_dimension_column||'
1415: HAVING SUM ( NVL (gel_1.ytd_credit_balance_e, 0) - NVL (gel_1.ytd_debit_balance_e, 0) ) <>0 ) src
1416: ON ( gel.entry_id = :2

Line 1495: 'MERGE INTO gcs_entry_lines gel

1491: fnd_global.login_id;
1492: ELSIF org_tracking_flag = 'Y'
1493: THEN
1494: l_merge_statement :=
1495: 'MERGE INTO gcs_entry_lines gel
1496: USING (SELECT gel_1.company_cost_center_org_id, SUM ( NVL (gel_1.ytd_credit_balance_e, 0)
1497: - NVL (gel_1.ytd_debit_balance_e, 0)
1498: ) ytd_amount,
1499: SUM ( NVL (gel_1.ptd_credit_balance_e, 0)

Line 1502: FROM gcs_entry_lines gel_1

1498: ) ytd_amount,
1499: SUM ( NVL (gel_1.ptd_credit_balance_e, 0)
1500: - NVL (gel_1.ptd_debit_balance_e, 0)
1501: ) ptd_amount
1502: FROM gcs_entry_lines gel_1
1503: WHERE gel_1.entry_id = :2
1504: GROUP BY company_cost_center_org_id
1505: HAVING SUM ( NVL (gel_1.ytd_credit_balance_e, 0) - NVL (gel_1.ytd_debit_balance_e, 0) ) <>0 ) src
1506: ON ( gel.entry_id = :2

Line 1583: 'MERGE INTO gcs_entry_lines gel

1579: fnd_global.login_id;
1580:
1581: ELSE
1582: l_merge_statement :=
1583: 'MERGE INTO gcs_entry_lines gel
1584: USING (SELECT :4 company_cost_center_org_id,
1585: SUM ( NVL (gel_1.ytd_credit_balance_e, 0)
1586: - NVL (gel_1.ytd_debit_balance_e, 0)
1587: ) ytd_amount,

Line 1591: FROM gcs_entry_lines gel_1

1587: ) ytd_amount,
1588: SUM ( NVL (gel_1.ptd_credit_balance_e, 0)
1589: - NVL (gel_1.ptd_debit_balance_e, 0)
1590: ) ptd_amount
1591: FROM gcs_entry_lines gel_1
1592: WHERE gel_1.entry_id = :2
1593: HAVING SUM ( NVL (gel_1.ytd_credit_balance_e, 0) - NVL (gel_1.ytd_debit_balance_e, 0) ) <>0 ) src
1594: ON ( gel.entry_id = :2
1595: AND gel.line_type_code = ''CALCULATED'' )

Line 1677: FROM gcs_entry_lines

1673: INTO l_threshold_passed_flag
1674: FROM dual
1675: WHERE EXISTS(
1676: SELECT 'X'
1677: FROM gcs_entry_lines
1678: WHERE entry_id = p_entry_id
1679: AND description = 'SUSPENSE_EXCEEDED');
1680:
1681: UPDATE gcs_entry_lines

Line 1681: UPDATE gcs_entry_lines

1677: FROM gcs_entry_lines
1678: WHERE entry_id = p_entry_id
1679: AND description = 'SUSPENSE_EXCEEDED');
1680:
1681: UPDATE gcs_entry_lines
1682: SET description = 'SUSPENSE_LINE'
1683: WHERE description = 'SUSPENSE_EXCEEDED'
1684: AND entry_id = p_entry_id;
1685: