APPS.CSD_PROCESS_PVT dependencies on OE_ORDER_HEADERS_ALL

Line 1356: FROM oe_order_headers_all a

1352: CURSOR customer(p_ord_header_id IN NUMBER) IS
1353: SELECT a.sold_to_org_id,
1354: a.order_type_id,
1355: a.source_document_type_id
1356: FROM oe_order_headers_all a
1357: WHERE a.header_id = p_ord_header_id;
1358:
1359: CURSOR delivery(p_ord_header_id IN NUMBER, p_ord_line_id IN NUMBER) IS
1360: SELECT b.delivery_id,

Line 1387: FROM oe_order_headers_all

1383: AND a.organization_id = p.organization_id;
1384:
1385: CURSOR c_get_org_id (p_header_id IN NUMBER) IS
1386: SELECT org_id
1387: FROM oe_order_headers_all
1388: WHERE header_id = p_header_id;
1389:
1390: -- Variables used in FND Log
1391: l_error_level NUMBER := Fnd_Log.LEVEL_ERROR;

Line 2379: l_booked_flag oe_order_headers_all.booked_flag%TYPE;

2375: l_orig_src_header_id NUMBER;
2376: l_orig_src_line_id NUMBER;
2377: l_orig_po_num VARCHAR2(50);
2378: l_rev_ctl_code mtl_system_items.revision_qty_control_code%TYPE;
2379: l_booked_flag oe_order_headers_all.booked_flag%TYPE;
2380:
2381: --taklam
2382: l_Line_Tbl_Type OE_ORDER_PUB.Line_Tbl_Type;
2383: x_Line_Tbl_Type OE_ORDER_PUB.Line_Tbl_Type;

Line 3451: FROM oe_order_headers_all

3447:
3448: BEGIN
3449: SELECT booked_flag
3450: INTO l_booked_flag
3451: FROM oe_order_headers_all
3452: WHERE header_id = l_order_rec.order_header_id;
3453: EXCEPTION
3454: WHEN NO_DATA_FOUND THEN
3455: Debug('The Sales Order is booked OR does not exist',