APPS.CSD_BULK_RECEIVE_UTIL dependencies on CSD_REPAIR_TYPES_B

Line 962: from csd_repair_types_b

958: Cursor c_get_repair_type_attr(p_repair_type_id number) is
959: Select price_list_header_id,
960: repair_mode,
961: business_process_id
962: from csd_repair_types_b
963: where repair_type_id = p_repair_type_id;
964:
965: -- Cursor to get IB details
966: Cursor c_get_ib_info ( p_inventory_item_id in Number,p_serial_number in Varchar2) is

Line 2627: ' from cs_incidents_all_b sr,csd_repairs cr,csd_repair_types_b crt '||

2623: l_no_exact_match varchar2(3) := 'N';
2624:
2625:
2626: lc_sql_string_ro varchar2(2000) :=' select sr.incident_id,cr.repair_line_id,cr.quantity,''N'',''N''' ||
2627: ' from cs_incidents_all_b sr,csd_repairs cr,csd_repair_types_b crt '||
2628: ' where cr.inventory_item_id = :p_inv_item_id '||
2629: ' and cr.status = ''O'' '||
2630: ' and cr.incident_id = sr.incident_id '||
2631: ' and sr.account_id = :p_acc_id '||

Line 3054: csd_repair_types_b crtb

3050: from csd_product_transactions cpt,
3051: cs_estimate_details ced,
3052: oe_order_lines_all ool,
3053: csd_repairs cr,
3054: csd_repair_types_b crtb
3055: where
3056: cpt.repair_line_id = p_repair_line_id and
3057: cpt.action_type = 'RMA' and
3058: crtb.repair_type_id = cr.repair_type_id and