DBA Data[Home] [Help]

APPS.CSD_SPLIT_PKG dependencies on CSD_REPAIRS_V

Line 867: FROM csd_repairs_v crv, csd_repair_types_vl crtv

863: WHERE repair_line_id = p_repair_line_id and action_type = 'SHIP';
864:
865: CURSOR c_repair_type_ref(p_repair_line_id IN NUMBER) IS
866: SELECT crtv.repair_type_ref
867: FROM csd_repairs_v crv, csd_repair_types_vl crtv
868: WHERE repair_line_id = p_repair_line_id and crv.repair_type_id = crtv.repair_type_id;
869:
870: CURSOR c_wip_job(p_repair_line_id IN NUMBER) IS
871: SELECT count(*)