APPS.CSD_REPAIR_ESTIMATE_PVT dependencies on CS_ESTIMATE_DETAILS

Line 153: FROM cs_estimate_details

149: THEN
150: BEGIN
151: SELECT business_process_id
152: INTO x_Charges_Rec.business_process_id
153: FROM cs_estimate_details
154: WHERE estimate_detail_id =
155: x_Charges_Rec.estimate_detail_id;
156: EXCEPTION
157: WHEN NO_DATA_FOUND THEN

Line 2103: FROM cs_estimate_details

2099:
2100: BEGIN
2101: SELECT business_process_id
2102: INTO l_bus_process_id
2103: FROM cs_estimate_details
2104: WHERE estimate_detail_id = l_est_detail_id
2105: AND order_header_id IS NULL;
2106: l_upd_charge_flag := 'Y';
2107: EXCEPTION

Line 2415: FROM CSD_REPAIR_ESTIMATE_LINES a, cs_estimate_details b

2411: -- only if it is not interfaced
2412: BEGIN
2413: SELECT a.estimate_detail_id
2414: INTO l_est_detail_id
2415: FROM CSD_REPAIR_ESTIMATE_LINES a, cs_estimate_details b
2416: WHERE a.estimate_detail_id = b.estimate_detail_id
2417: AND a.repair_estimate_line_id = p_estimate_line_id
2418: AND b.order_header_id IS NULL;
2419: l_delete_allow := 'Y';

Line 2818: cs_estimate_details ced

2814: CURSOR ESTIMATE(p_rep_line_id IN NUMBER) IS
2815: SELECT ced.estimate_detail_id, ced.purchase_order_num
2816: FROM CSD_REPAIR_ESTIMATE cre,
2817: CSD_REPAIR_ESTIMATE_LINES crel,
2818: cs_estimate_details ced
2819: WHERE cre.repair_line_id = p_rep_line_id
2820: AND cre.repair_estimate_id = crel.repair_estimate_id
2821: AND crel.estimate_detail_id = ced.estimate_detail_id
2822: AND ced.order_header_id IS NULL

Line 2889: cs_estimate_details ced,

2885: BEGIN
2886: SELECT MAX(ced.order_header_id)
2887: INTO l_order_header_id
2888: FROM CSD_PRODUCT_TRANSACTIONS cpt,
2889: cs_estimate_details ced,
2890: oe_order_headers_all ooh,
2891: oe_order_types_v oot
2892: WHERE ooh.order_type_id = oot.order_type_id
2893: AND ooh.header_id = ced.order_header_id

Line 2942: cs_estimate_details ced

2938: BEGIN
2939: SELECT ced.purchase_order_num
2940: INTO l_orig_po_num
2941: FROM CSD_PRODUCT_TRANSACTIONS cpt,
2942: cs_estimate_details ced
2943: WHERE cpt.estimate_detail_id =
2944: ced.estimate_detail_id
2945: AND cpt.repair_line_id = p_repair_line_id
2946: AND ced.order_header_id =

Line 3028: FROM oe_order_headers_all oe, cs_estimate_details ced

3024:
3025: BEGIN
3026: SELECT oe.order_number
3027: INTO l_order_number
3028: FROM oe_order_headers_all oe, cs_estimate_details ced
3029: WHERE oe.header_id = ced.order_header_id
3030: AND ced.estimate_detail_id = l_last_est_detail_id;
3031: Fnd_Message.SET_NAME('CSD', 'CSD_EST_ORDER_NUMBER');
3032: Fnd_Message.SET_TOKEN('ORDER_NUMBER', l_order_number);