APPS.RRS_HIERARCHY_CRUD_PKG dependencies on RRS_SITE_USES

Line 1482: FROM RRS_SITE_GROUP_MEMBERS_TEMP RSGMT2, RRS_SITE_USES RSU, RRS_SITE_GROUP_NODES_VL RSGNV

1478: --dbms_output.put_line('before defaulting parent purpose code');
1479: UPDATE RRS_SITE_GROUP_MEMBERS_TEMP RSGMT
1480: SET PARENT_PURPOSE_CODE = (
1481: SELECT NVL(RSU.SITE_USE_TYPE_CODE, RSGNV.NODE_PURPOSE_CODE)
1482: FROM RRS_SITE_GROUP_MEMBERS_TEMP RSGMT2, RRS_SITE_USES RSU, RRS_SITE_GROUP_NODES_VL RSGNV
1483: WHERE RSGMT2.PARENT_ID = RSU.SITE_ID(+)
1484: AND RSU.IS_PRIMARY_FLAG(+) = 'Y'
1485: AND RSGMT2.PARENT_ID = RSGNV.SITE_GROUP_NODE_ID(+)
1486: AND RSGMT.ROWID = RSGMT2.ROWID);

Line 1493: FROM RRS_SITE_GROUP_MEMBERS_TEMP RSGMT2, RRS_SITE_USES RSU, RRS_SITE_GROUP_NODES_VL RSGNV

1489: --dbms_output.put_line('before defaulting child purpose code');
1490: UPDATE RRS_SITE_GROUP_MEMBERS_TEMP RSGMT
1491: SET CHILD_PURPOSE_CODE = (
1492: SELECT NVL(RSU.SITE_USE_TYPE_CODE, RSGNV.NODE_PURPOSE_CODE)
1493: FROM RRS_SITE_GROUP_MEMBERS_TEMP RSGMT2, RRS_SITE_USES RSU, RRS_SITE_GROUP_NODES_VL RSGNV
1494: WHERE RSGMT2.CHILD_ID = RSU.SITE_ID(+)
1495: AND RSU.IS_PRIMARY_FLAG(+) = 'Y'
1496: AND RSGMT2.CHILD_ID = RSGNV.SITE_GROUP_NODE_ID(+)
1497: AND RSU.IS_PRIMARY_FLAG(+) = 'Y'

Line 1766: RRS_SITES_VL RSV, RRS_SITE_USES RSU,

1762: DECODE(RSV2.SITE_ID, NULL, RSGNV2.NODE_PURPOSE_CODE, RSU2.SITE_USE_TYPE_CODE) AS C_PURPOSE_CODE,
1763: RSGM.SEQUENCE_NUMBER AS C_SEQ_NUMBER
1764: FROM RRS_SITE_GROUP_MEMBERS RSGM,
1765: RRS_SITE_GROUP_NODES_VL RSGNV,
1766: RRS_SITES_VL RSV, RRS_SITE_USES RSU,
1767: RRS_SITE_GROUP_NODES_VL RSGNV2,
1768: RRS_SITES_VL RSV2,
1769: RRS_SITE_USES RSU2
1770: WHERE RSGM.PARENT_MEMBER_ID = RSV.SITE_ID(+)

Line 1769: RRS_SITE_USES RSU2

1765: RRS_SITE_GROUP_NODES_VL RSGNV,
1766: RRS_SITES_VL RSV, RRS_SITE_USES RSU,
1767: RRS_SITE_GROUP_NODES_VL RSGNV2,
1768: RRS_SITES_VL RSV2,
1769: RRS_SITE_USES RSU2
1770: WHERE RSGM.PARENT_MEMBER_ID = RSV.SITE_ID(+)
1771: AND RSGM.PARENT_MEMBER_ID = RSU.SITE_ID(+)
1772: AND NVL(RSU.IS_PRIMARY_FLAG, 'Y') = 'Y'
1773: AND RSGM.PARENT_MEMBER_ID = RSGNV.SITE_GROUP_NODE_ID(+)

Line 1878: FROM RRS_SITES_VL RSV, RRS_SITE_USES RSU

1874: ELSIF p_hier_members_rec.child_object_type = 'SITE' THEN
1875: BEGIN
1876: SELECT RSV.SITE_ID, RSU.SITE_USE_TYPE_CODE, RSV.IS_TEMPLATE_FLAG
1877: INTO v_child_id, v_child_purpose_code, v_flag
1878: FROM RRS_SITES_VL RSV, RRS_SITE_USES RSU
1879: WHERE RSV.SITE_IDENTIFICATION_NUMBER = p_hier_members_rec.child_id_number
1880: AND RSV.SITE_ID = RSU.SITE_ID(+)
1881: AND RSU.IS_PRIMARY_FLAG(+) = 'Y';
1882: EXCEPTION

Line 1948: FROM RRS_SITES_VL RSV, RRS_SITE_USES RSU, RRS_SITE_GROUP_MEMBERS RSGM

1944: ELSIF p_hier_members_rec.dest_parent_object_type = 'SITE' THEN
1945: BEGIN
1946: SELECT RSV.SITE_ID, RSU.SITE_USE_TYPE_CODE
1947: INTO v_dest_parent_id, v_dest_parent_purpose_code
1948: FROM RRS_SITES_VL RSV, RRS_SITE_USES RSU, RRS_SITE_GROUP_MEMBERS RSGM
1949: WHERE RSV.SITE_IDENTIFICATION_NUMBER = p_hier_members_rec.dest_parent_id_number
1950: AND RSV.SITE_ID = RSU.SITE_ID(+)
1951: AND RSU.IS_PRIMARY_FLAG(+) = 'Y'
1952: AND RSV.SITE_ID = RSGM.CHILD_MEMBER_ID

Line 2383: RRS_SITES_VL RSV, RRS_SITE_USES RSU,

2379: DECODE(RSV2.SITE_ID, NULL, RSGNV2.NODE_PURPOSE_CODE, RSU2.SITE_USE_TYPE_CODE) AS C_PURPOSE_CODE,
2380: RSGM.SEQUENCE_NUMBER AS C_SEQ_NUMBER
2381: FROM RRS_SITE_GROUP_MEMBERS RSGM,
2382: RRS_SITE_GROUP_NODES_VL RSGNV,
2383: RRS_SITES_VL RSV, RRS_SITE_USES RSU,
2384: RRS_SITE_GROUP_NODES_VL RSGNV2,
2385: RRS_SITES_VL RSV2,
2386: RRS_SITE_USES RSU2
2387: WHERE RSGM.PARENT_MEMBER_ID = RSV.SITE_ID(+)

Line 2386: RRS_SITE_USES RSU2

2382: RRS_SITE_GROUP_NODES_VL RSGNV,
2383: RRS_SITES_VL RSV, RRS_SITE_USES RSU,
2384: RRS_SITE_GROUP_NODES_VL RSGNV2,
2385: RRS_SITES_VL RSV2,
2386: RRS_SITE_USES RSU2
2387: WHERE RSGM.PARENT_MEMBER_ID = RSV.SITE_ID(+)
2388: AND RSGM.PARENT_MEMBER_ID = RSU.SITE_ID(+)
2389: AND NVL(RSU.IS_PRIMARY_FLAG, 'Y') = 'Y'
2390: AND RSGM.PARENT_MEMBER_ID = RSGNV.SITE_GROUP_NODE_ID(+)

Line 2529: FROM RRS_SITES_VL RSV, RRS_SITE_USES RSU

2525: IF p_parent_object_type = 'SITE' THEN
2526: BEGIN
2527: SELECT RSV.SITE_IDENTIFICATION_NUMBER, RSU.SITE_USE_TYPE_CODE
2528: INTO v_parent_id_number, v_parent_purpose_code
2529: FROM RRS_SITES_VL RSV, RRS_SITE_USES RSU
2530: WHERE RSV.SITE_ID = p_parent_id
2531: AND RSV.SITE_ID = RSU.SITE_ID(+)
2532: AND RSU.IS_PRIMARY_FLAG(+) = 'Y';
2533: EXCEPTION

Line 2567: FROM RRS_SITES_VL RSV, RRS_SITE_USES RSU

2563: IF p_child_object_type = 'SITE' THEN
2564: BEGIN
2565: SELECT RSV.SITE_IDENTIFICATION_NUMBER, RSU.SITE_USE_TYPE_CODE
2566: INTO v_child_id_number, v_child_purpose_code
2567: FROM RRS_SITES_VL RSV, RRS_SITE_USES RSU
2568: WHERE RSV.SITE_ID = p_child_id
2569: AND RSV.SITE_ID = RSU.SITE_ID(+)
2570: AND RSU.IS_PRIMARY_FLAG(+) = 'Y';
2571: EXCEPTION