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 446: FROM csi_ii_relationships csi

442: WHERE up.csi_instance_id = p_csi_instance_id;
443: --
444: CURSOR get_unit_instance_csr (p_csi_instance_id IN NUMBER) IS
445: SELECT csi.object_id
446: FROM csi_ii_relationships csi
447: WHERE csi.object_id IN
448: ( SELECT csi_item_instance_id
449: FROM ahl_unit_config_headers
450: WHERE trunc(nvl(active_start_date,sysdate)) <= trunc(sysdate)

Line 466: csi_ii_relationships csi_ii

462: --Fetches lowest level info
463: CURSOR get_last_uc_rec_csr (p_csi_instance_id IN NUMBER) IS
464: SELECT hdr.mc_id, hdr.version_number, rel.position_key
465: FROM ahl_mc_headers_b hdr, ahl_mc_relationships rel,
466: csi_ii_relationships csi_ii
467: WHERE csi_ii.subject_id = p_csi_instance_id
468: AND CSI_II.RELATIONSHIP_TYPE_CODE = 'COMPONENT-OF'
469: AND TRUNC(nvl(CSI_II.ACTIVE_START_DATE, sysdate)) <= TRUNC(sysdate)
470: AND TRUNC(nvl(CSI_II.ACTIVE_END_DATE, sysdate+1)) > TRUNC(sysdate)

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

806:
807: ELSE
808: v_Stmt := 'INSERT INTO AHL_APPLICABLE_INSTANCES '||
809: ' SELECT csi_ii.subject_id ,'|| p_position_id ||
810: ' FROM ahl_mc_relationships rel, csi_ii_relationships csi_ii '||
811: ' WHERE TO_NUMBER(CSI_II.POSITION_REFERENCE)=REL.RELATIONSHIP_ID '
812: ||' AND REL.position_key = :pos_key'||l_path_tbl.LAST
813: ||' START WITH csi_ii.object_id IN ( '
814: || v_Select || v_From || v_Where || ' ) '

Line 990: FROM csi_ii_relationships csi_ii

986: -- top node or a subnode.
987: CURSOR get_last_csi_id_csr (p_lowest_uc_ii_id IN NUMBER,
988: p_position_key IN NUMBER) IS
989: SELECT csi_ii.subject_id, csi_ii.object_id, TO_NUMBER(csi_ii.position_reference)
990: FROM csi_ii_relationships csi_ii
991: WHERE TO_NUMBER(CSI_II.POSITION_REFERENCE) in (select REL.RELATIONSHIP_ID
992: from ahl_mc_relationships rel
993: where REL.position_key = p_position_key)
994: START WITH csi_ii.object_id = p_lowest_uc_ii_id

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

1003: AND TRUNC(nvl(CSI_II.ACTIVE_END_DATE, sysdate+1)) > TRUNC(sysdate)
1004: AND CSI_II.POSITION_REFERENCE IS NOT NULL
1005: UNION ALL
1006: SELECT uch.csi_item_instance_id, csi_ii.object_id, TO_NUMBER(csi_ii.position_reference)
1007: FROM AHL_MC_RELATIONSHIPS rel, AHL_UNIT_CONFIG_HEADERS UCH, CSI_II_RELATIONSHIPS csi_ii
1008: WHERE UCH.master_config_id = REL.mc_header_id
1009: AND REL.parent_relationship_id is NULL
1010: AND REL.position_key = p_position_key
1011: AND uch.csi_item_instance_id = p_lowest_uc_ii_id

Line 1042: FROM csi_ii_relationships csi_ii

1038: -- and that position key is not null for all relnships.
1039: CURSOR check_pos_ref_csr (p_csi_instance_id IN NUMBER,
1040: p_to_csi_instance_id IN NUMBER) IS
1041: SELECT 'X'
1042: FROM csi_ii_relationships csi_ii
1043: WHERE csi_ii.object_id = p_to_csi_instance_id
1044: START WITH csi_ii.subject_id = p_csi_instance_id
1045: AND CSI_II.RELATIONSHIP_TYPE_CODE = 'COMPONENT-OF'
1046: AND TRUNC(nvl(CSI_II.ACTIVE_START_DATE, sysdate)) <= TRUNC(sysdate)

Line 2325: FROM csi_ii_relationships csi_ii

2321: --
2322: CURSOR check_pos_ref_csr (p_csi_instance_id IN NUMBER,
2323: p_to_csi_instance_id IN NUMBER) IS
2324: SELECT 'X'
2325: FROM csi_ii_relationships csi_ii
2326: WHERE csi_ii.object_id = p_to_csi_instance_id
2327: START WITH csi_ii.subject_id = p_csi_instance_id
2328: AND CSI_II.RELATIONSHIP_TYPE_CODE = 'COMPONENT-OF'
2329: AND TRUNC(nvl(CSI_II.ACTIVE_START_DATE, sysdate)) <= TRUNC(sysdate)

Line 2414: FROM csi_ii_relationships csi

2410: --
2411: --Traverse up and fetch all unit instance ids
2412: CURSOR get_unit_instance_csr (p_csi_instance_id IN NUMBER) IS
2413: SELECT csi.object_id
2414: FROM csi_ii_relationships csi
2415: WHERE csi.object_id IN
2416: ( SELECT csi_item_instance_id
2417: FROM ahl_unit_config_headers
2418: WHERE trunc(nvl(active_start_date,sysdate)) <= trunc(sysdate)

Line 2434: csi_ii_relationships csi_ii

2430: --Fetches lowest level info
2431: CURSOR get_last_uc_rec_csr (p_csi_instance_id IN NUMBER) IS
2432: SELECT hdr.mc_id, hdr.version_number, rel.position_key
2433: FROM ahl_mc_headers_b hdr, ahl_mc_relationships rel,
2434: csi_ii_relationships csi_ii
2435: WHERE csi_ii.subject_id = p_csi_instance_id
2436: AND CSI_II.RELATIONSHIP_TYPE_CODE = 'COMPONENT-OF'
2437: AND TRUNC(nvl(CSI_II.ACTIVE_START_DATE, sysdate)) <= TRUNC(sysdate)
2438: AND TRUNC(nvl(CSI_II.ACTIVE_END_DATE, sysdate+1)) > TRUNC(sysdate)

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

2464: AND TRUNC(nvl(uch.ACTIVE_END_DATE, sysdate+1)) > TRUNC(sysdate)
2465: AND hdr.mc_header_id = uch.master_config_id
2466: AND rel.mc_header_id = hdr.mc_header_id
2467: AND rel.parent_relationship_id IS NULL
2468: AND NOT EXISTS (SELECT 'X' FROM CSI_II_RELATIONSHIPS CIR
2469: WHERE CIR.SUBJECT_ID = uch.csi_item_instance_id AND
2470: CIR.RELATIONSHIP_TYPE_CODE = 'COMPONENT-OF' AND
2471: TRUNC(nvl(CIR.ACTIVE_START_DATE, sysdate)) <= TRUNC(sysdate) AND
2472: TRUNC(nvl(CIR.ACTIVE_END_DATE, sysdate+1)) > TRUNC(sysdate));

Line 2491: FROM csi_ii_relationships

2487: FROM ahl_mc_relationships
2488: WHERE mc_header_id = (SELECT mc_header_id
2489: FROM ahl_mc_relationships
2490: WHERE relationship_id = (SELECT to_number(position_reference)
2491: FROM csi_ii_relationships
2492: WHERE subject_id = p_parent_instance_id
2493: AND RELATIONSHIP_TYPE_CODE = 'COMPONENT-OF'
2494: AND TRUNC(nvl(ACTIVE_START_DATE, sysdate)) <= TRUNC(sysdate)
2495: AND TRUNC(nvl(ACTIVE_END_DATE, sysdate+1)) > TRUNC(sysdate)))

Line 2512: FROM csi_ii_relationships csi_ii

2508: --Jerry commented out the above condition on 01/14/2005 to fix bug 4090856
2509: AND TRUNC(nvl(uch.active_end_date, sysdate+1)) > TRUNC(sysdate)
2510: UNION ALL
2511: SELECT TO_NUMBER(CSI_II.POSITION_REFERENCE)
2512: FROM csi_ii_relationships csi_ii
2513: WHERE csi_ii.subject_id = p_parent_instance_id
2514: AND CSI_II.RELATIONSHIP_TYPE_CODE = 'COMPONENT-OF'
2515: AND TRUNC(nvl(CSI_II.ACTIVE_START_DATE, sysdate)) <= TRUNC(sysdate)
2516: AND TRUNC(nvl(CSI_II.ACTIVE_END_DATE, sysdate+1)) > TRUNC(sysdate)

Line 2520: csi_ii_relationships csi_ii

2516: AND TRUNC(nvl(CSI_II.ACTIVE_END_DATE, sysdate+1)) > TRUNC(sysdate)
2517: UNION ALL
2518: SELECT subrel.relationship_id
2519: FROM ahl_mc_config_relations crel, ahl_mc_relationships subrel,
2520: csi_ii_relationships csi_ii
2521: WHERE csi_ii.subject_id = p_parent_instance_id
2522: AND CSI_II.RELATIONSHIP_TYPE_CODE = 'COMPONENT-OF'
2523: AND TRUNC(nvl(CSI_II.ACTIVE_START_DATE, sysdate)) <= TRUNC(sysdate)
2524: AND TRUNC(nvl(CSI_II.ACTIVE_END_DATE, sysdate+1)) > TRUNC(sysdate)