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.AHL_MC_PATH_POSITION_PVT dependencies on AHL_MC_PATH_POSITION_NODES

Line 90: AHL_MC_PATH_POSITION_NODES where path_position_id = pos.path_position_id);

86: SELECT pos.path_pos_common_id
87: FROM AHL_MC_PATH_POSITIONS pos
88: WHERE pos.encoded_path_position like p_encoded_path
89: AND p_size = (select COUNT(path_position_node_id) from
90: AHL_MC_PATH_POSITION_NODES where path_position_id = pos.path_position_id);
91: --
92: CURSOR get_next_path_pos_id_csr IS
93: SELECT ahl_mc_path_positions_s.nextval
94: FROM dual;

Line 325: INSERT INTO ahl_mc_path_position_nodes(

321: RETURNING path_position_id INTO x_position_id;
322:
323: --Insert the path position nodes
324: FOR i IN p_path_position_tbl.FIRST..p_path_position_tbl.LAST LOOP
325: INSERT INTO ahl_mc_path_position_nodes(
326: PATH_POSITION_NODE_ID,
327: OBJECT_VERSION_NUMBER,
328: LAST_UPDATE_DATE,
329: LAST_UPDATED_BY,

Line 354: ahl_mc_path_position_nodes_s.nextval,

350: ATTRIBUTE12, ATTRIBUTE13,
351: ATTRIBUTE14,
352: ATTRIBUTE15
353: ) VALUES (
354: ahl_mc_path_position_nodes_s.nextval,
355: 1,
356: sysdate,
357: fnd_global.user_id,
358: sysdate,

Line 507: AHL_MC_PATH_POSITION_NODES where path_position_id = pos.path_position_id);

503: -- does the wild card comparison correctly
504: WHERE pos.encoded_path_position LIKE SUBSTR (p_encoded_path, 1, INSTR (p_encoded_path, ':')) || '%'
505: AND p_encoded_path LIKE pos.encoded_path_position
506: AND p_size = (select COUNT(path_position_node_id) from
507: AHL_MC_PATH_POSITION_NODES where path_position_id = pos.path_position_id);
508: --
509:
510: --modification by jrotich on 10/02/2012 for fixing bug 13472472 BEGIN
511: --returns details of the current instance if it is itself an mc within another MC

Line 723: FROM AHL_MC_PATH_POSITION_NODES path

719: --
720: --Fetch all the position path information for given position_id
721: CURSOR get_position_path_csr (p_position_id IN NUMBER) IS
722: SELECT path.sequence, path.mc_id, path.version_number, path.position_key
723: FROM AHL_MC_PATH_POSITION_NODES path
724: WHERE path.path_position_id = p_position_id
725: order by sequence;
726: --
727: --Determine if position_key maps to top node of the configuration

Line 1013: FROM AHL_MC_PATH_POSITION_NODES path

1009: --Step 1) Build the path Position table object
1010: --Fetch all the position path information for given position_id
1011: CURSOR get_position_path_csr (p_position_id IN NUMBER) IS
1012: SELECT path.sequence, path.mc_id, path.version_number, path.position_key
1013: FROM AHL_MC_PATH_POSITION_NODES path
1014: WHERE path.path_position_id = p_position_id
1015: order by sequence;
1016:
1017: --

Line 1446: FROM ahl_mc_path_position_nodes pnodes, ahl_mc_headers_b hdr

1442: WHERE mc_header_id = p_mc_header_id;
1443: --
1444: CURSOR get_ver_position_ids_csr (p_header_id IN NUMBER) IS
1445: SELECT pnodes.path_position_id
1446: FROM ahl_mc_path_position_nodes pnodes, ahl_mc_headers_b hdr
1447: WHERE pnodes.sequence = 0
1448: AND pnodes.mc_id = hdr.mc_id
1449: AND pnodes.version_number = hdr.version_number
1450: AND hdr.mc_header_id = p_header_id;

Line 1454: FROM ahl_mc_path_position_nodes pnodes, ahl_mc_headers_b hdr

1450: AND hdr.mc_header_id = p_header_id;
1451: --
1452: CURSOR get_nover_position_ids_csr(p_header_id IN NUMBER) IS
1453: SELECT pnodes.path_position_id
1454: FROM ahl_mc_path_position_nodes pnodes, ahl_mc_headers_b hdr
1455: WHERE pnodes.sequence = 0
1456: AND pnodes.mc_id = hdr.mc_id
1457: AND pnodes.version_number IS NULL
1458: AND hdr.mc_header_id = p_header_id;

Line 1641: FROM ahl_mc_path_position_nodes

1637: WHERE mc_header_id = p_mc_header_id;
1638: --
1639: CURSOR get_mc_path_position_nodes_csr (p_position_id IN NUMBER) IS
1640: SELECT *
1641: FROM ahl_mc_path_position_nodes
1642: WHERE path_position_id = p_position_id
1643: order by sequence;
1644: --
1645: CURSOR get_path_position_ref_csr (p_position_id IN NUMBER) IS

Line 1856: FROM AHL_MC_PATH_POSITION_NODES path, AHL_MC_HEADERS_B headers

1852: --
1853: --Fetch all version specific path positions
1854: CURSOR get_ver_position_ids_csr (p_mc_header_id IN NUMBER) IS
1855: SELECT path.path_position_id
1856: FROM AHL_MC_PATH_POSITION_NODES path, AHL_MC_HEADERS_B headers
1857: WHERE path.MC_ID = headers.mc_id
1858: AND path.sequence = 0
1859: AND path.version_number = headers.version_number
1860: AND headers.mc_header_id = p_mc_header_id;

Line 1865: FROM AHL_MC_PATH_POSITION_NODES path, AHL_MC_HEADERS_B headers

1861: --
1862: --Fetch all non-version specific path positions
1863: CURSOR get_nover_position_ids_csr (p_mc_header_id IN NUMBER) IS
1864: SELECT path.path_position_id
1865: FROM AHL_MC_PATH_POSITION_NODES path, AHL_MC_HEADERS_B headers
1866: WHERE path.MC_ID = headers.mc_id
1867: AND path.sequence = 0
1868: AND path.version_number IS NULL
1869: AND headers.mc_header_id = p_mc_header_id;

Line 1941: DELETE FROM AHL_MC_PATH_POSITION_NODES

1937: FETCH check_posid_in_rstmts_csr INTO l_junk;
1938: IF (check_posid_in_rstmts_csr%NOTFOUND) THEN
1939:
1940: --Delete the position_id
1941: DELETE FROM AHL_MC_PATH_POSITION_NODES
1942: WHERE path_position_id = l_position_id;
1943:
1944: DELETE FROM AHL_MC_PATH_POSITIONS
1945: WHERE path_position_id = l_position_id;

Line 1971: DELETE FROM AHL_MC_PATH_POSITION_NODES

1967: FETCH check_posid_in_rstmts_csr INTO l_junk;
1968: IF (check_posid_in_rstmts_csr%NOTFOUND) THEN
1969:
1970: --Delete the position_id
1971: DELETE FROM AHL_MC_PATH_POSITION_NODES
1972: WHERE path_position_id = l_position_id;
1973:
1974: DELETE FROM AHL_MC_PATH_POSITIONS
1975: WHERE path_position_id = l_position_id;

Line 2047: AHL_MC_PATH_POSITION_NODES pnodes

2043: --Select the default position reference.
2044: CURSOR get_def_pos_ref_csr (p_position_id IN NUMBER) IS
2045: SELECT rel.position_ref_code
2046: FROM AHL_MC_HEADERS_B hd, AHL_MC_RELATIONSHIPS rel,
2047: AHL_MC_PATH_POSITION_NODES pnodes
2048: WHERE hd.mc_header_id = rel.mc_header_id
2049: AND rel.position_key = pnodes.position_key
2050: AND hd.mc_id = pnodes.mc_id
2051: AND pnodes.sequence = (SELECT MAX(sequence) FROM AHL_MC_PATH_POSITION_NODES

Line 2051: AND pnodes.sequence = (SELECT MAX(sequence) FROM AHL_MC_PATH_POSITION_NODES

2047: AHL_MC_PATH_POSITION_NODES pnodes
2048: WHERE hd.mc_header_id = rel.mc_header_id
2049: AND rel.position_key = pnodes.position_key
2050: AND hd.mc_id = pnodes.mc_id
2051: AND pnodes.sequence = (SELECT MAX(sequence) FROM AHL_MC_PATH_POSITION_NODES
2052: WHERE path_position_id = p_position_id)
2053: AND pnodes.path_position_id = p_position_id
2054: order by hd.version_number desc;
2055: --

Line 2778: -- for a given path position id, get the mc id and version no from ahl_mc_path_position_nodes

2774: p_relationship_id IN NUMBER,
2775: p_path_position_id IN NUMBER
2776: ) RETURN VARCHAR2 IS
2777: --
2778: -- for a given path position id, get the mc id and version no from ahl_mc_path_position_nodes
2779: -- from the mc id and version no, get the mc header id from ahl_mc_headers_b
2780: -- from the mc header id and position key (from ahl_mc_path_position_nodes), get the relationship id from ahl_mc_relationships
2781: CURSOR get_rel_id_csr (p_path_position_id NUMBER) IS
2782: SELECT mcr.relationship_id

Line 2780: -- from the mc header id and position key (from ahl_mc_path_position_nodes), get the relationship id from ahl_mc_relationships

2776: ) RETURN VARCHAR2 IS
2777: --
2778: -- for a given path position id, get the mc id and version no from ahl_mc_path_position_nodes
2779: -- from the mc id and version no, get the mc header id from ahl_mc_headers_b
2780: -- from the mc header id and position key (from ahl_mc_path_position_nodes), get the relationship id from ahl_mc_relationships
2781: CURSOR get_rel_id_csr (p_path_position_id NUMBER) IS
2782: SELECT mcr.relationship_id
2783: FROM ahl_mc_path_position_nodes mpn, ahl_mc_headers_b mch,
2784: ahl_mc_relationships mcr

Line 2783: FROM ahl_mc_path_position_nodes mpn, ahl_mc_headers_b mch,

2779: -- from the mc id and version no, get the mc header id from ahl_mc_headers_b
2780: -- from the mc header id and position key (from ahl_mc_path_position_nodes), get the relationship id from ahl_mc_relationships
2781: CURSOR get_rel_id_csr (p_path_position_id NUMBER) IS
2782: SELECT mcr.relationship_id
2783: FROM ahl_mc_path_position_nodes mpn, ahl_mc_headers_b mch,
2784: ahl_mc_relationships mcr
2785: WHERE mpn.path_position_id = p_path_position_id
2786: AND mpn.sequence = (
2787: SELECT MAX(sequence)

Line 2788: FROM ahl_mc_path_position_nodes

2784: ahl_mc_relationships mcr
2785: WHERE mpn.path_position_id = p_path_position_id
2786: AND mpn.sequence = (
2787: SELECT MAX(sequence)
2788: FROM ahl_mc_path_position_nodes
2789: WHERE path_position_id = mpn.path_position_id
2790: )
2791: AND mpn.mc_id = mch.mc_id
2792: AND mch.version_number = NVL(mpn.version_number, mch.version_number)