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_DYNAMIC_PKG dependencies on GCS_DIMENSION_TEMPLATES

Line 44: FROM gcs_dimension_templates dt,

40:
41: -- Used to obtain sign information
42: CURSOR sign_c IS
43: SELECT fxata.number_assign_value
44: FROM gcs_dimension_templates dt,
45: fem_ln_items_attr flia,
46: fem_ext_acct_types_attr fxata
47: WHERE dt.hierarchy_id = p_hierarchy_id
48: AND dt.template_code = 'RE'

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

154: THEN
155: fnd_log.STRING (fnd_log.level_statement,
156: g_pkg_name || '.' || l_api_name,
157: 'SELECT fxata.number_assign_value' || g_nl ||
158: 'FROM gcs_dimension_templates dt, ' || g_nl ||
159: ' fem_ln_items_attr flia,' || g_nl ||
160: ' fem_ext_acct_types_attr fxata' || g_nl ||
161: 'WHERE dt.hierarchy_id = ' || p_hierarchy_id || g_nl ||
162: 'AND dt.template_code = ''RE''' || g_nl ||

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 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 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 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 576: FROM gcs_dimension_templates dt,

572:
573: -- Used to obtain sign information
574: CURSOR sign_c IS
575: SELECT fxata.number_assign_value
576: FROM gcs_dimension_templates dt,
577: fem_ln_items_attr flia,
578: fem_ext_acct_types_attr fxata
579: WHERE dt.hierarchy_id = p_hierarchy_id
580: AND dt.template_code = 'RE'

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

654: THEN
655: fnd_log.STRING (fnd_log.level_statement,
656: g_pkg_name || '.' || l_api_name,
657: 'SELECT fxata.number_assign_value' || g_nl ||
658: 'FROM gcs_dimension_templates dt' || g_nl ||
659: ' fem_ln_items_attr flia,' || g_nl ||
660: ' fem_ext_acct_types_attr fxata' || g_nl ||
661: 'WHERE dt.hierarchy_id = ' || p_hierarchy_id || g_nl ||
662: 'AND dt.template_code = ''RE''' || g_nl ||

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

708:
709: SUM ( NVL (fb.ytd_credit_balance_e, 0)
710: - NVL (fb.ytd_debit_balance_e, 0)
711: ) amount
712: FROM gcs_dimension_templates gdt, fem_balances fb, fem_ln_items_attr flia,
713: fem_ext_acct_types_attr feata, FEM_SOURCE_SYSTEMS_B fssb
714: WHERE gdt.hierarchy_id = :1
715: AND gdt.template_code = ''RE''
716: AND fb.cal_period_id = :2

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

793:
794: SUM ( NVL (fb.ytd_credit_balance_e, 0)
795: - NVL (fb.ytd_debit_balance_e, 0)
796: ) amount
797: FROM gcs_dimension_templates gdt, fem_balances fb, fem_ln_items_attr flia,
798: fem_ext_acct_types_attr feata, FEM_SOURCE_SYSTEMS_B fssb
799: WHERE gdt.hierarchy_id = :1
800: AND gdt.template_code = ''RE''
801: AND fb.cal_period_id = :2

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

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
881: FROM gcs_dimension_templates gdt, fem_balances fb, fem_ln_items_attr flia,
882: fem_ext_acct_types_attr feata, FEM_SOURCE_SYSTEMS_B fssb
883: WHERE gdt.hierarchy_id = :1
884: AND gdt.template_code = ''RE''
885: AND fb.cal_period_id = :2

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

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
962: FROM gcs_dimension_templates gdt, fem_balances fb, fem_ln_items_attr flia,
963: fem_ext_acct_types_attr feata, FEM_SOURCE_SYSTEMS_B fssb
964: WHERE gdt.hierarchy_id = :1
965: AND gdt.template_code = ''RE''
966: AND fb.cal_period_id = :2