DBA Data[Home] [Help]

APPS.AHL_PRD_BLK_PARTS_CHANGE_PVT dependencies on AHL_PRD_DISPOSITIONS_V

Line 476: FROM AHL_PRD_DISPOSITIONS_V disp,

472: nr.duration,
473: nr.sr_incident_severity,
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

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'