APPS.AHL_MC_PATH_POSITION_PVT dependencies on AHL_UC_HEADER_PATHS_V

Line 441: FROM ahl_uc_header_paths_v up

437: --
438: --Fetch the unit and unit header info for instance
439: CURSOR get_uc_headers_csr (p_csi_instance_id IN NUMBER) IS
440: SELECT up.parent_mc_id, up.parent_version_number, up.parent_position_key
441: FROM ahl_uc_header_paths_v up
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

Line 767: v_From := ' FROM AHL_UC_HEADER_PATHS_V v0 ';

763: CLOSE check_pos_key_top_csr;
764:
765:
766: v_Select := ' SELECT v'||l_path_tbl.LAST||'.csi_instance_id ';
767: v_From := ' FROM AHL_UC_HEADER_PATHS_V v0 ';
768: v_Where := ' WHERE v0.mc_id = :mc_id0 ' ||
769: ' AND v0.mc_version_number = nvl(:ver0,v0.mc_version_number) ';
770:
771: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

Line 779: v_From := v_From || ', AHL_UC_HEADER_PATHS_V v'||TO_CHAR(i)||' ';

775: END IF;
776:
777: --Build the dynamic sql statement
778: FOR i IN l_path_tbl.FIRST+1..l_path_tbl.LAST LOOP
779: v_From := v_From || ', AHL_UC_HEADER_PATHS_V v'||TO_CHAR(i)||' ';
780:
781: -- R12 Dev changes : Modified Function Call to CHECK_POS_REF_PATH_CHAR and
782: -- modified where clause join between uc_header_id and parent_uc_header_id
783:

Line 802: ' FROM AHL_UC_HEADER_PATHS_V uch '||

798:
799: IF (l_top_flag) THEN
800: v_Stmt := 'INSERT INTO AHL_APPLICABLE_INSTANCES '||
801: ' SELECT uch.csi_instance_id ,'|| p_position_id ||
802: ' FROM AHL_UC_HEADER_PATHS_V uch '||
803: ' WHERE uch.position_key = :pos_key'||l_path_tbl.LAST
804: ||' AND uch.csi_instance_id in ( '
805: || v_Select || v_From || v_Where || ' ) ';
806:

Line 977: FROM AHL_UC_HEADER_PATHS_V

973: p_parent_pos_key IN NUMBER,
974: p_child_mc_id IN NUMBER,
975: p_child_mc_ver_num IN NUMBER) IS
976: SELECT csi_instance_id
977: FROM AHL_UC_HEADER_PATHS_V
978: WHERE parent_instance_id = p_start_csi_ii_id
979: AND parent_position_key = p_parent_pos_key
980: AND mc_id = p_child_mc_id
981: AND mc_version_number = nvl(p_child_mc_ver_num, mc_version_number);

Line 2139: FROM ahl_uc_header_paths_v

2135: CONNECT BY PRIOR parent_uc_header_id = unit_config_header_id;
2136: --
2137: CURSOR get_header_details_csr (p_uc_header_id IN NUMBER) IS
2138: SELECT parent_mc_id, parent_position_key
2139: FROM ahl_uc_header_paths_v
2140: WHERE uc_header_id = p_uc_header_id;
2141: --
2142: CURSOR get_rel_info_csr (p_rel_id IN VARCHAR2) IS
2143: SELECT a.mc_id, b.position_key

Line 2408: FROM ahl_uc_header_paths_v up

2404: --
2405: --Fetch the unit and unit header info for each instance
2406: CURSOR get_uc_headers_csr (p_csi_instance_id IN NUMBER) IS
2407: SELECT up.parent_mc_id, up.parent_version_number, up.parent_position_key
2408: FROM ahl_uc_header_paths_v up
2409: WHERE up.csi_instance_id = p_csi_instance_id;
2410: --
2411: --Traverse up and fetch all unit instance ids
2412: CURSOR get_unit_instance_csr (p_csi_instance_id IN NUMBER) IS