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_CONS_ENGINE_PKG dependencies on GCS_CONS_RELATIONSHIPS

Line 95: FROM gcs_cons_relationships gcr,

91: gcr.cons_relationship_id,
92: geca_child.currency_code child_currency_code,
93: geca_parent.currency_code parent_currency_code,
94: fea.dim_attribute_varchar_member entity_type_code
95: FROM gcs_cons_relationships gcr,
96: fem_entities_attr fea,
97: gcs_entity_cons_attrs geca_child,
98: gcs_entity_cons_attrs geca_parent
99: WHERE gcr.hierarchy_id = p_hierarchy_id

Line 119: FROM gcs_cons_relationships gcr,

115: SELECT gcr.child_entity_id,
116: gcr.cons_relationship_id,
117: geca_child.currency_code child_currency_code,
118: geca_parent.currency_code parent_currency_code
119: FROM gcs_cons_relationships gcr,
120: gcs_entity_cons_attrs geca_child,
121: gcs_entity_cons_attrs geca_parent,
122: fem_entities_attr fea
123: WHERE gcr.hierarchy_id = p_hierarchy_id

Line 617: FROM gcs_cons_relationships

613:
614: BEGIN
615: SELECT cons_relationship_id
616: INTO l_cons_relationship_id
617: FROM gcs_cons_relationships
618: WHERE child_entity_id = cons_entity_wf_info.consolidation_entity
619: AND dominant_parent_flag = 'Y'
620: AND hierarchy_id = cons_entity_wf_info.consolidation_hierarchy
621: AND cons_entity_wf_info.cal_period_end_date BETWEEN start_date AND NVL(end_date, cons_entity_wf_info.cal_period_end_date)

Line 881: FROM gcs_cons_relationships gcr,

877: fnd_global.login_id,
878: 1,
879: --Bugfix 5091093: Added consolidation type code
880: gtb.consolidation_type_code
881: FROM gcs_cons_relationships gcr,
882: gcs_treatments_b gtb
883: WHERE gtb.treatment_id(+) = gcr.treatment_id
884: START WITH gcr.parent_entity_id = cons_entity_id
885: AND gcr.hierarchy_id = cons_entity_wf_info.consolidation_hierarchy

Line 1184: FROM gcs_cons_relationships gcr

1180: AND gcer.hierarchy_id = cons_entity_wf_info.consolidation_hierarchy
1181: AND gcer.cal_period_id = cons_entity_wf_info.cal_period_id
1182: AND gcer.balance_type_code = cons_entity_wf_info.balance_type_code
1183: AND EXISTS ( SELECT 'X'
1184: FROM gcs_cons_relationships gcr
1185: WHERE gcr.child_entity_id = gcer.run_entity_id
1186: START WITH gcr.parent_entity_id = cons_entity_wf_info.consolidation_entity
1187: AND gcr.hierarchy_id = cons_entity_wf_info.consolidation_hierarchy
1188: AND cons_entity_wf_info.cal_period_end_date