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 853: FROM csd_product_txns_v cptv, csd_repair_types_vl crtv, mtl_system_items_vl msiv

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

Line 865: FROM csd_repairs_v crv, csd_repair_types_vl crtv

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

Line 1787: csd_repair_types_vl crt

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