APPS.CSD_SPLIT_PKG dependencies on CSD_REPAIR_TYPES_VL

Line 57: from csd_repair_types_vl crtv, csd_repairs cr

53: l_msg_data VARCHAR2 (2000);
54:
55: CURSOR c_repair_type_name(p_original_repair_line_id IN NUMBER) IS
56: SELECT crtv.name
57: from csd_repair_types_vl crtv, csd_repairs cr
58: where cr.repair_line_id = p_original_repair_line_id and crtv.repair_type_id = cr.repair_type_id;
59:
60: Begin
61:

Line 855: FROM csd_product_txns_v cptv, csd_repair_types_vl crtv, mtl_system_items_vl msiv

851:
852: CURSOR c_rma_product_txn_line_info(p_repair_line_id IN NUMBER) IS
853: SELECT cptv.action_type, cptv.interface_to_om_flag, cptv.repair_quantity, cptv.quantity_in_wip, cptv.quantity_rcvd, cptv.status,
854: cptv.serial_number_control_code, crtv.repair_type_ref, msiv.comms_nl_trackable_flag, crtv.repair_mode
855: FROM csd_product_txns_v cptv, csd_repair_types_vl crtv, mtl_system_items_vl msiv
856: WHERE repair_line_id = p_repair_line_id and crtv.repair_type_id = cptv.repair_type_id and action_type = 'RMA'
857: and msiv.inventory_item_id = cptv.inventory_item_id and msiv.organization_id = cs_std.get_item_valdn_orgzn_id;
858:
859:

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(*)

Line 1789: csd_repair_types_vl crt

1785: cr.project_id,
1786: cr.task_id,
1787: cr.unit_number
1788: FROM csd_repairs cr,
1789: csd_repair_types_vl crt
1790: WHERE cr.repair_type_id = crt.repair_type_id
1791: and cr.repair_line_id = p_rep_line_id;
1792:
1793: CURSOR get_revision(p_inv_item_id IN NUMBER,