APPS.AHL_PRD_DISP_UTIL_PVT dependencies on CS_INCIDENTS

Line 851: CS_INCIDENTS_ALL_VL INC, CS_INCIDENT_SEVERITIES_VL SEV,

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

Line 910: CS_INCIDENTS_ALL_B INC,

906: MTL_SYSTEM_ITEMS_KFV MTL,
907: CSI_ITEM_INSTANCES CSI,
908: AHL_ITEM_GROUPS_B GRP,
909: MTL_MATERIAL_STATUSES_TL COND,
910: CS_INCIDENTS_ALL_B INC,
911: CS_INCIDENTS_ALL_TL INCL,
912: CS_INCIDENT_SEVERITIES_TL SEV,
913: FND_LOOKUP_VALUES PCODE,
914: FND_LOOKUP_VALUES FND1,

Line 911: CS_INCIDENTS_ALL_TL INCL,

907: CSI_ITEM_INSTANCES CSI,
908: AHL_ITEM_GROUPS_B GRP,
909: MTL_MATERIAL_STATUSES_TL COND,
910: CS_INCIDENTS_ALL_B INC,
911: CS_INCIDENTS_ALL_TL INCL,
912: CS_INCIDENT_SEVERITIES_TL SEV,
913: FND_LOOKUP_VALUES PCODE,
914: FND_LOOKUP_VALUES FND1,
915: FND_LOOKUP_VALUES FND2,

Line 998: CS_INCIDENTS_ALL_VL INC,

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

Line 1052: CS_INCIDENTS_ALL_B INC,

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,
1056: MTL_SYSTEM_ITEMS_KFV MTL,

Line 1053: CS_INCIDENTS_ALL_TL INCL,

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,
1056: MTL_SYSTEM_ITEMS_KFV MTL,
1057: CSI_ITEM_INSTANCES CSI,

Line 1143: CS_INCIDENTS_ALL_VL INC,

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
1147: AND pp.path_position_id = p_path_position_id

Line 1207: CS_INCIDENTS_ALL_B INC,

1203: MTL_MATERIAL_STATUSES_TL COND,
1204: AHL_ITEM_GROUPS_B GRP,
1205: MTL_SYSTEM_ITEMS_KFV MTL,
1206: CSI_ITEM_INSTANCES CSI,
1207: CS_INCIDENTS_ALL_B INC,
1208: CS_INCIDENTS_ALL_TL INCL,
1209: CS_INCIDENT_SEVERITIES_TL SEV,
1210: FND_LOOKUP_VALUES PCODE,
1211: AHL_PART_CHANGES_V PC

Line 1208: CS_INCIDENTS_ALL_TL INCL,

1204: AHL_ITEM_GROUPS_B GRP,
1205: MTL_SYSTEM_ITEMS_KFV MTL,
1206: CSI_ITEM_INSTANCES CSI,
1207: CS_INCIDENTS_ALL_B INC,
1208: CS_INCIDENTS_ALL_TL INCL,
1209: CS_INCIDENT_SEVERITIES_TL SEV,
1210: FND_LOOKUP_VALUES PCODE,
1211: AHL_PART_CHANGES_V PC
1212: WHERE pp.path_pos_common_id IN (

Line 1294: FROM AHL_PRD_DISPOSITIONS_V disp, CS_INCIDENTS_ALL_VL INC,

1290: SEV.NAME SEVERITY_NAME,
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'))

Line 2310: from cs_incidents

2306: END;
2307:
2308: BEGIN
2309: select 1 INTO l_dummy_num
2310: from cs_incidents
2311: where incident_id = p_service_request_id;
2312: EXCEPTION
2313: WHEN NO_DATA_FOUND THEN
2314: fnd_message.set_name('AHL','AHL_UC_API_PARAMETER_INVALID');