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 53: ahl_mc_relationships R

49: i NUMBER;
50: CURSOR check_installed_instance IS
51: SELECT 'x'
52: FROM ahl_unit_config_headers U,
53: ahl_mc_relationships R
54: WHERE U.master_config_id = R.mc_header_id
55: AND R.parent_relationship_id IS NULL
56: AND U.csi_item_instance_id = p_uc_parent_rec.instance_id
57: AND R.relationship_id = p_uc_parent_rec.relationship_id

Line 67: FROM ahl_mc_relationships

63: AND position_reference = to_char(p_uc_parent_rec.relationship_id)
64: AND nvl(trunc(active_end_date), trunc(SYSDATE)+1) > trunc(SYSDATE);
65: CURSOR check_relationship IS
66: SELECT 'x'
67: FROM ahl_mc_relationships
68: WHERE relationship_id = p_uc_parent_rec.relationship_id;
69: CURSOR check_instance IS
70: SELECT 'x'
71: FROM csi_item_instances

Line 76: ahl_mc_relationships B

72: WHERE instance_id = p_uc_parent_rec.instance_id;
73: CURSOR get_top_position(c_instance_id number) IS
74: SELECT B.relationship_id
75: FROM ahl_unit_config_headers A,
76: ahl_mc_relationships B
77: WHERE A.master_config_id = B.mc_header_id
78: AND B.parent_relationship_id IS NULL
79: AND A.csi_item_instance_id = c_instance_id;
80: -- get immediate children for installed node

Line 94: FROM ahl_mc_relationships

90: AND position_reference IS NOT NULL
91: AND nvl(trunc(active_end_date), trunc(SYSDATE)+1) > trunc(SYSDATE)
92: UNION
93: SELECT 'E' node_type, NULL instance_id, relationship_id
94: FROM ahl_mc_relationships
95: WHERE parent_relationship_id = c_relationship_id
96: AND relationship_id NOT IN (SELECT position_reference
97: FROM csi_ii_relationships
98: WHERE object_id = c_instance_id

Line 105: FROM ahl_mc_relationships

101: l_get_child_nodes_i get_child_nodes_i%ROWTYPE;
102: -- get immediate children for empty node
103: CURSOR get_child_nodes_m(c_relationship_id number) IS
104: SELECT 'E' node_type, NULL instance_id, relationship_id
105: FROM ahl_mc_relationships
106: WHERE parent_relationship_id = c_relationship_id;
107: -- get immediate children for extra node
108: CURSOR get_child_nodes_x(c_instance_id number) IS
109: SELECT 'X' node_type, subject_id instance_id, to_number(position_reference) relationship_id

Line 234: FROM ahl_mc_relationships

230: x_uc_child_tbl(j).leaf_node_flag := 'N';
231: END IF;
232: ELSIF x_uc_child_tbl(j).node_type = 'M' THEN
233: SELECT count(relationship_id) INTO l_children_no
234: FROM ahl_mc_relationships
235: WHERE parent_relationship_id = x_uc_child_tbl(j).relationship_id;
236: IF l_children_no > 0 THEN
237: x_uc_child_tbl(j).has_subconfig_flag := 'N';
238: x_uc_child_tbl(j).leaf_node_flag := 'N';

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

353: l_child_partinfo_tbl t_partinfo_tbl;
354: l_pos_ref FND_LOOKUPS.meaning%TYPE;
355: l_root_mc_hdr_id NUMBER;
356: l_root_mc_part BOOLEAN;
357: l_root_ata_code AHL_MC_RELATIONSHIPS.ATA_CODE%TYPE; -- SATHAPLI::Enigma code changes, 02-Sep-2008
358:
359: l_matched boolean;
360: total_i NUMBER; --index of output table
361: i_uc_child NUMBER; --index of MC siblings

Line 378: ahl_mc_relationships B

374: A.master_config_id,
375: B.relationship_id,
376: B.ata_code
377: FROM ahl_unit_config_headers A,
378: ahl_mc_relationships B
379: WHERE A.unit_config_header_id = c_uc_header_id
380: AND A.master_config_id = B.mc_header_id
381: AND B.parent_relationship_id IS NULL;
382:

Line 439: FROM ahl_mc_relationships rel

435: AND fnd.lookup_code = rel.position_necessity_code
436: AND trunc(nvl(fnd.start_date_active, SYSDATE)) <= trunc(SYSDATE)
437: AND trunc(nvl(fnd.end_date_active, SYSDATE+1)) > trunc(SYSDATE)
438: ) pos_necessity
439: FROM ahl_mc_relationships rel
440: WHERE rel.parent_relationship_id = c_relationship_id
441: AND trunc(nvl(rel.active_start_date,SYSDATE)) <= trunc(SYSDATE)
442: AND trunc(nvl(rel.active_end_date, SYSDATE+1)) > trunc(SYSDATE)
443: ORDER BY display_order;

Line 449: FROM ahl_mc_relationships

445: -- rbhavsar::FP Bug# 6268202, performance tuning
446: -- cursor to check if the position is leaf node or not
447: CURSOR chk_mc_leaf_node_csr(c_relationship_id NUMBER) IS
448: SELECT 'X'
449: FROM ahl_mc_relationships
450: WHERE parent_relationship_id = c_relationship_id
451: AND trunc(nvl(active_start_date,SYSDATE)) <= trunc(SYSDATE)
452: AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE);
453:

Line 477: FROM ahl_mc_relationships rel

473: AND fnd.lookup_code = rel.position_necessity_code
474: AND trunc(nvl(fnd.start_date_active, SYSDATE)) <= trunc(SYSDATE)
475: AND trunc(nvl(fnd.end_date_active, SYSDATE+1)) > trunc(SYSDATE)
476: ) pos_necessity
477: FROM ahl_mc_relationships rel
478: START WITH rel.parent_relationship_id = c_relationship_id
479: AND trunc(nvl(rel.active_start_date,SYSDATE)) <= trunc(SYSDATE)
480: AND trunc(nvl(rel.active_end_date, SYSDATE+1)) > trunc(SYSDATE)
481: CONNECT BY rel.parent_relationship_id = PRIOR rel.relationship_id

Line 496: ahl_mc_relationships B

492: SELECT A.unit_config_header_id,
493: A.master_config_id,
494: B.relationship_id
495: FROM ahl_unit_config_headers A,
496: ahl_mc_relationships B
497: WHERE A.csi_item_instance_id = c_instance_id
498: AND trunc(nvl(A.active_end_date, SYSDATE+1)) > trunc(SYSDATE)
499: AND B.mc_header_id = A.master_config_id
500: AND B.parent_relationship_id IS NULL

Line 518: FROM ahl_mc_relationships rel, fnd_lookups fnd

514: -- rbhavsar:: FP Bug# 6268202, performance tuning
515: -- Cursor to get the position reference for a given relationship id.
516: CURSOR get_pos_ref_csr(c_relationship_id NUMBER) IS
517: SELECT fnd.meaning
518: FROM ahl_mc_relationships rel, fnd_lookups fnd
519: WHERE rel.relationship_id = c_relationship_id AND
520: fnd.lookup_code = rel.position_ref_code AND
521: fnd.lookup_type = 'AHL_POSITION_REFERENCE' AND
522: TRUNC(NVL(fnd.start_date_active, SYSDATE)) <= TRUNC(SYSDATE) AND

Line 535: AHL_MC_RELATIONSHIPS A

531: A.RELATIONSHIP_ID,
532: 'I' NODE_TYPE,
533: 0 OWN_LEVEL
534: FROM AHL_UNIT_CONFIG_HEADERS B,
535: AHL_MC_RELATIONSHIPS A
536: WHERE B.UNIT_CONFIG_HEADER_ID = p_uc_header_id /*UC header id*/
537: AND B.CSI_ITEM_INSTANCE_ID = c_instance_id /*root instance id*/
538: AND A.MC_HEADER_ID = B.MASTER_CONFIG_ID
539: AND A.PARENT_RELATIONSHIP_ID IS NULL

Line 559: FROM AHL_MC_RELATIONSHIPS D

555: )
556: OR
557: (
558: EXISTS (SELECT 'x'
559: FROM AHL_MC_RELATIONSHIPS D
560: WHERE D.PARENT_RELATIONSHIP_ID = TO_NUMBER(A.POSITION_REFERENCE)
561: AND TRUNC(NVL(D.ACTIVE_START_DATE,SYSDATE)) <= TRUNC(SYSDATE)
562: AND TRUNC(NVL(D.ACTIVE_END_DATE, SYSDATE+1)) > TRUNC(SYSDATE)
563: )

Line 566: FROM AHL_MC_RELATIONSHIPS D

562: AND TRUNC(NVL(D.ACTIVE_END_DATE, SYSDATE+1)) > TRUNC(SYSDATE)
563: )
564: OR
565: EXISTS (SELECT 'x'
566: FROM AHL_MC_RELATIONSHIPS D
567: WHERE D.RELATIONSHIP_ID = TO_NUMBER(A.POSITION_REFERENCE)
568: AND EXISTS (SELECT 'x'
569: FROM AHL_UNIT_CONFIG_HEADERS E
570: WHERE CSI_ITEM_INSTANCE_ID = A.SUBJECT_ID

Line 595: FROM ahl_mc_relationships A,

591: FUNCTION position_necessity(p_relationship_id NUMBER) RETURN VARCHAR2 IS
592: l_pos_necessity_meaning fnd_lookups.meaning%TYPE;
593: CURSOR get_position_necessity(c_relationship_id NUMBER) IS
594: SELECT F.meaning
595: FROM ahl_mc_relationships A,
596: fnd_lookup_values_vl F
597: WHERE A.relationship_id = c_relationship_id
598: AND A.position_necessity_code = F.lookup_code (+)
599: AND F.lookup_type (+) = 'AHL_POSITION_NECESSITY';

Line 1200: ahl_mc_relationships R

1196: R.relationship_id,
1197: H.name,
1198: H.revision
1199: FROM ahl_mc_headers_b H,
1200: ahl_mc_relationships R
1201: WHERE H.mc_header_id = p_mc_header_id
1202: AND R.mc_header_id = H.mc_header_id
1203: AND R.parent_relationship_id IS NULL
1204: AND trunc(nvl(R.active_start_date,SYSDATE)) <= trunc(SYSDATE)

Line 1210: FROM ahl_mc_relationships M,

1206: CURSOR get_mc_header_items(c_mc_header_id NUMBER) IS
1207: SELECT M.relationship_id,
1208: I.inventory_item_id,
1209: I.inventory_org_id
1210: FROM ahl_mc_relationships M,
1211: ahl_item_associations_b I
1212: WHERE M.mc_header_id = c_mc_header_id
1213: AND M.parent_relationship_id IS NULL
1214: AND M.item_group_id = I.item_group_id;

Line 1239: ahl_mc_relationships M,

1235: I.inventory_revision,
1236: I.quantity,
1237: I.unit_of_measure
1238: FROM csi_ii_relationships C,
1239: ahl_mc_relationships M,
1240: csi_item_instances I
1241: WHERE to_number(C.position_reference) = M.relationship_id (+)
1242: AND C.subject_id = I.instance_id
1243: AND C.object_id = c_instance_id

Line 1254: FROM ahl_mc_relationships

1250: relationship_id,
1251: position_key,
1252: position_ref_code,
1253: item_group_id
1254: FROM ahl_mc_relationships
1255: WHERE parent_relationship_id = c_relationship_id
1256: AND trunc(nvl(active_start_date,SYSDATE)) <= trunc(SYSDATE)
1257: AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE);
1258: --Check whether an instance in UC is the top node of a sub UC, if yes, then get the

Line 1264: ahl_mc_relationships B

1260: CURSOR check_sub_uc(c_instance_id NUMBER) IS
1261: SELECT A.master_config_id mc_header_id,
1262: B.relationship_id
1263: FROM ahl_unit_config_headers A,
1264: ahl_mc_relationships B
1265: WHERE A.csi_item_instance_id = c_instance_id
1266: AND trunc(nvl(A.active_end_date, SYSDATE+1)) > trunc(SYSDATE)
1267: AND B.mc_header_id = A.master_config_id
1268: AND B.parent_relationship_id IS NULL

Line 1285: ahl_mc_relationships A

1281: SELECT TO_NUMBER(NULL) parent_instance_id, --just include the root uc node
1282: B.csi_item_instance_id instance_id,
1283: A.relationship_id
1284: FROM ahl_unit_config_headers B,
1285: ahl_mc_relationships A
1286: WHERE B.csi_item_instance_id = c_instance_id
1287: AND trunc(nvl(B.active_end_date, SYSDATE+1)) > trunc(SYSDATE)
1288: AND A.mc_header_id = B.master_config_id
1289: AND A.parent_relationship_id IS NULL

Line 1978: FROM ahl_mc_relationships M,

1974: CURSOR check_mc_relationship IS
1975: SELECT M.relationship_id,
1976: I.inventory_item_id,
1977: I.inventory_org_id
1978: FROM ahl_mc_relationships M,
1979: ahl_item_associations_b I
1980: WHERE M.relationship_id = p_relationship_id
1981: AND M.item_group_id = I.item_group_id
1982: AND trunc(nvl(M.active_start_date,SYSDATE)) <= trunc(SYSDATE)

Line 2009: ahl_mc_relationships M,

2005: I.inventory_revision,
2006: I.quantity,
2007: I.unit_of_measure
2008: FROM csi_ii_relationships C,
2009: ahl_mc_relationships M,
2010: csi_item_instances I
2011: WHERE to_number(C.position_reference) = M.relationship_id (+)
2012: AND C.subject_id = I.instance_id
2013: AND C.object_id = c_instance_id

Line 2024: FROM ahl_mc_relationships

2020: relationship_id,
2021: position_key,
2022: position_ref_code,
2023: item_group_id
2024: FROM ahl_mc_relationships
2025: WHERE parent_relationship_id = c_relationship_id
2026: AND trunc(nvl(active_start_date,SYSDATE)) <= trunc(SYSDATE)
2027: AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE);
2028: --Check whether an instance in UC is the top node of a sub UC, if yes, then get the

Line 2034: ahl_mc_relationships B

2030: CURSOR check_sub_uc(c_instance_id NUMBER) IS
2031: SELECT A.master_config_id mc_header_id,
2032: B.relationship_id
2033: FROM ahl_unit_config_headers A,
2034: ahl_mc_relationships B
2035: WHERE A.csi_item_instance_id = c_instance_id
2036: AND trunc(nvl(A.active_end_date, SYSDATE+1)) > trunc(SYSDATE)
2037: AND B.mc_header_id = A.master_config_id
2038: AND B.parent_relationship_id IS NULL

Line 2366: SELECT 1 from ahl_mc_relationships

2362: AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE));
2363:
2364: -- Validate that the child position is still valid under the parent position
2365: CURSOR validate_position_csr(c_child_relationship_id IN NUMBER) IS
2366: SELECT 1 from ahl_mc_relationships
2367: where relationship_id = c_child_relationship_id
2368: AND parent_relationship_id = p_relationship_id
2369: AND trunc(nvl(active_start_date,SYSDATE)) <= trunc(SYSDATE)
2370: AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE);

Line 2375: FROM ahl_mc_relationships

2371:
2372: -- Get all children of current position that are empty positions
2373: CURSOR get_all_empty_positions_csr IS
2374: SELECT relationship_id
2375: FROM ahl_mc_relationships
2376: WHERE parent_relationship_id = p_relationship_id
2377: AND trunc(nvl(active_start_date,SYSDATE)) <= trunc(SYSDATE)
2378: AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE)
2379: MINUS