DBA Data[Home] [Help]

APPS.CSD_DEPOT_REPAIR_CNTR dependencies on CS_ESTIMATE_DETAILS

Line 40: FROM cs_estimate_details a,

36: INTO x_txn_billing_type_id,
37: x_repair_number ,
38: x_repair_line_id,
39: x_quantity
40: FROM cs_estimate_details a,
41: csd_repairs b
42: WHERE ((a.original_source_id = b.repair_line_id
43: AND a.original_source_code = 'DR') OR
44: (a.source_id = b.repair_line_id

Line 72: csd_gen_utility_pvt.add('Found more than one row in cs_estimate_details for line_id ='||TO_CHAR(p_line_id));

68: END;
69:
70: WHEN OTHERS THEN
71: IF (g_debug > 0 ) THEN
72: csd_gen_utility_pvt.add('Found more than one row in cs_estimate_details for line_id ='||TO_CHAR(p_line_id));
73: END IF;
74:
75: l_quit_flag := TRUE;
76: END;

Line 197: cs_estimate_details ced

193: AND event_code='RR'
194: AND cra.repair_line_id = nvl(p_repair_line_id,cra.repair_line_id)) -- travi 020903 change
195: AND EXISTS (SELECT ced.order_header_id
196: FROM csd_repairs cra,
197: cs_estimate_details ced
198: WHERE ((cra.repair_line_id = ced.original_source_id
199: AND ced.original_source_code = 'DR') OR
200: (cra.repair_line_id = ced.source_id
201: AND ced.source_code = 'DR'))

Line 1155: cs_estimate_Details ced,

1151: wsh_delivery_details dd ,
1152: oe_order_headers_all oeh,
1153: oe_order_lines_all oel,
1154: csd_Repairs cra,
1155: cs_estimate_Details ced,
1156: mtl_units_of_measure mtlu
1157: Where ((cra.repair_line_id = ced.original_source_id
1158: and ced.original_source_code = 'DR') OR
1159: (cra.repair_line_id = ced.source_id