APPS.CSD_REPAIR_ESTIMATE_PVT dependencies on CS_ESTIMATE_DETAILS

Line 164: FROM cs_estimate_details

160: THEN
161: BEGIN
162: SELECT business_process_id
163: INTO x_Charges_Rec.business_process_id
164: FROM cs_estimate_details
165: WHERE estimate_detail_id =
166: x_Charges_Rec.estimate_detail_id;
167: EXCEPTION
168: WHEN NO_DATA_FOUND THEN

Line 2114: FROM cs_estimate_details

2110:
2111: BEGIN
2112: SELECT business_process_id
2113: INTO l_bus_process_id
2114: FROM cs_estimate_details
2115: WHERE estimate_detail_id = l_est_detail_id
2116: AND order_header_id IS NULL;
2117: l_upd_charge_flag := 'Y';
2118: EXCEPTION

Line 2426: FROM CSD_REPAIR_ESTIMATE_LINES a, cs_estimate_details b

2422: -- only if it is not interfaced
2423: BEGIN
2424: SELECT a.estimate_detail_id
2425: INTO l_est_detail_id
2426: FROM CSD_REPAIR_ESTIMATE_LINES a, cs_estimate_details b
2427: WHERE a.estimate_detail_id = b.estimate_detail_id
2428: AND a.repair_estimate_line_id = p_estimate_line_id
2429: AND b.order_header_id IS NULL;
2430: l_delete_allow := 'Y';

Line 2829: cs_estimate_details ced

2825: CURSOR ESTIMATE(p_rep_line_id IN NUMBER) IS
2826: SELECT ced.estimate_detail_id, ced.purchase_order_num
2827: FROM CSD_REPAIR_ESTIMATE cre,
2828: CSD_REPAIR_ESTIMATE_LINES crel,
2829: cs_estimate_details ced
2830: WHERE cre.repair_line_id = p_rep_line_id
2831: AND cre.repair_estimate_id = crel.repair_estimate_id
2832: AND crel.estimate_detail_id = ced.estimate_detail_id
2833: AND ced.order_header_id IS NULL

Line 2900: cs_estimate_details ced,

2896: BEGIN
2897: SELECT MAX(ced.order_header_id)
2898: INTO l_order_header_id
2899: FROM CSD_PRODUCT_TRANSACTIONS cpt,
2900: cs_estimate_details ced,
2901: oe_order_headers_all ooh,
2902: oe_order_types_v oot
2903: WHERE ooh.order_type_id = oot.order_type_id
2904: AND ooh.header_id = ced.order_header_id

Line 2953: cs_estimate_details ced

2949: BEGIN
2950: SELECT ced.purchase_order_num
2951: INTO l_orig_po_num
2952: FROM CSD_PRODUCT_TRANSACTIONS cpt,
2953: cs_estimate_details ced
2954: WHERE cpt.estimate_detail_id =
2955: ced.estimate_detail_id
2956: AND cpt.repair_line_id = p_repair_line_id
2957: AND ced.order_header_id =

Line 3039: FROM oe_order_headers_all oe, cs_estimate_details ced

3035:
3036: BEGIN
3037: SELECT oe.order_number
3038: INTO l_order_number
3039: FROM oe_order_headers_all oe, cs_estimate_details ced
3040: WHERE oe.header_id = ced.order_header_id
3041: AND ced.estimate_detail_id = l_last_est_detail_id;
3042: Fnd_Message.SET_NAME('CSD', 'CSD_EST_ORDER_NUMBER');
3043: Fnd_Message.SET_TOKEN('ORDER_NUMBER', l_order_number);