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.RRS_HIERARCHY_CRUD_PKG dependencies on RRS_SITES_VL

Line 957: AND ((PARENT_ID, PARENT_NUMBER) NOT IN (SELECT SITE_ID, SITE_IDENTIFICATION_NUMBER FROM RRS_SITES_VL)

953: CURSOR validate_p_id_num_cursor IS
954: SELECT PARENT_ID, PARENT_NUMBER
955: FROM RRS_SITE_GROUP_MEMBERS_TEMP
956: WHERE (PARENT_ID IS NOT NULL AND PARENT_NUMBER IS NOT NULL)
957: AND ((PARENT_ID, PARENT_NUMBER) NOT IN (SELECT SITE_ID, SITE_IDENTIFICATION_NUMBER FROM RRS_SITES_VL)
958: AND (PARENT_ID, PARENT_NUMBER) NOT IN (SELECT SITE_GROUP_NODE_ID, NODE_IDENTIFICATION_NUMBER FROM RRS_SITE_GROUP_NODES_VL));
959:
960: CURSOR validate_c_id_num_cursor IS
961: SELECT CHILD_ID, CHILD_NUMBER

Line 964: AND ((CHILD_ID, CHILD_NUMBER) NOT IN (SELECT SITE_ID, SITE_IDENTIFICATION_NUMBER FROM RRS_SITES_VL)

960: CURSOR validate_c_id_num_cursor IS
961: SELECT CHILD_ID, CHILD_NUMBER
962: FROM RRS_SITE_GROUP_MEMBERS_TEMP
963: WHERE (CHILD_ID IS NOT NULL AND CHILD_NUMBER IS NOT NULL)
964: AND ((CHILD_ID, CHILD_NUMBER) NOT IN (SELECT SITE_ID, SITE_IDENTIFICATION_NUMBER FROM RRS_SITES_VL)
965: AND (CHILD_ID, CHILD_NUMBER) NOT IN (SELECT SITE_GROUP_NODE_ID, NODE_IDENTIFICATION_NUMBER FROM RRS_SITE_GROUP_NODES_VL));
966:
967: CURSOR validate_p_id_cursor IS
968: SELECT PARENT_TYPE, PARENT_ID, PARENT_NUMBER

Line 1011: FROM RRS_SITE_GROUP_MEMBERS_TEMP RSGMT, RRS_SITES_VL RSV

1007: OR PARENT_ID IS NULL;
1008:
1009: CURSOR validate_site_template_cursor IS
1010: SELECT CHILD_NUMBER
1011: FROM RRS_SITE_GROUP_MEMBERS_TEMP RSGMT, RRS_SITES_VL RSV
1012: WHERE RSGMT.CHILD_ID = RSV.SITE_ID
1013: AND RSGMT.CHILD_TYPE = 'SITE'
1014: AND IS_TEMPLATE_FLAG = 'Y';
1015:

Line 1320: FROM RRS_SITES_VL RSV, RRS_SITE_GROUP_NODES_VL RSGNV, RRS_SITE_GROUP_MEMBERS_TEMP RSGMT2

1316: --dbms_output.put_line('before case3 update parent id/num');
1317: UPDATE RRS_SITE_GROUP_MEMBERS_TEMP RSGMT
1318: SET PARENT_ID = (
1319: SELECT DECODE(PARENT_TYPE,'SITE', SITE_ID, SITE_GROUP_NODE_ID)
1320: FROM RRS_SITES_VL RSV, RRS_SITE_GROUP_NODES_VL RSGNV, RRS_SITE_GROUP_MEMBERS_TEMP RSGMT2
1321: WHERE RSGMT2.PARENT_NUMBER = RSV.SITE_IDENTIFICATION_NUMBER(+)
1322: AND RSGMT2.PARENT_NUMBER = RSGNV.NODE_IDENTIFICATION_NUMBER(+)
1323: AND RSGMT.ROWID = RSGMT2.ROWID)
1324: WHERE PARENT_ID IS NULL;

Line 1329: FROM RRS_SITES_VL RSV, RRS_SITE_GROUP_NODES_VL RSGNV, RRS_SITE_GROUP_MEMBERS_TEMP RSGMT2

1325: --set the parent_number
1326: UPDATE RRS_SITE_GROUP_MEMBERS_TEMP RSGMT
1327: SET PARENT_NUMBER = (
1328: SELECT DECODE(PARENT_TYPE,'SITE', SITE_IDENTIFICATION_NUMBER, NODE_IDENTIFICATION_NUMBER)
1329: FROM RRS_SITES_VL RSV, RRS_SITE_GROUP_NODES_VL RSGNV, RRS_SITE_GROUP_MEMBERS_TEMP RSGMT2
1330: WHERE RSGMT2.PARENT_ID = RSV.SITE_ID(+)
1331: AND RSGMT2.PARENT_ID = RSGNV.SITE_GROUP_NODE_ID(+)
1332: AND RSGMT.ROWID = RSGMT2.ROWID)
1333: WHERE PARENT_NUMBER IS NULL;

Line 1339: FROM RRS_SITES_VL RSV, RRS_SITE_GROUP_NODES_VL RSGNV, RRS_SITE_GROUP_MEMBERS_TEMP RSGMT2

1335: --dbms_output.put_line('before case3 update child id/num');
1336: UPDATE RRS_SITE_GROUP_MEMBERS_TEMP RSGMT
1337: SET CHILD_ID = (
1338: SELECT DECODE(CHILD_TYPE,'SITE', SITE_ID, SITE_GROUP_NODE_ID)
1339: FROM RRS_SITES_VL RSV, RRS_SITE_GROUP_NODES_VL RSGNV, RRS_SITE_GROUP_MEMBERS_TEMP RSGMT2
1340: WHERE RSGMT2.CHILD_NUMBER = RSV.SITE_IDENTIFICATION_NUMBER(+)
1341: AND RSGMT2.CHILD_NUMBER = RSGNV.NODE_IDENTIFICATION_NUMBER(+)
1342: AND RSGMT.ROWID = RSGMT2.ROWID)
1343: WHERE CHILD_ID IS NULL;

Line 1348: FROM RRS_SITES_VL RSV, RRS_SITE_GROUP_NODES_VL RSGNV, RRS_SITE_GROUP_MEMBERS_TEMP RSGMT2

1344: --set the child_number
1345: UPDATE RRS_SITE_GROUP_MEMBERS_TEMP RSGMT
1346: SET CHILD_NUMBER = (
1347: SELECT DECODE(CHILD_TYPE,'SITE', SITE_IDENTIFICATION_NUMBER, NODE_IDENTIFICATION_NUMBER)
1348: FROM RRS_SITES_VL RSV, RRS_SITE_GROUP_NODES_VL RSGNV, RRS_SITE_GROUP_MEMBERS_TEMP RSGMT2
1349: WHERE RSGMT2.CHILD_ID = RSV.SITE_ID(+)
1350: AND RSGMT2.CHILD_ID = RSGNV.SITE_GROUP_NODE_ID(+)
1351: AND RSGMT.ROWID = RSGMT2.ROWID)
1352: WHERE CHILD_NUMBER IS NULL;

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 1768: RRS_SITES_VL RSV2,

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(+)
1771: AND RSGM.PARENT_MEMBER_ID = RSU.SITE_ID(+)
1772: AND NVL(RSU.IS_PRIMARY_FLAG, 'Y') = 'Y'

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 2385: RRS_SITES_VL RSV2,

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(+)
2388: AND RSGM.PARENT_MEMBER_ID = RSU.SITE_ID(+)
2389: AND NVL(RSU.IS_PRIMARY_FLAG, 'Y') = 'Y'

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