696: null status_code
697: from
698: csd_repairs dra,
699: ORG_ORGANIZATION_DEFINITIONS orgd,
700: cs_incidents_all_b inc
701: where
702: dra.incident_id = inc.incident_id and
703: orgd.organization_id(+) = inc.inv_organization_id and
704: inc.incident_id = decode(p_incident_id,
988: 'SR_TASK' document_type,
989: tsk.task_status_id status_id,
990: null status_code
991: from cs_sr_tasks_v tsk,
992: cs_incidents_all_b inc,
993: ORG_ORGANIZATION_DEFINITIONS orgd,
994: csd_repairs dra
995: where
996: tsk.source_object_type_code = 'SR' and