APPS.AHL_MC_PATH_POSITION_PVT dependencies on AHL_UNIT_CONFIG_HEADERS

Line 458: FROM ahl_unit_config_headers

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)
460: AND trunc(sysdate) < trunc(nvl(active_end_date, sysdate+1)))
461: START WITH csi.subject_id = p_csi_instance_id
462: AND CSI.RELATIONSHIP_TYPE_CODE = 'COMPONENT-OF'

Line 486: ahl_unit_config_headers uch, csi_unit_instances_v csi_u

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)
490: AND hdr.mc_header_id = uch.master_config_id

Line 514: FROM ahl_unit_config_headers auch,

510: --modification by jrotich on 10/02/2012 for fixing bug 13472472 BEGIN
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

Line 1005: FROM AHL_UNIT_CONFIG_HEADERS uch

1001: --
1002: --Step 0) Check instance is defined in uc headers
1003: CURSOR check_instance_top_csr(p_instance_id IN NUMBER) IS
1004: SELECT 'X'
1005: FROM AHL_UNIT_CONFIG_HEADERS uch
1006: WHERE uch.csi_item_instance_id = p_instance_id;
1007:
1008: --
1009: --Step 1) Build the path Position table object

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 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 2191: FROM ahl_unit_config_headers

2187: --
2188: --Fetch the unit and unit header info for instance
2189: CURSOR get_uc_headers_csr (p_uc_header_id IN NUMBER) IS
2190: SELECT unit_config_header_id
2191: FROM ahl_unit_config_headers
2192: START WITH unit_config_header_id = p_uc_header_id
2193: CONNECT BY PRIOR parent_uc_header_id = unit_config_header_id;
2194: --
2195: CURSOR get_header_details_csr (p_uc_header_id IN NUMBER) IS

Line 2475: FROM ahl_unit_config_headers

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)
2477: AND trunc(sysdate) < trunc(nvl(active_end_date, sysdate+1)))
2478: START WITH csi.subject_id = p_csi_instance_id
2479: AND CSI.RELATIONSHIP_TYPE_CODE = 'COMPONENT-OF'

Line 2507: ahl_unit_config_headers uch, csi_unit_instances_v csi_u

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)
2511: AND hdr.mc_header_id = uch.master_config_id

Line 2519: ahl_unit_config_headers uch

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)
2523: AND hdr.mc_header_id = uch.master_config_id

Line 2555: FROM ahl_unit_config_headers

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)))
2554: OR mc_header_id = (SELECT master_config_id
2555: FROM ahl_unit_config_headers
2556: WHERE csi_item_instance_id = p_parent_instance_id
2557: AND TRUNC(nvl(ACTIVE_END_DATE, sysdate+1)) > TRUNC(sysdate)));
2558:
2559: /*

Line 2562: FROM AHL_MC_RELATIONSHIPS r, AHL_UNIT_CONFIG_HEADERS uch

2558:
2559: /*
2560: AND rel.parent_relationship_id IN
2561: ( SELECT r.relationship_id
2562: FROM AHL_MC_RELATIONSHIPS r, AHL_UNIT_CONFIG_HEADERS uch
2563: WHERE uch.csi_item_instance_id = p_parent_instance_id
2564: AND uch.master_config_id = r.mc_header_id
2565: --AND r.parent_relationship_id IS NULL
2566: --Jerry commented out the above condition on 01/14/2005 to fix bug 4090856