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_ENTITY_CONS_ATTRS

Line 97: gcs_entity_cons_attrs geca_child,

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
100: AND gcr.parent_entity_id = p_entity_id
101: AND geca_child.hierarchy_id = p_hierarchy_id

Line 98: gcs_entity_cons_attrs geca_parent

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
100: AND gcr.parent_entity_id = p_entity_id
101: AND geca_child.hierarchy_id = p_hierarchy_id
102: AND geca_child.entity_id = gcr.child_entity_id

Line 120: gcs_entity_cons_attrs geca_child,

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
124: AND gcr.parent_entity_id = p_entity_id

Line 121: gcs_entity_cons_attrs geca_parent,

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
124: AND gcr.parent_entity_id = p_entity_id
125: AND geca_child.hierarchy_id = p_hierarchy_id

Line 251: gcs_entity_cons_attrs geca_parent,

247: DECODE(geca_parent.currency_code, geca_child.currency_code, 'N', 'Y') translation_required
248: FROM gcs_cons_eng_run_dtls gcerd,
249: fem_entities_attr fea,
250: fem_entities_vl fev,
251: gcs_entity_cons_attrs geca_parent,
252: gcs_entity_cons_attrs geca_child,
253: gcs_cons_eng_runs gcer
254: WHERE gcerd.run_name = p_run_name
255: AND gcerd.consolidation_entity_id = p_cons_entity_id

Line 252: gcs_entity_cons_attrs geca_child,

248: FROM gcs_cons_eng_run_dtls gcerd,
249: fem_entities_attr fea,
250: fem_entities_vl fev,
251: gcs_entity_cons_attrs geca_parent,
252: gcs_entity_cons_attrs geca_child,
253: gcs_cons_eng_runs gcer
254: WHERE gcerd.run_name = p_run_name
255: AND gcerd.consolidation_entity_id = p_cons_entity_id
256: AND gcerd.entry_id IS NULL

Line 929: gcs_entity_cons_attrs geca_parent,

925: DECODE(geca_parent.currency_code, geca_child.currency_code, 'N', 'Y') translation_required
926: FROM gcs_cons_eng_run_dtls gcerd,
927: fem_entities_attr fea,
928: fem_entities_vl fev,
929: gcs_entity_cons_attrs geca_parent,
930: gcs_entity_cons_attrs geca_child,
931: gcs_cons_eng_runs gcer
932: WHERE gcerd.run_name = p_run_name
933: AND gcerd.consolidation_entity_id = p_cons_entity_id

Line 930: gcs_entity_cons_attrs geca_child,

926: FROM gcs_cons_eng_run_dtls gcerd,
927: fem_entities_attr fea,
928: fem_entities_vl fev,
929: gcs_entity_cons_attrs geca_parent,
930: gcs_entity_cons_attrs geca_child,
931: gcs_cons_eng_runs gcer
932: WHERE gcerd.run_name = p_run_name
933: AND gcerd.consolidation_entity_id = p_cons_entity_id
934: AND gcerd.entry_id IS NULL