[Home] [Help]
475: delta_owned,
476: gcs_entry_headers_s.nextval,
477: geca.currency_code,
478: nvl(precision, 2) precision
479: FROM gcs_cons_relationships gcr,
480: fem_entities_attr fea,
481: gcs_entity_cons_attrs geca,
482: fnd_currencies fc
483: WHERE gcr.hierarchy_id = contextData.hierarchy
502: delta_owned,
503: gcs_entry_headers_s.nextval,
504: geca.currency_code,
505: nvl(precision, 2) precision
506: FROM gcs_cons_relationships gcr,
507: gcs_entity_cons_attrs geca,
508: fnd_currencies fc
509: WHERE gcr.hierarchy_id = contextData.hierarchy
510: AND gcr.child_entity_id = contextData.childEntity
521: delta_owned,
522: gcs_entry_headers_s.nextval,
523: geh.currency_code,
524: nvl(precision, 2) precision
525: FROM gcs_cons_relationships gcr,
526: gcs_entry_headers geh,
527: fnd_currencies fc
528: WHERE gcr.hierarchy_id = contextData.hierarchy
529: AND gcr.child_entity_id = contextData.childEntity
547:
548: -- get the ownership percent for the consolidating relationship
549: CURSOR c_get_ownership IS
550: SELECT ownership_percent
551: FROM gcs_cons_relationships
552: WHERE cons_relationship_id = contextData.relationship;
553:
554: CURSOR c_get_target IS
555: SELECT target_entity_code, net_to_re_flag
1312: whereClause := whereClause || '
1313: OR
1314: o.entity_id IN(
1315: SELECT r.child_entity_id
1316: FROM GCS_CONS_RELATIONSHIPS r
1317: START WITH r.parent_entity_id = :cid
1318: AND r.hierarchy_id = :hid
1319: AND r.actual_ownership_flag = ''Y''
1320: AND ( sysdate BETWEEN r.start_date
1942: WHERE ( o.entity_id = :cid
1943: OR
1944: o.entity_id IN(
1945: SELECT r.child_entity_id
1946: FROM GCS_CONS_RELATIONSHIPS r
1947: START WITH r.parent_entity_id = :cid
1948: AND r.hierarchy_id = :hid
1949: AND r.actual_ownership_flag = ''Y''
1950: AND ( sysdate BETWEEN r.start_date