APPS.AHL_PRD_DISP_UTIL_PVT dependencies on FND_LOOKUP_VALUES_VL

Line 852: FND_LOOKUP_VALUES_VL PCODE

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
855: AND disp.part_change_id IS NULL
856: AND disp.workorder_id = p_workorder_id

Line 999: CS_INCIDENT_SEVERITIES_VL SEV, FND_LOOKUP_VALUES_VL PCODE

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
1002: AND disp.part_change_id IS NULL
1003: AND disp.workorder_id = p_workorder_id

Line 1144: CS_INCIDENT_SEVERITIES_VL SEV, FND_LOOKUP_VALUES_VL PCODE,

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
1147: AND pp.path_position_id = p_path_position_id
1148: AND disp.part_change_id IS NOT NULL

Line 1295: CS_INCIDENT_SEVERITIES_VL SEV, FND_LOOKUP_VALUES_VL PCODE

1291: INC.PROBLEM_CODE,
1292: PCODE.MEANING PROBLEM_MEANING,
1293: INC.SUMMARY
1294: FROM AHL_PRD_DISPOSITIONS_V disp, CS_INCIDENTS_ALL_VL INC,
1295: CS_INCIDENT_SEVERITIES_VL SEV, FND_LOOKUP_VALUES_VL PCODE
1296: WHERE disp.workorder_id = p_workorder_id
1297: AND disp.instance_id = p_instance_id
1298: AND (disp.status_code NOT IN ('COMPLETE', 'TERMINATED'))
1299: AND disp.part_change_id IS NULL