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_HEADERS_B

Line 45: FROM ahl_mc_headers_b hd, ahl_mc_relationships rel

41: CURSOR check_mc_ids_csr (p_mc_id IN NUMBER,
42: p_ver_num IN NUMBER,
43: p_pos_key IN NUMBER) IS
44: SELECT 'X'
45: FROM ahl_mc_headers_b hd, ahl_mc_relationships rel
46: WHERE hd.mc_header_id = rel.mc_header_id
47: AND hd.mc_id = p_mc_id
48: AND hd.version_number = nvl(p_ver_num, hd.version_number)
49: AND rel.position_key = p_pos_key;

Line 58: FROM ahl_mc_config_relations rel, ahl_mc_headers_b hd

54: p_pos_key IN NUMBER,
55: p_child_mc_id IN NUMBER,
56: p_child_ver_num IN NUMBER) IS
57: SELECT 'X'
58: FROM ahl_mc_config_relations rel, ahl_mc_headers_b hd
59: WHERE rel.mc_header_id = hd.mc_header_id
60: AND hd.mc_id = p_child_mc_id
61: AND hd.version_number = nvl(p_child_ver_num, hd.version_number)
62: AND rel.relationship_id IN

Line 64: FROM ahl_mc_relationships r, ahl_mc_headers_b h

60: AND hd.mc_id = p_child_mc_id
61: AND hd.version_number = nvl(p_child_ver_num, hd.version_number)
62: AND rel.relationship_id IN
63: (SELECT r.relationship_id
64: FROM ahl_mc_relationships r, ahl_mc_headers_b h
65: WHERE h.mc_header_id = r.mc_header_id
66: AND h.mc_id = p_mc_id
67: AND h.version_number = nvl(p_ver_num, h.version_number)
68: AND r.position_key = p_pos_key);

Line 78: FROM ahl_mc_relationships r1, ahl_mc_relationships r2, ahl_mc_headers_b hdr

74: WHERE pos.encoded_path_position = p_encoded_path;
75: --
76: CURSOR get_sibling_poskey_csr(p_mc_id IN NUMBER, p_poskey IN NUMBER) IS
77: SELECT distinct r2.position_key
78: FROM ahl_mc_relationships r1, ahl_mc_relationships r2, ahl_mc_headers_b hdr
79: WHERE r1.parent_relationship_id = r2.parent_relationship_id
80: AND r1.position_key <> r2.position_key
81: AND r1.position_key = p_poskey
82: AND r1.mc_header_id = hdr.mc_header_id

Line 474: FROM ahl_mc_headers_b hdr, ahl_mc_relationships rel,

470: --
471: --Fetches lowest level info
472: CURSOR get_last_uc_rec_csr (p_csi_instance_id IN NUMBER) IS
473: SELECT hdr.mc_id, hdr.version_number, rel.position_key
474: FROM ahl_mc_headers_b hdr, ahl_mc_relationships rel,
475: csi_ii_relationships csi_ii
476: WHERE csi_ii.subject_id = p_csi_instance_id
477: AND CSI_II.RELATIONSHIP_TYPE_CODE = 'COMPONENT-OF'
478: AND TRUNC(nvl(CSI_II.ACTIVE_START_DATE, sysdate)) <= TRUNC(sysdate)

Line 485: FROM ahl_mc_headers_b hdr, ahl_mc_relationships rel,

481: AND REL.mc_header_id = HDR.mc_header_id;
482: --
483: CURSOR get_top_unit_inst_csr (p_csi_instance_id IN NUMBER) IS
484: SELECT hdr.mc_id, hdr.version_number, rel.position_key
485: FROM ahl_mc_headers_b hdr, ahl_mc_relationships rel,
486: ahl_unit_config_headers uch, csi_unit_instances_v csi_u
487: WHERE uch.csi_item_instance_id = p_csi_instance_id
488: AND TRUNC(nvl(uch.ACTIVE_START_DATE, sysdate)) <= TRUNC(sysdate)
489: AND TRUNC(nvl(uch.ACTIVE_END_DATE, sysdate+1)) > TRUNC(sysdate)

Line 515: ahl_mc_headers_b amh,

511: --returns details of the current instance if it is itself an mc within another MC
512: CURSOR get_current_mc_rec_csr(c_instance_id IN NUMBER) IS
513: SELECT amh.mc_id, amh.version_number, amr.position_key
514: FROM ahl_unit_config_headers auch,
515: ahl_mc_headers_b amh,
516: ahl_mc_relationships amr
517: WHERE auch.csi_item_instance_id = c_instance_id
518: AND amh.mc_header_id = auch.master_config_id
519: AND amr.mc_header_id = amh.mc_header_id

Line 732: FROM AHL_MC_RELATIONSHIPS rel, AHL_MC_HEADERS_B HDR

728: CURSOR check_pos_key_top_csr(p_mc_id IN NUMBER,
729: p_ver_num IN NUMBER,
730: p_position_key IN NUMBER) IS
731: SELECT 'X'
732: FROM AHL_MC_RELATIONSHIPS rel, AHL_MC_HEADERS_B HDR
733: WHERE HDR.mc_header_id = REL.mc_header_id
734: AND REL.parent_relationship_id is NULL
735: AND REL.position_key = p_position_key
736: AND HDR.mc_id = p_mc_id

Line 1023: FROM AHL_MC_HEADERS_B hdr, AHL_UNIT_CONFIG_HEADERS uch

1019: -- initial path position mc_id and version number (mc_header_id)
1020: CURSOR check_top_mc_csr (p_csi_ii_id IN NUMBER, p_mc_id IN NUMBER,
1021: p_ver_num IN NUMBER) IS
1022: SELECT 'X'
1023: FROM AHL_MC_HEADERS_B hdr, AHL_UNIT_CONFIG_HEADERS uch
1024: WHERE uch.csi_item_instance_id = p_csi_ii_id
1025: AND uch.master_config_id = hdr.mc_header_id
1026: AND HDR.mc_id = p_mc_id
1027: AND HDR.version_number = nvl(p_ver_num, HDR.version_number);

Line 1086: FROM AHL_MC_RELATIONSHIPS rel, AHL_MC_HEADERS_B hdr, AHL_MC_RELATIONSHIPS prel

1082: p_version_number IN NUMBER,
1083: p_position_key IN NUMBER)
1084: IS
1085: SELECT rel.relationship_id, prel.position_key
1086: FROM AHL_MC_RELATIONSHIPS rel, AHL_MC_HEADERS_B hdr, AHL_MC_RELATIONSHIPS prel
1087: WHERE prel.relationship_id = rel.parent_relationship_id
1088: AND rel.position_key = p_position_key
1089: AND hdr.mc_header_id = rel.mc_header_id
1090: AND hdr.mc_id = p_mc_id

Line 1441: FROM ahl_mc_headers_b

1437: WHERE header.mc_header_id = p_header_id;
1438: --
1439: CURSOR get_mc_id_csr (p_mc_header_id IN NUMBER) IS
1440: SELECT mc_id
1441: FROM ahl_mc_headers_b
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

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 1636: FROM ahl_mc_headers_b

1632: IS
1633: --
1634: CURSOR get_mc_id_ver_csr (p_mc_header_id IN NUMBER) IS
1635: SELECT mc_id, version_number
1636: FROM ahl_mc_headers_b
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 *

Line 1849: FROM ahl_mc_headers_b header

1845: WHERE header.mc_header_id = p_header_id;
1846: --
1847: CURSOR get_num_of_version_csr (p_header_id IN NUMBER) IS
1848: SELECT count(*)
1849: FROM ahl_mc_headers_b header
1850: WHERE header.mc_id = (select mc_id FROM ahl_mc_headers_b
1851: where mc_header_id = p_header_id);
1852: --
1853: --Fetch all version specific path positions

Line 1850: WHERE header.mc_id = (select mc_id FROM ahl_mc_headers_b

1846: --
1847: CURSOR get_num_of_version_csr (p_header_id IN NUMBER) IS
1848: SELECT count(*)
1849: FROM ahl_mc_headers_b header
1850: WHERE header.mc_id = (select mc_id FROM ahl_mc_headers_b
1851: where mc_header_id = p_header_id);
1852: --
1853: --Fetch all version specific path positions
1854: CURSOR get_ver_position_ids_csr (p_mc_header_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 2046: FROM AHL_MC_HEADERS_B hd, AHL_MC_RELATIONSHIPS rel,

2042: --
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

Line 2117: FROM AHL_MC_HEADERS_B hd, AHL_MC_RELATIONSHIPS rel

2113: CURSOR get_def_path_pos_ref_csr (p_mc_id IN NUMBER,
2114: p_version_number IN NUMBER,
2115: p_position_key IN NUMBER) IS
2116: SELECT rel.position_ref_code
2117: FROM AHL_MC_HEADERS_B hd, AHL_MC_RELATIONSHIPS rel
2118: WHERE rel.position_key = p_position_key
2119: AND hd.mc_header_id = rel.mc_header_id
2120: AND hd.mc_id = p_mc_id
2121: AND hd.version_number = nvl(p_version_number, hd.version_number)

Line 2202: FROM AHL_MC_HEADERS_B a, AHL_MC_RELATIONSHIPS b

2198: WHERE uc_header_id = p_uc_header_id;
2199: --
2200: CURSOR get_rel_info_csr (p_rel_id IN VARCHAR2) IS
2201: SELECT a.mc_id, b.position_key
2202: FROM AHL_MC_HEADERS_B a, AHL_MC_RELATIONSHIPS b
2203: WHERE a.mc_header_id = b.mc_header_id
2204: AND b.relationship_id = p_rel_id;
2205: --
2206: CURSOR get_path_pos_ref_csr (p_encoded_path IN VARCHAR2) IS

Line 2491: FROM ahl_mc_headers_b hdr, ahl_mc_relationships rel,

2487: --
2488: --Fetches lowest level info
2489: CURSOR get_last_uc_rec_csr (p_csi_instance_id IN NUMBER) IS
2490: SELECT hdr.mc_id, hdr.version_number, rel.position_key
2491: FROM ahl_mc_headers_b hdr, ahl_mc_relationships rel,
2492: csi_ii_relationships csi_ii
2493: WHERE csi_ii.subject_id = p_csi_instance_id
2494: AND CSI_II.RELATIONSHIP_TYPE_CODE = 'COMPONENT-OF'
2495: AND TRUNC(nvl(CSI_II.ACTIVE_START_DATE, sysdate)) <= TRUNC(sysdate)

Line 2506: FROM ahl_mc_headers_b hdr, ahl_mc_relationships rel,

2502: -- since it does not take dates into consideration
2503: /*
2504: CURSOR get_top_unit_inst_csr (p_csi_instance_id IN NUMBER) IS
2505: SELECT hdr.mc_id, hdr.version_number, rel.position_key
2506: FROM ahl_mc_headers_b hdr, ahl_mc_relationships rel,
2507: ahl_unit_config_headers uch, csi_unit_instances_v csi_u
2508: WHERE uch.csi_item_instance_id = p_csi_instance_id
2509: AND TRUNC(nvl(uch.ACTIVE_START_DATE, sysdate)) <= TRUNC(sysdate)
2510: AND TRUNC(nvl(uch.ACTIVE_END_DATE, sysdate+1)) > TRUNC(sysdate)

Line 2518: FROM ahl_mc_headers_b hdr, ahl_mc_relationships rel,

2514: AND uch.csi_item_instance_id = csi_u.instance_id;
2515: */
2516: CURSOR get_top_unit_inst_csr (p_csi_instance_id IN NUMBER) IS
2517: SELECT hdr.mc_id, hdr.version_number, rel.position_key
2518: FROM ahl_mc_headers_b hdr, ahl_mc_relationships rel,
2519: ahl_unit_config_headers uch
2520: WHERE uch.csi_item_instance_id = p_csi_instance_id
2521: AND TRUNC(nvl(uch.ACTIVE_START_DATE, sysdate)) <= TRUNC(sysdate)
2522: AND TRUNC(nvl(uch.ACTIVE_END_DATE, sysdate+1)) > TRUNC(sysdate)

Line 2539: FROM ahl_mc_headers_b hdr, ahl_mc_relationships rel

2535: -- position.
2536: CURSOR get_mc_relationship_csr (p_relationships_id IN NUMBER,
2537: p_parent_instance_id IN NUMBER) IS
2538: SELECT hdr.mc_id, hdr.version_number, rel.position_key
2539: FROM ahl_mc_headers_b hdr, ahl_mc_relationships rel
2540: WHERE hdr.mc_header_id = rel.mc_header_id
2541: AND rel.relationship_id = p_relationship_id
2542: --Jerry rewrite the following condition on 03/03/2005 in order to fix bug 4090856
2543: --after verifying the bug fix on scmtsb2

Line 2779: -- from the mc id and version no, get the mc header id from ahl_mc_headers_b

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
2783: FROM ahl_mc_path_position_nodes mpn, ahl_mc_headers_b mch,

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)