APPS.CSD_LOGISTICS_UTIL dependencies on OE_ORDER_LINES_ALL

Line 2646: FROM oe_order_lines_all a, cs_estimate_details b

2642: WHERE project_id = l_project_id and inventory_organization_id = l_p_ship_from_org_id;
2643:
2644: CURSOR order_line_cu(l_est_detail_id NUMBER) is
2645: SELECT b.order_line_id, a.ship_from_org_id
2646: FROM oe_order_lines_all a, cs_estimate_details b
2647: WHERE a.line_id = b.order_line_id
2648: AND b.estimate_detail_id = l_est_detail_id;
2649:
2650: -- swai: bug 6001057

Line 2940: l_unit_selling_price oe_order_lines_all.unit_selling_price%TYPE;

2936: l_return_status VARCHAR2(1);
2937: l_order_line_id NUMBER;
2938: l_booked_flag VARCHAR2(1);
2939: l_ship_from_org_id NUMBER;
2940: l_unit_selling_price oe_order_lines_all.unit_selling_price%TYPE;
2941:
2942: l_msg_count NUMBER;
2943: l_msg_data VARCHAR2(2000);
2944: book_order EXCEPTION;

Line 2982: FROM oe_order_lines_all a, cs_estimate_details b

2978: a.booked_flag
2979: INTO px_order_rec.order_header_id,
2980: l_order_line_id,
2981: l_booked_flag
2982: FROM oe_order_lines_all a, cs_estimate_details b
2983: WHERE a.line_id = b.order_line_id
2984: AND b.estimate_detail_id = p_product_txn_rec.estimate_detail_id;
2985: EXCEPTION
2986: WHEN NO_DATA_FOUND THEN

Line 3025: FROM oe_order_lines_all

3021: SELECT ship_from_org_id, unit_selling_price, org_id
3022: INTO l_ship_from_org_id,
3023: l_unit_selling_price,
3024: px_order_rec.org_id
3025: FROM oe_order_lines_all
3026: WHERE line_id = l_order_line_id;
3027: EXCEPTION
3028: WHEN NO_DATA_FOUND THEN
3029: Fnd_Message.SET_NAME('CSD',

Line 3301: FROM oe_order_lines_all oel,

3297: /* Adding order_header_id and order_line_id in the select list
3298: for serial reservations change for R12, Vijay June 9th 2006 */
3299: SELECT ship_from_org_id, header_id, line_id
3300: INTO l_ship_from_org_id, l_order_header_id, l_order_line_id
3301: FROM oe_order_lines_all oel,
3302: cs_estimate_details ced
3303: WHERE oel.line_id = ced.order_line_id
3304: AND ced.estimate_detail_id =
3305: p_product_txn_rec.estimate_detail_id;

Line 3694: FROM oe_order_lines_all a,

3690: INTO px_order_rec.order_header_id,
3691: px_order_rec.order_line_id,
3692: px_order_rec.serial_number,
3693: px_order_rec.shipped_quantity
3694: FROM oe_order_lines_all a,
3695: cs_estimate_details b,
3696: CSD_PRODUCT_TRANSACTIONS c
3697: WHERE a.line_id = b.order_line_id
3698: AND b.estimate_detail_id = c.estimate_detail_id