APPS.OZF_ACCRUAL_ENGINE dependencies on OE_ORDER_LINES_ALL

Line 2009: FROM oe_order_lines_all line, oe_order_headers_all header

2005:
2006: --Added for bug 7030415, get order's org_id
2007: CURSOR c_order_org_id (p_line_id IN NUMBER) IS
2008: SELECT header.org_id
2009: FROM oe_order_lines_all line, oe_order_headers_all header
2010: WHERE line_id = p_line_id
2011: AND line.header_id = header.header_id;
2012:
2013: CURSOR c_offer_type (p_offer_id IN NUMBER) IS

Line 2357: FROM oe_order_lines_all line, oe_order_headers_all header

2353: line.cancelled_quantity,
2354: line.line_category_code,
2355: header.transactional_curr_code,
2356: header.org_id
2357: FROM oe_order_lines_all line, oe_order_headers_all header
2358: WHERE line_id = p_line_id
2359: AND line.header_id = header.header_id;
2360:
2361: CURSOR c_list_line_info (p_list_line_id IN NUMBER) IS

Line 2374: FROM oe_order_lines_all

2370: AND object_type = 'ORDER';
2371:
2372: CURSOR c_order_count (p_header_id IN NUMBER) IS
2373: SELECT SUM (ordered_quantity - NVL (cancelled_quantity, 0))
2374: FROM oe_order_lines_all
2375: WHERE header_id = p_header_id;
2376:
2377: -- Added adjusted_amount for bug fix 4173825
2378: CURSOR c_mod_level (p_price_ad_id IN NUMBER) IS

Line 2418: FROM oe_order_lines_all

2414: AND price_adjustment_id IS NULL;
2415:
2416: CURSOR c_split_line(p_line_id IN NUMBER) IS
2417: SELECT line_id
2418: FROM oe_order_lines_all
2419: WHERE split_from_line_id IS NOT NULL
2420: AND line_id = p_line_id
2421: AND split_by = 'SYSTEM';
2422:

Line 3046: FROM oe_order_lines_all

3042:
3043:
3044: CURSOR c_actual_shipment_date(p_line_id IN NUMBER) IS
3045: SELECT actual_shipment_date
3046: FROM oe_order_lines_all
3047: WHERE line_id = p_line_id;
3048:
3049: CURSOR c_invoice_date(p_line_id IN NUMBER, p_order_number IN VARCHAR2) IS
3050: SELECT cust.trx_date -- transaction(invoice) date

Line 3060: FROM oe_order_lines_all

3056:
3057: -- add by feliu on 08/03/04, get split line id to use in create postivie adjustment.
3058: CURSOR c_split_line(p_line_id IN NUMBER) IS
3059: SELECT line_id
3060: FROM oe_order_lines_all
3061: WHERE split_from_line_id = p_line_id
3062: AND split_by = 'SYSTEM';
3063:
3064: -- add by feliu on 08/03/04, get price_adjustment_id to use in create postivie adjustment.

Line 3079: FROM oe_order_lines_all

3075: AND object_type = 'ORDER';
3076:
3077: CURSOR c_orig_order_info (p_line_id IN NUMBER) IS
3078: SELECT NVL(shipped_quantity,ordered_quantity)
3079: FROM oe_order_lines_all
3080: WHERE line_id =p_line_id;
3081:
3082: CURSOR c_orig_adjustment_amount (p_order_line_id IN NUMBER) IS
3083: SELECT plan_curr_amount, amount,

Line 3134: FROM oe_order_lines_all line, oe_order_headers_all header

3130: DECODE(line.line_category_code,'ORDER',NVL(line.shipped_quantity,0),
3131: 'RETURN', line.invoiced_quantity,
3132: line.ordered_quantity) shipped_quantity
3133:
3134: FROM oe_order_lines_all line, oe_order_headers_all header
3135: WHERE line.line_id = p_order_line_id
3136: AND line.header_id = header.header_id;
3137:
3138: