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_UC_TREE_PVT dependencies on AHL_MC_RELATIONSHIPS

Line 42: ahl_mc_relationships R

38: i NUMBER;
39: CURSOR check_installed_instance IS
40: SELECT 'x'
41: FROM ahl_unit_config_headers U,
42: ahl_mc_relationships R
43: WHERE U.master_config_id = R.mc_header_id
44: AND R.parent_relationship_id IS NULL
45: AND U.csi_item_instance_id = p_uc_parent_rec.instance_id
46: AND R.relationship_id = p_uc_parent_rec.relationship_id

Line 56: FROM ahl_mc_relationships

52: AND position_reference = to_char(p_uc_parent_rec.relationship_id)
53: AND nvl(trunc(active_end_date), trunc(SYSDATE)+1) > trunc(SYSDATE);
54: CURSOR check_relationship IS
55: SELECT 'x'
56: FROM ahl_mc_relationships
57: WHERE relationship_id = p_uc_parent_rec.relationship_id;
58: CURSOR check_instance IS
59: SELECT 'x'
60: FROM csi_item_instances

Line 65: ahl_mc_relationships B

61: WHERE instance_id = p_uc_parent_rec.instance_id;
62: CURSOR get_top_position(c_instance_id number) IS
63: SELECT B.relationship_id
64: FROM ahl_unit_config_headers A,
65: ahl_mc_relationships B
66: WHERE A.master_config_id = B.mc_header_id
67: AND B.parent_relationship_id IS NULL
68: AND A.csi_item_instance_id = c_instance_id;
69: -- get immediate children for installed node

Line 83: FROM ahl_mc_relationships

79: AND position_reference IS NOT NULL
80: AND nvl(trunc(active_end_date), trunc(SYSDATE)+1) > trunc(SYSDATE)
81: UNION
82: SELECT 'E' node_type, NULL instance_id, relationship_id
83: FROM ahl_mc_relationships
84: WHERE parent_relationship_id = c_relationship_id
85: AND relationship_id NOT IN (SELECT position_reference
86: FROM csi_ii_relationships
87: WHERE object_id = c_instance_id

Line 94: FROM ahl_mc_relationships

90: l_get_child_nodes_i get_child_nodes_i%ROWTYPE;
91: -- get immediate children for empty node
92: CURSOR get_child_nodes_m(c_relationship_id number) IS
93: SELECT 'E' node_type, NULL instance_id, relationship_id
94: FROM ahl_mc_relationships
95: WHERE parent_relationship_id = c_relationship_id;
96: -- get immediate children for extra node
97: CURSOR get_child_nodes_x(c_instance_id number) IS
98: SELECT 'X' node_type, subject_id instance_id, to_number(position_reference) relationship_id

Line 223: FROM ahl_mc_relationships

219: x_uc_child_tbl(j).leaf_node_flag := 'N';
220: END IF;
221: ELSIF x_uc_child_tbl(j).node_type = 'M' THEN
222: SELECT count(relationship_id) INTO l_children_no
223: FROM ahl_mc_relationships
224: WHERE parent_relationship_id = x_uc_child_tbl(j).relationship_id;
225: IF l_children_no > 0 THEN
226: x_uc_child_tbl(j).has_subconfig_flag := 'N';
227: x_uc_child_tbl(j).leaf_node_flag := 'N';

Line 346: l_root_ata_code AHL_MC_RELATIONSHIPS.ATA_CODE%TYPE; -- SATHAPLI::Enigma code changes, 02-Sep-2008

342: l_child_partinfo_tbl t_partinfo_tbl;
343: l_pos_ref FND_LOOKUPS.meaning%TYPE;
344: l_root_mc_hdr_id NUMBER;
345: l_root_mc_part BOOLEAN;
346: l_root_ata_code AHL_MC_RELATIONSHIPS.ATA_CODE%TYPE; -- SATHAPLI::Enigma code changes, 02-Sep-2008
347:
348: l_matched boolean;
349: total_i NUMBER; --index of output table
350: i_uc_child NUMBER; --index of MC siblings

Line 364: ahl_mc_relationships B

360: A.master_config_id,
361: B.relationship_id,
362: B.ata_code
363: FROM ahl_unit_config_headers A,
364: ahl_mc_relationships B
365: WHERE A.unit_config_header_id = c_uc_header_id
366: AND A.master_config_id = B.mc_header_id
367: AND B.parent_relationship_id IS NULL;
368:

Line 425: FROM ahl_mc_relationships rel

421: AND fnd.lookup_code = rel.position_necessity_code
422: AND trunc(nvl(fnd.start_date_active, SYSDATE)) <= trunc(SYSDATE)
423: AND trunc(nvl(fnd.end_date_active, SYSDATE+1)) > trunc(SYSDATE)
424: ) pos_necessity
425: FROM ahl_mc_relationships rel
426: WHERE rel.parent_relationship_id = c_relationship_id
427: AND trunc(nvl(rel.active_start_date,SYSDATE)) <= trunc(SYSDATE)
428: AND trunc(nvl(rel.active_end_date, SYSDATE+1)) > trunc(SYSDATE)
429: ORDER BY display_order;

Line 435: FROM ahl_mc_relationships

431: -- rbhavsar::FP Bug# 6268202, performance tuning
432: -- cursor to check if the position is leaf node or not
433: CURSOR chk_mc_leaf_node_csr(c_relationship_id NUMBER) IS
434: SELECT 'X'
435: FROM ahl_mc_relationships
436: WHERE parent_relationship_id = c_relationship_id
437: AND trunc(nvl(active_start_date,SYSDATE)) <= trunc(SYSDATE)
438: AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE);
439:

Line 463: FROM ahl_mc_relationships rel

459: AND fnd.lookup_code = rel.position_necessity_code
460: AND trunc(nvl(fnd.start_date_active, SYSDATE)) <= trunc(SYSDATE)
461: AND trunc(nvl(fnd.end_date_active, SYSDATE+1)) > trunc(SYSDATE)
462: ) pos_necessity
463: FROM ahl_mc_relationships rel
464: START WITH rel.parent_relationship_id = c_relationship_id
465: AND trunc(nvl(rel.active_start_date,SYSDATE)) <= trunc(SYSDATE)
466: AND trunc(nvl(rel.active_end_date, SYSDATE+1)) > trunc(SYSDATE)
467: CONNECT BY rel.parent_relationship_id = PRIOR rel.relationship_id

Line 482: ahl_mc_relationships B

478: SELECT A.unit_config_header_id,
479: A.master_config_id,
480: B.relationship_id
481: FROM ahl_unit_config_headers A,
482: ahl_mc_relationships B
483: WHERE A.csi_item_instance_id = c_instance_id
484: AND trunc(nvl(A.active_end_date, SYSDATE+1)) > trunc(SYSDATE)
485: AND B.mc_header_id = A.master_config_id
486: AND B.parent_relationship_id IS NULL

Line 504: FROM ahl_mc_relationships rel, fnd_lookups fnd

500: -- rbhavsar:: FP Bug# 6268202, performance tuning
501: -- Cursor to get the position reference for a given relationship id.
502: CURSOR get_pos_ref_csr(c_relationship_id NUMBER) IS
503: SELECT fnd.meaning
504: FROM ahl_mc_relationships rel, fnd_lookups fnd
505: WHERE rel.relationship_id = c_relationship_id AND
506: fnd.lookup_code = rel.position_ref_code AND
507: fnd.lookup_type = 'AHL_POSITION_REFERENCE' AND
508: TRUNC(NVL(fnd.start_date_active, SYSDATE)) <= TRUNC(SYSDATE) AND

Line 521: AHL_MC_RELATIONSHIPS A

517: A.RELATIONSHIP_ID,
518: 'I' NODE_TYPE,
519: 0 OWN_LEVEL
520: FROM AHL_UNIT_CONFIG_HEADERS B,
521: AHL_MC_RELATIONSHIPS A
522: WHERE B.UNIT_CONFIG_HEADER_ID = p_uc_header_id /*UC header id*/
523: AND B.CSI_ITEM_INSTANCE_ID = c_instance_id /*root instance id*/
524: AND A.MC_HEADER_ID = B.MASTER_CONFIG_ID
525: AND A.PARENT_RELATIONSHIP_ID IS NULL

Line 545: FROM AHL_MC_RELATIONSHIPS D

541: )
542: OR
543: (
544: EXISTS (SELECT 'x'
545: FROM AHL_MC_RELATIONSHIPS D
546: WHERE D.PARENT_RELATIONSHIP_ID = TO_NUMBER(A.POSITION_REFERENCE)
547: AND TRUNC(NVL(D.ACTIVE_START_DATE,SYSDATE)) <= TRUNC(SYSDATE)
548: AND TRUNC(NVL(D.ACTIVE_END_DATE, SYSDATE+1)) > TRUNC(SYSDATE)
549: )

Line 552: FROM AHL_MC_RELATIONSHIPS D

548: AND TRUNC(NVL(D.ACTIVE_END_DATE, SYSDATE+1)) > TRUNC(SYSDATE)
549: )
550: OR
551: EXISTS (SELECT 'x'
552: FROM AHL_MC_RELATIONSHIPS D
553: WHERE D.RELATIONSHIP_ID = TO_NUMBER(A.POSITION_REFERENCE)
554: AND EXISTS (SELECT 'x'
555: FROM AHL_UNIT_CONFIG_HEADERS E
556: WHERE CSI_ITEM_INSTANCE_ID = A.SUBJECT_ID

Line 581: FROM ahl_mc_relationships A,

577: FUNCTION position_necessity(p_relationship_id NUMBER) RETURN VARCHAR2 IS
578: l_pos_necessity_meaning fnd_lookups.meaning%TYPE;
579: CURSOR get_position_necessity(c_relationship_id NUMBER) IS
580: SELECT F.meaning
581: FROM ahl_mc_relationships A,
582: fnd_lookup_values_vl F
583: WHERE A.relationship_id = c_relationship_id
584: AND A.position_necessity_code = F.lookup_code (+)
585: AND F.lookup_type (+) = 'AHL_POSITION_NECESSITY';

Line 1158: ahl_mc_relationships R

1154: R.relationship_id,
1155: H.name,
1156: H.revision
1157: FROM ahl_mc_headers_b H,
1158: ahl_mc_relationships R
1159: WHERE H.mc_header_id = p_mc_header_id
1160: AND R.mc_header_id = H.mc_header_id
1161: AND R.parent_relationship_id IS NULL
1162: AND trunc(nvl(R.active_start_date,SYSDATE)) <= trunc(SYSDATE)

Line 1168: FROM ahl_mc_relationships M,

1164: CURSOR get_mc_header_items(c_mc_header_id NUMBER) IS
1165: SELECT M.relationship_id,
1166: I.inventory_item_id,
1167: I.inventory_org_id
1168: FROM ahl_mc_relationships M,
1169: ahl_item_associations_b I
1170: WHERE M.mc_header_id = c_mc_header_id
1171: AND M.parent_relationship_id IS NULL
1172: AND M.item_group_id = I.item_group_id;

Line 1197: ahl_mc_relationships M,

1193: I.inventory_revision,
1194: I.quantity,
1195: I.unit_of_measure
1196: FROM csi_ii_relationships C,
1197: ahl_mc_relationships M,
1198: csi_item_instances I
1199: WHERE to_number(C.position_reference) = M.relationship_id (+)
1200: AND C.subject_id = I.instance_id
1201: AND C.object_id = c_instance_id

Line 1212: FROM ahl_mc_relationships

1208: relationship_id,
1209: position_key,
1210: position_ref_code,
1211: item_group_id
1212: FROM ahl_mc_relationships
1213: WHERE parent_relationship_id = c_relationship_id
1214: AND trunc(nvl(active_start_date,SYSDATE)) <= trunc(SYSDATE)
1215: AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE);
1216: --Check whether an instance in UC is the top node of a sub UC, if yes, then get the

Line 1222: ahl_mc_relationships B

1218: CURSOR check_sub_uc(c_instance_id NUMBER) IS
1219: SELECT A.master_config_id mc_header_id,
1220: B.relationship_id
1221: FROM ahl_unit_config_headers A,
1222: ahl_mc_relationships B
1223: WHERE A.csi_item_instance_id = c_instance_id
1224: AND trunc(nvl(A.active_end_date, SYSDATE+1)) > trunc(SYSDATE)
1225: AND B.mc_header_id = A.master_config_id
1226: AND B.parent_relationship_id IS NULL

Line 1243: ahl_mc_relationships A

1239: SELECT TO_NUMBER(NULL) parent_instance_id, --just include the root uc node
1240: B.csi_item_instance_id instance_id,
1241: A.relationship_id
1242: FROM ahl_unit_config_headers B,
1243: ahl_mc_relationships A
1244: WHERE B.csi_item_instance_id = c_instance_id
1245: AND trunc(nvl(B.active_end_date, SYSDATE+1)) > trunc(SYSDATE)
1246: AND A.mc_header_id = B.master_config_id
1247: AND A.parent_relationship_id IS NULL

Line 1915: FROM ahl_mc_relationships M,

1911: CURSOR check_mc_relationship IS
1912: SELECT M.relationship_id,
1913: I.inventory_item_id,
1914: I.inventory_org_id
1915: FROM ahl_mc_relationships M,
1916: ahl_item_associations_b I
1917: WHERE M.relationship_id = p_relationship_id
1918: AND M.item_group_id = I.item_group_id
1919: AND trunc(nvl(M.active_start_date,SYSDATE)) <= trunc(SYSDATE)

Line 1946: ahl_mc_relationships M,

1942: I.inventory_revision,
1943: I.quantity,
1944: I.unit_of_measure
1945: FROM csi_ii_relationships C,
1946: ahl_mc_relationships M,
1947: csi_item_instances I
1948: WHERE to_number(C.position_reference) = M.relationship_id (+)
1949: AND C.subject_id = I.instance_id
1950: AND C.object_id = c_instance_id

Line 1961: FROM ahl_mc_relationships

1957: relationship_id,
1958: position_key,
1959: position_ref_code,
1960: item_group_id
1961: FROM ahl_mc_relationships
1962: WHERE parent_relationship_id = c_relationship_id
1963: AND trunc(nvl(active_start_date,SYSDATE)) <= trunc(SYSDATE)
1964: AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE);
1965: --Check whether an instance in UC is the top node of a sub UC, if yes, then get the

Line 1971: ahl_mc_relationships B

1967: CURSOR check_sub_uc(c_instance_id NUMBER) IS
1968: SELECT A.master_config_id mc_header_id,
1969: B.relationship_id
1970: FROM ahl_unit_config_headers A,
1971: ahl_mc_relationships B
1972: WHERE A.csi_item_instance_id = c_instance_id
1973: AND trunc(nvl(A.active_end_date, SYSDATE+1)) > trunc(SYSDATE)
1974: AND B.mc_header_id = A.master_config_id
1975: AND B.parent_relationship_id IS NULL

Line 2303: SELECT 1 from ahl_mc_relationships

2299: AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE));
2300:
2301: -- Validate that the child position is still valid under the parent position
2302: CURSOR validate_position_csr(c_child_relationship_id IN NUMBER) IS
2303: SELECT 1 from ahl_mc_relationships
2304: where relationship_id = c_child_relationship_id
2305: AND parent_relationship_id = p_relationship_id
2306: AND trunc(nvl(active_start_date,SYSDATE)) <= trunc(SYSDATE)
2307: AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE);

Line 2312: FROM ahl_mc_relationships

2308:
2309: -- Get all children of current position that are empty positions
2310: CURSOR get_all_empty_positions_csr IS
2311: SELECT relationship_id
2312: FROM ahl_mc_relationships
2313: WHERE parent_relationship_id = p_relationship_id
2314: AND trunc(nvl(active_start_date,SYSDATE)) <= trunc(SYSDATE)
2315: AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE)
2316: MINUS