APPS.AHL_PRD_DISP_UTIL_PVT dependencies on AHL_MC_PATH_POSITIONS

Line 253: FROM ahl_mc_path_positions

249: --triggered by LOV, and the search is based on the id instead of value. Also the search uses
250: --only the version neutral common id even if the user uses the version specific path position id.
251: IF (p_disp_filter_rec.path_position_ref IS NOT NULL AND p_disp_filter_rec.path_position_id IS NOT NULL) THEN
252: SELECT path_pos_common_id INTO l_path_pos_common_id
253: FROM ahl_mc_path_positions
254: WHERE path_position_id = p_disp_filter_rec.path_position_id;
255: END IF;
256:
257: /* This is an API for search page, so the value to id conversion is really not necessary

Line 850: FROM AHL_PRD_DISPOSITIONS_V disp, AHL_MC_PATH_POSITIONS pp,

846: SEV.NAME SEVERITY_NAME,
847: INC.PROBLEM_CODE,
848: PCODE.MEANING PROBLEM_MEANING,
849: INC.SUMMARY
850: FROM AHL_PRD_DISPOSITIONS_V disp, AHL_MC_PATH_POSITIONS pp,
851: CS_INCIDENTS_ALL_VL INC, CS_INCIDENT_SEVERITIES_VL SEV,
852: FND_LOOKUP_VALUES_VL PCODE
853: WHERE disp.path_pos_common_id = pp.path_pos_common_id
854: AND pp.path_position_id = p_path_position_id

Line 905: AHL_MC_PATH_POSITIONS pp,

901: PCODE.MEANING PROBLEM_MEANING,
902: INCL.SUMMARY
903: FROM AHL_PRD_DISPOSITIONS_b disp,
904: AHL_PRD_DISPOSITIONS_tl displ,
905: AHL_MC_PATH_POSITIONS pp,
906: MTL_SYSTEM_ITEMS_KFV MTL,
907: CSI_ITEM_INSTANCES CSI,
908: AHL_ITEM_GROUPS_B GRP,
909: MTL_MATERIAL_STATUSES_TL COND,

Line 919: FROM AHL_MC_PATH_POSITIONS

915: FND_LOOKUP_VALUES FND2,
916: FND_LOOKUP_VALUES FND3
917: WHERE pp.path_pos_common_id IN (
918: SELECT PATH_POS_COMMON_ID
919: FROM AHL_MC_PATH_POSITIONS
920: WHERE PATH_POSITION_ID = p_path_position_id
921: )
922: AND disp.path_position_id = pp.path_position_id
923: AND disp.workorder_id =p_workorder_id

Line 997: FROM AHL_PRD_DISPOSITIONS_V disp, AHL_MC_PATH_POSITIONS pp,

993: SEV.NAME SEVERITY_NAME,
994: INC.PROBLEM_CODE,
995: PCODE.MEANING PROBLEM_MEANING,
996: INC.SUMMARY
997: FROM AHL_PRD_DISPOSITIONS_V disp, AHL_MC_PATH_POSITIONS pp,
998: CS_INCIDENTS_ALL_VL INC,
999: CS_INCIDENT_SEVERITIES_VL SEV, FND_LOOKUP_VALUES_VL PCODE
1000: WHERE disp.path_pos_common_id =pp.path_pos_common_id
1001: AND pp.path_position_id = p_path_position_id

Line 1051: AHL_MC_PATH_POSITIONS pp,

1047: PCODE.MEANING PROBLEM_MEANING,
1048: INCL.SUMMARY
1049: FROM AHL_PRD_DISPOSITIONS_b disp,
1050: AHL_PRD_DISPOSITIONS_tl displ,
1051: AHL_MC_PATH_POSITIONS pp,
1052: CS_INCIDENTS_ALL_B INC,
1053: CS_INCIDENTS_ALL_TL INCL,
1054: CS_INCIDENT_SEVERITIES_TL SEV,
1055: FND_LOOKUP_VALUES PCODE,

Line 1065: FROM AHL_MC_PATH_POSITIONS

1061: FND_LOOKUP_VALUES FND2,
1062: FND_LOOKUP_VALUES FND3
1063: WHERE pp.path_pos_common_id IN (
1064: SELECT PATH_POS_COMMON_ID
1065: FROM AHL_MC_PATH_POSITIONS
1066: WHERE PATH_POSITION_ID = p_path_position_id
1067: )
1068: AND disp.path_position_id = pp.path_position_id
1069: AND disp.part_change_id IS NULL

Line 1142: FROM AHL_PRD_DISPOSITIONS_V disp, AHL_MC_PATH_POSITIONS pp,

1138: SEV.NAME SEVERITY_NAME,
1139: INC.PROBLEM_CODE,
1140: PCODE.MEANING PROBLEM_MEANING,
1141: INC.SUMMARY
1142: FROM AHL_PRD_DISPOSITIONS_V disp, AHL_MC_PATH_POSITIONS pp,
1143: CS_INCIDENTS_ALL_VL INC,
1144: CS_INCIDENT_SEVERITIES_VL SEV, FND_LOOKUP_VALUES_VL PCODE,
1145: AHL_PART_CHANGES_V PC
1146: WHERE disp.path_pos_common_id =pp.path_pos_common_id

Line 1199: AHL_MC_PATH_POSITIONS pp,

1195: PCODE.MEANING PROBLEM_MEANING,
1196: INCL.SUMMARY
1197: FROM AHL_PRD_DISPOSITIONS_b disp,
1198: AHL_PRD_DISPOSITIONS_tl displ,
1199: AHL_MC_PATH_POSITIONS pp,
1200: FND_LOOKUP_VALUES FND1,
1201: FND_LOOKUP_VALUES FND2,
1202: FND_LOOKUP_VALUES FND3,
1203: MTL_MATERIAL_STATUSES_TL COND,

Line 1214: FROM AHL_MC_PATH_POSITIONS

1210: FND_LOOKUP_VALUES PCODE,
1211: AHL_PART_CHANGES_V PC
1212: WHERE pp.path_pos_common_id IN (
1213: SELECT PATH_POS_COMMON_ID
1214: FROM AHL_MC_PATH_POSITIONS
1215: WHERE PATH_POSITION_ID = p_path_position_id
1216: )
1217: AND disp.path_position_id = pp.path_position_id
1218: AND disp.disposition_id = displ.disposition_id