APPS.AHL_PRD_BLK_PARTS_CHANGE_PVT dependencies on AHL_SR_NON_ROUTINES_V

Line 478: AHL_SR_NON_ROUTINES_V nr

474: nr.sr_incident_severity_id,
475: nr.sr_incident_id
476: FROM AHL_PRD_DISPOSITIONS_V disp,
477: AHL_MC_PATH_POSITIONS pp,
478: AHL_SR_NON_ROUTINES_V nr
479: WHERE disp.path_pos_common_id = pp.path_pos_common_id
480: AND pp.path_position_id = c_path_position_id
481: AND disp.part_change_id IS NULL
482: AND disp.workorder_id = p_workorder_id

Line 522: FROM AHL_PRD_DISPOSITIONS_V disp,AHL_SR_NON_ROUTINES_V nr

518: nr.duration,
519: nr.sr_incident_severity,
520: nr.sr_incident_severity_id,
521: nr.sr_incident_id
522: FROM AHL_PRD_DISPOSITIONS_V disp,AHL_SR_NON_ROUTINES_V nr
523: WHERE disp.path_position_id IS NULL
524: AND disp.part_change_id IS NULL
525: AND disp.workorder_id = p_workorder_id
526: AND NVL(disp.immediate_disposition_code,'NULL') <> 'NOT_RECEIVED'

Line 555: FROM AHL_SR_NON_ROUTINES_V nr

551: nr.service_type,
552: nr.duration,
553: nr.sr_incident_severity,
554: nr.sr_incident_severity_id
555: FROM AHL_SR_NON_ROUTINES_V nr
556: WHERE nr.SR_INCIDENT_ID = c_sr_incident_id;
557:
558: -- Cursor to get MC details for the given MC relationship id
559: CURSOR get_mc_details_csr (c_relationship_id NUMBER) IS