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 2947: l_unit_selling_price oe_order_lines_all.unit_selling_price%TYPE;

2943: l_return_status VARCHAR2(1);
2944: l_order_line_id NUMBER;
2945: l_booked_flag VARCHAR2(1);
2946: l_ship_from_org_id NUMBER;
2947: l_unit_selling_price oe_order_lines_all.unit_selling_price%TYPE;
2948:
2949: l_msg_count NUMBER;
2950: l_msg_data VARCHAR2(2000);
2951: book_order EXCEPTION;

Line 2989: FROM oe_order_lines_all a, cs_estimate_details b

2985: a.booked_flag
2986: INTO px_order_rec.order_header_id,
2987: l_order_line_id,
2988: l_booked_flag
2989: FROM oe_order_lines_all a, cs_estimate_details b
2990: WHERE a.line_id = b.order_line_id
2991: AND b.estimate_detail_id = p_product_txn_rec.estimate_detail_id;
2992: EXCEPTION
2993: WHEN NO_DATA_FOUND THEN

Line 3032: FROM oe_order_lines_all

3028: SELECT ship_from_org_id, unit_selling_price, org_id
3029: INTO l_ship_from_org_id,
3030: l_unit_selling_price,
3031: px_order_rec.org_id
3032: FROM oe_order_lines_all
3033: WHERE line_id = l_order_line_id;
3034: EXCEPTION
3035: WHEN NO_DATA_FOUND THEN
3036: Fnd_Message.SET_NAME('CSD',

Line 3315: FROM oe_order_lines_all oel,

3311: /* Adding order_header_id and order_line_id in the select list
3312: for serial reservations change for R12, Vijay June 9th 2006 */
3313: SELECT ship_from_org_id, header_id, line_id
3314: INTO l_ship_from_org_id, l_order_header_id, l_order_line_id
3315: FROM oe_order_lines_all oel,
3316: cs_estimate_details ced
3317: WHERE oel.line_id = ced.order_line_id
3318: AND ced.estimate_detail_id =
3319: p_product_txn_rec.estimate_detail_id;

Line 3708: FROM oe_order_lines_all a,

3704: INTO px_order_rec.order_header_id,
3705: px_order_rec.order_line_id,
3706: px_order_rec.serial_number,
3707: px_order_rec.shipped_quantity
3708: FROM oe_order_lines_all a,
3709: cs_estimate_details b,
3710: CSD_PRODUCT_TRANSACTIONS c
3711: WHERE a.line_id = b.order_line_id
3712: AND b.estimate_detail_id = c.estimate_detail_id