APPS.AHL_MC_PATH_POSITION_PVT dependencies on AHL_UC_HEADER_PATHS_V

Line 450: FROM ahl_uc_header_paths_v up

446: --
447: --Fetch the unit and unit header info for instance
448: CURSOR get_uc_headers_csr (p_csi_instance_id IN NUMBER) IS
449: SELECT up.parent_mc_id, up.parent_version_number, up.parent_position_key
450: FROM ahl_uc_header_paths_v up
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

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

817: CLOSE check_pos_key_top_csr;
818:
819:
820: v_Select := ' SELECT v'||l_path_tbl.LAST||'.csi_instance_id ';
821: v_From := ' FROM AHL_UC_HEADER_PATHS_V v0 ';
822: v_Where := ' WHERE v0.mc_id = :mc_id0 ' ||
823: ' AND v0.mc_version_number = nvl(:ver0,v0.mc_version_number) ';
824:
825: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

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

829: END IF;
830:
831: --Build the dynamic sql statement
832: FOR i IN l_path_tbl.FIRST+1..l_path_tbl.LAST LOOP
833: v_From := v_From || ', AHL_UC_HEADER_PATHS_V v'||TO_CHAR(i)||' ';
834:
835: -- R12 Dev changes : Modified Function Call to CHECK_POS_REF_PATH_CHAR and
836: -- modified where clause join between uc_header_id and parent_uc_header_id
837:

Line 856: ' FROM AHL_UC_HEADER_PATHS_V uch '||

852:
853: IF (l_top_flag) THEN
854: v_Stmt := 'INSERT INTO AHL_APPLICABLE_INSTANCES '||
855: ' SELECT uch.csi_instance_id ,'|| p_position_id ||
856: ' FROM AHL_UC_HEADER_PATHS_V uch '||
857: ' WHERE uch.position_key = :pos_key'||l_path_tbl.LAST
858: ||' AND uch.csi_instance_id in ( '
859: || v_Select || v_From || v_Where || ' ) ';
860:

Line 1035: FROM AHL_UC_HEADER_PATHS_V

1031: p_parent_pos_key IN NUMBER,
1032: p_child_mc_id IN NUMBER,
1033: p_child_mc_ver_num IN NUMBER) IS
1034: SELECT csi_instance_id
1035: FROM AHL_UC_HEADER_PATHS_V
1036: WHERE parent_instance_id = p_start_csi_ii_id
1037: AND parent_position_key = p_parent_pos_key
1038: AND mc_id = p_child_mc_id
1039: AND mc_version_number = nvl(p_child_mc_ver_num, mc_version_number);

Line 2197: FROM ahl_uc_header_paths_v

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
2196: SELECT parent_mc_id, parent_position_key
2197: FROM ahl_uc_header_paths_v
2198: WHERE uc_header_id = p_uc_header_id;
2199: --
2200: CURSOR get_rel_info_csr (p_rel_id IN VARCHAR2) IS
2201: SELECT a.mc_id, b.position_key

Line 2466: FROM ahl_uc_header_paths_v up

2462: --
2463: --Fetch the unit and unit header info for each instance
2464: CURSOR get_uc_headers_csr (p_csi_instance_id IN NUMBER) IS
2465: SELECT up.parent_mc_id, up.parent_version_number, up.parent_position_key
2466: FROM ahl_uc_header_paths_v up
2467: WHERE up.csi_instance_id = p_csi_instance_id;
2468: --
2469: --Traverse up and fetch all unit instance ids
2470: CURSOR get_unit_instance_csr (p_csi_instance_id IN NUMBER) IS