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.

APPS.GCS_TEMPLATES_PKG dependencies on GCS_DIMENSION_TEMPLATES

Line 87: FROM gcs_dimension_templates dt,

83:
84: -- Used to obtain sign information
85: CURSOR sign_c IS
86: SELECT fxata.number_assign_value
87: FROM gcs_dimension_templates dt,
88: fem_ln_items_attr flia,
89: fem_ext_acct_types_attr fxata
90: WHERE dt.hierarchy_id = p_hierarchy_id
91: AND dt.template_code = ''RE''

Line 201: ''FROM gcs_dimension_templates dt, '' || g_nl ||

197: THEN
198: fnd_log.STRING (fnd_log.level_statement,
199: g_pkg_name || ''.'' || l_api_name,
200: ''SELECT fxata.number_assign_value'' || g_nl ||
201: ''FROM gcs_dimension_templates dt, '' || g_nl ||
202: '' fem_ln_items_attr flia,'' || g_nl ||
203: '' fem_ext_acct_types_attr fxata'' || g_nl ||
204: ''WHERE dt.hierarchy_id = '' || p_hierarchy_id || g_nl ||
205: ''AND dt.template_code = ''''RE'''''' || g_nl ||

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

336: ||'
337: SUM ( NVL (gel_1.ytd_credit_balance_e, 0)
338: - NVL (gel_1.ytd_debit_balance_e, 0)
339: ) amount
340: FROM gcs_dimension_templates gdt, gcs_entry_lines gel_1, fem_ln_items_attr flia,
341: fem_ext_acct_types_attr feata
342: WHERE gdt.hierarchy_id = :1
343: AND gdt.template_code = ''''RE''''
344: AND gel_1.entry_id = :2

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

423: ' ||l_decode_text
424: ||'
425: SUM ( NVL (gel_1.ytd_credit_balance_e, 0)
426: - NVL (gel_1.ytd_debit_balance_e, 0)) amount
427: FROM gcs_dimension_templates gdt, gcs_entry_lines gel_1, fem_ln_items_attr flia,
428: fem_ext_acct_types_attr feata
429: WHERE gdt.hierarchy_id = :1
430: AND gdt.template_code = ''''RE''''
431: AND gel_1.entry_id = :2

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

509: USING (SELECT gel_1.company_cost_center_org_id, '||l_gdt_dims_text||'
510: SUM ( NVL (gel_1.ytd_credit_balance_e, 0)
511: - NVL (gel_1.ytd_debit_balance_e, 0)
512: ) amount
513: FROM gcs_dimension_templates gdt, gcs_entry_lines gel_1, fem_ln_items_attr flia,
514: fem_ext_acct_types_attr feata
515: WHERE gdt.hierarchy_id = :1
516: AND gdt.template_code = ''''RE''''
517: AND gel_1.entry_id = :2

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

588: USING (SELECT :6 company_cost_center_org_id, '||l_gdt_dims_text||'
589: SUM ( NVL (gel_1.ytd_credit_balance_e, 0)
590: - NVL (gel_1.ytd_debit_balance_e, 0)
591: ) amount
592: FROM gcs_dimension_templates gdt, gcs_entry_lines gel_1, fem_ln_items_attr flia,
593: fem_ext_acct_types_attr feata
594: WHERE gdt.hierarchy_id = :1
595: AND gdt.template_code = ''''RE''''
596: AND gel_1.entry_id = :2

Line 733: FROM gcs_dimension_templates dt,

729:
730: -- Used to obtain sign information
731: CURSOR sign_c IS
732: SELECT fxata.number_assign_value
733: FROM gcs_dimension_templates dt,
734: fem_ln_items_attr flia,
735: fem_ext_acct_types_attr fxata
736: WHERE dt.hierarchy_id = p_hierarchy_id
737: AND dt.template_code = ''RE''

Line 815: ''FROM gcs_dimension_templates dt'' || g_nl ||

811: THEN
812: fnd_log.STRING (fnd_log.level_statement,
813: g_pkg_name || ''.'' || l_api_name,
814: ''SELECT fxata.number_assign_value'' || g_nl ||
815: ''FROM gcs_dimension_templates dt'' || g_nl ||
816: '' fem_ln_items_attr flia,'' || g_nl ||
817: '' fem_ext_acct_types_attr fxata'' || g_nl ||
818: ''WHERE dt.hierarchy_id = '' || p_hierarchy_id || g_nl ||
819: ''AND dt.template_code = ''''RE'''''' || g_nl ||

Line 883: FROM gcs_dimension_templates gdt, fem_balances fb, fem_ln_items_attr flia,

879: ||'
880: SUM ( NVL (fb.ytd_credit_balance_e, 0)
881: - NVL (fb.ytd_debit_balance_e, 0)
882: ) amount
883: FROM gcs_dimension_templates gdt, fem_balances fb, fem_ln_items_attr flia,
884: fem_ext_acct_types_attr feata, FEM_SOURCE_SYSTEMS_B fssb
885: WHERE gdt.hierarchy_id = :1
886: AND gdt.template_code = ''''RE''''
887: AND fb.cal_period_id = :2

Line 975: FROM gcs_dimension_templates gdt, fem_balances fb, fem_ln_items_attr flia,

971: ||'
972: SUM ( NVL (fb.ytd_credit_balance_e, 0)
973: - NVL (fb.ytd_debit_balance_e, 0)
974: ) amount
975: FROM gcs_dimension_templates gdt, fem_balances fb, fem_ln_items_attr flia,
976: fem_ext_acct_types_attr feata, FEM_SOURCE_SYSTEMS_B fssb
977: WHERE gdt.hierarchy_id = :1
978: AND gdt.template_code = ''''RE''''
979: AND fb.cal_period_id = :2

Line 1065: FROM gcs_dimension_templates gdt, fem_balances fb, fem_ln_items_attr flia,

1061: USING (SELECT fb.company_cost_center_org_id, '||l_gdt_dims_text||'
1062: SUM ( NVL (fb.ytd_credit_balance_e, 0)
1063: - NVL (fb.ytd_debit_balance_e, 0)
1064: ) amount
1065: FROM gcs_dimension_templates gdt, fem_balances fb, fem_ln_items_attr flia,
1066: fem_ext_acct_types_attr feata, FEM_SOURCE_SYSTEMS_B fssb
1067: WHERE gdt.hierarchy_id = :1
1068: AND gdt.template_code = ''''RE''''
1069: AND fb.cal_period_id = :2

Line 1148: FROM gcs_dimension_templates gdt, fem_balances fb, fem_ln_items_attr flia,

1144: USING (SELECT :6 company_cost_center_org_id, '||l_gdt_dims_text||'
1145: SUM ( NVL (fb.ytd_credit_balance_e, 0)
1146: - NVL (fb.ytd_debit_balance_e, 0)
1147: ) amount
1148: FROM gcs_dimension_templates gdt, fem_balances fb, fem_ln_items_attr flia,
1149: fem_ext_acct_types_attr feata, FEM_SOURCE_SYSTEMS_B fssb
1150: WHERE gdt.hierarchy_id = :1
1151: AND gdt.template_code = ''''RE''''
1152: AND fb.cal_period_id = :2

Line 2061: FROM gcs_dimension_templates

2057: channel_id, line_item_id, project_id, customer_id, task_id,
2058: user_dim1_id, user_dim2_id, user_dim3_id, user_dim4_id,
2059: user_dim5_id, user_dim6_id, user_dim7_id, user_dim8_id,
2060: user_dim9_id, user_dim10_id
2061: FROM gcs_dimension_templates
2062: WHERE hierarchy_id = p_hierarchy_id
2063: AND template_code = p_template_code;
2064: BEGIN
2065: fn_name := 'GET_DIMENSION_TEMPLATE';