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 CSI_II_RELATIONSHIPS

Line 455: FROM csi_ii_relationships csi

451: WHERE up.csi_instance_id = p_csi_instance_id;
452: --
453: CURSOR get_unit_instance_csr (p_csi_instance_id IN NUMBER) IS
454: SELECT csi.object_id
455: FROM csi_ii_relationships csi
456: WHERE csi.object_id IN
457: ( SELECT csi_item_instance_id
458: FROM ahl_unit_config_headers
459: WHERE trunc(nvl(active_start_date,sysdate)) <= trunc(sysdate)

Line 475: csi_ii_relationships csi_ii

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)
479: AND TRUNC(nvl(CSI_II.ACTIVE_END_DATE, sysdate+1)) > TRUNC(sysdate)

Line 864: ' FROM ahl_mc_relationships rel, csi_ii_relationships csi_ii '||

860:
861: ELSE
862: v_Stmt := 'INSERT INTO AHL_APPLICABLE_INSTANCES '||
863: ' SELECT csi_ii.subject_id ,'|| p_position_id ||
864: ' FROM ahl_mc_relationships rel, csi_ii_relationships csi_ii '||
865: ' WHERE TO_NUMBER(CSI_II.POSITION_REFERENCE)=REL.RELATIONSHIP_ID '
866: ||' AND REL.position_key = :pos_key'||l_path_tbl.LAST
867: ||' START WITH csi_ii.object_id IN ( '
868: || v_Select || v_From || v_Where || ' ) '

Line 1048: FROM csi_ii_relationships csi_ii

1044: -- top node or a subnode.
1045: CURSOR get_last_csi_id_csr (p_lowest_uc_ii_id IN NUMBER,
1046: p_position_key IN NUMBER) IS
1047: SELECT csi_ii.subject_id, csi_ii.object_id, TO_NUMBER(csi_ii.position_reference)
1048: FROM csi_ii_relationships csi_ii
1049: WHERE TO_NUMBER(CSI_II.POSITION_REFERENCE) in (select REL.RELATIONSHIP_ID
1050: from ahl_mc_relationships rel
1051: where REL.position_key = p_position_key)
1052: START WITH csi_ii.object_id = p_lowest_uc_ii_id

Line 1065: FROM AHL_MC_RELATIONSHIPS rel, AHL_UNIT_CONFIG_HEADERS UCH, CSI_II_RELATIONSHIPS csi_ii

1061: AND TRUNC(nvl(CSI_II.ACTIVE_END_DATE, sysdate+1)) > TRUNC(sysdate)
1062: AND CSI_II.POSITION_REFERENCE IS NOT NULL
1063: UNION ALL
1064: SELECT uch.csi_item_instance_id, csi_ii.object_id, TO_NUMBER(csi_ii.position_reference)
1065: FROM AHL_MC_RELATIONSHIPS rel, AHL_UNIT_CONFIG_HEADERS UCH, CSI_II_RELATIONSHIPS csi_ii
1066: WHERE UCH.master_config_id = REL.mc_header_id
1067: AND REL.parent_relationship_id is NULL
1068: AND REL.position_key = p_position_key
1069: AND uch.csi_item_instance_id = p_lowest_uc_ii_id

Line 1100: FROM csi_ii_relationships csi_ii

1096: -- and that position key is not null for all relnships.
1097: CURSOR check_pos_ref_csr (p_csi_instance_id IN NUMBER,
1098: p_to_csi_instance_id IN NUMBER) IS
1099: SELECT 'X'
1100: FROM csi_ii_relationships csi_ii
1101: WHERE csi_ii.object_id = p_to_csi_instance_id
1102: START WITH csi_ii.subject_id = p_csi_instance_id
1103: AND CSI_II.RELATIONSHIP_TYPE_CODE = 'COMPONENT-OF'
1104: AND TRUNC(nvl(CSI_II.ACTIVE_START_DATE, sysdate)) <= TRUNC(sysdate)

Line 2383: FROM csi_ii_relationships csi_ii

2379: --
2380: CURSOR check_pos_ref_csr (p_csi_instance_id IN NUMBER,
2381: p_to_csi_instance_id IN NUMBER) IS
2382: SELECT 'X'
2383: FROM csi_ii_relationships csi_ii
2384: WHERE csi_ii.object_id = p_to_csi_instance_id
2385: START WITH csi_ii.subject_id = p_csi_instance_id
2386: AND CSI_II.RELATIONSHIP_TYPE_CODE = 'COMPONENT-OF'
2387: AND TRUNC(nvl(CSI_II.ACTIVE_START_DATE, sysdate)) <= TRUNC(sysdate)

Line 2472: FROM csi_ii_relationships csi

2468: --
2469: --Traverse up and fetch all unit instance ids
2470: CURSOR get_unit_instance_csr (p_csi_instance_id IN NUMBER) IS
2471: SELECT csi.object_id
2472: FROM csi_ii_relationships csi
2473: WHERE csi.object_id IN
2474: ( SELECT csi_item_instance_id
2475: FROM ahl_unit_config_headers
2476: WHERE trunc(nvl(active_start_date,sysdate)) <= trunc(sysdate)

Line 2492: csi_ii_relationships csi_ii

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)
2496: AND TRUNC(nvl(CSI_II.ACTIVE_END_DATE, sysdate+1)) > TRUNC(sysdate)

Line 2526: AND NOT EXISTS (SELECT 'X' FROM CSI_II_RELATIONSHIPS CIR

2522: AND TRUNC(nvl(uch.ACTIVE_END_DATE, sysdate+1)) > TRUNC(sysdate)
2523: AND hdr.mc_header_id = uch.master_config_id
2524: AND rel.mc_header_id = hdr.mc_header_id
2525: AND rel.parent_relationship_id IS NULL
2526: AND NOT EXISTS (SELECT 'X' FROM CSI_II_RELATIONSHIPS CIR
2527: WHERE CIR.SUBJECT_ID = uch.csi_item_instance_id AND
2528: CIR.RELATIONSHIP_TYPE_CODE = 'COMPONENT-OF' AND
2529: TRUNC(nvl(CIR.ACTIVE_START_DATE, sysdate)) <= TRUNC(sysdate) AND
2530: TRUNC(nvl(CIR.ACTIVE_END_DATE, sysdate+1)) > TRUNC(sysdate));

Line 2549: FROM csi_ii_relationships

2545: FROM ahl_mc_relationships
2546: WHERE mc_header_id = (SELECT mc_header_id
2547: FROM ahl_mc_relationships
2548: WHERE relationship_id = (SELECT to_number(position_reference)
2549: FROM csi_ii_relationships
2550: WHERE subject_id = p_parent_instance_id
2551: AND RELATIONSHIP_TYPE_CODE = 'COMPONENT-OF'
2552: AND TRUNC(nvl(ACTIVE_START_DATE, sysdate)) <= TRUNC(sysdate)
2553: AND TRUNC(nvl(ACTIVE_END_DATE, sysdate+1)) > TRUNC(sysdate)))

Line 2570: FROM csi_ii_relationships csi_ii

2566: --Jerry commented out the above condition on 01/14/2005 to fix bug 4090856
2567: AND TRUNC(nvl(uch.active_end_date, sysdate+1)) > TRUNC(sysdate)
2568: UNION ALL
2569: SELECT TO_NUMBER(CSI_II.POSITION_REFERENCE)
2570: FROM csi_ii_relationships csi_ii
2571: WHERE csi_ii.subject_id = p_parent_instance_id
2572: AND CSI_II.RELATIONSHIP_TYPE_CODE = 'COMPONENT-OF'
2573: AND TRUNC(nvl(CSI_II.ACTIVE_START_DATE, sysdate)) <= TRUNC(sysdate)
2574: AND TRUNC(nvl(CSI_II.ACTIVE_END_DATE, sysdate+1)) > TRUNC(sysdate)

Line 2578: csi_ii_relationships csi_ii

2574: AND TRUNC(nvl(CSI_II.ACTIVE_END_DATE, sysdate+1)) > TRUNC(sysdate)
2575: UNION ALL
2576: SELECT subrel.relationship_id
2577: FROM ahl_mc_config_relations crel, ahl_mc_relationships subrel,
2578: csi_ii_relationships csi_ii
2579: WHERE csi_ii.subject_id = p_parent_instance_id
2580: AND CSI_II.RELATIONSHIP_TYPE_CODE = 'COMPONENT-OF'
2581: AND TRUNC(nvl(CSI_II.ACTIVE_START_DATE, sysdate)) <= TRUNC(sysdate)
2582: AND TRUNC(nvl(CSI_II.ACTIVE_END_DATE, sysdate+1)) > TRUNC(sysdate)