APPS.CSD_PROCESS_PVT dependencies on OE_ORDER_HEADERS_ALL

Line 1319: FROM oe_order_headers_all a

1315: CURSOR customer(p_ord_header_id IN NUMBER) IS
1316: SELECT a.sold_to_org_id,
1317: a.order_type_id,
1318: a.source_document_type_id
1319: FROM oe_order_headers_all a
1320: WHERE a.header_id = p_ord_header_id;
1321:
1322: CURSOR delivery(p_ord_header_id IN NUMBER, p_ord_line_id IN NUMBER) IS
1323: SELECT b.delivery_id,

Line 1350: FROM oe_order_headers_all

1346: AND a.organization_id = p.organization_id;
1347:
1348: CURSOR c_get_org_id (p_header_id IN NUMBER) IS
1349: SELECT org_id
1350: FROM oe_order_headers_all
1351: WHERE header_id = p_header_id;
1352:
1353: -- Variables used in FND Log
1354: l_error_level NUMBER := Fnd_Log.LEVEL_ERROR;

Line 2296: l_booked_flag oe_order_headers_all.booked_flag%TYPE;

2292: l_orig_src_header_id NUMBER;
2293: l_orig_src_line_id NUMBER;
2294: l_orig_po_num VARCHAR2(50);
2295: l_rev_ctl_code mtl_system_items.revision_qty_control_code%TYPE;
2296: l_booked_flag oe_order_headers_all.booked_flag%TYPE;
2297:
2298: --taklam
2299: l_Line_Tbl_Type OE_ORDER_PUB.Line_Tbl_Type;
2300: x_Line_Tbl_Type OE_ORDER_PUB.Line_Tbl_Type;

Line 3362: FROM oe_order_headers_all

3358:
3359: BEGIN
3360: SELECT booked_flag
3361: INTO l_booked_flag
3362: FROM oe_order_headers_all
3363: WHERE header_id = l_order_rec.order_header_id;
3364: EXCEPTION
3365: WHEN NO_DATA_FOUND THEN
3366: Debug('The Sales Order is booked OR does not exist',