APPS.WMS_WAVE_PLANNING_PVT dependencies on OE_ORDER_LINES_ALL

Line 530: FROM OE_ORDER_HEADERS_ALL H, OE_ORDER_LINES_ALL L

526:
527: --
528: SELECT SUM(NVL(L.ORDERED_QUANTITY, 0) * NVL(L.UNIT_SELLING_PRICE, 0))
529: INTO l_order_value
530: FROM OE_ORDER_HEADERS_ALL H, OE_ORDER_LINES_ALL L
531: WHERE H.HEADER_ID = p_header_id
532: and l.line_id = p_line_id
533: AND L.HEADER_ID = H.HEADER_ID;
534:

Line 2911: FROM OE_ORDER_LINES_ALL

2907: g_troline_table(i).top_model_line_id := l_top_model_line_id;
2908: IF (l_top_model_line_id <> NVL(l_last_top_model_line_id, -99)) THEN
2909: SELECT ORDERED_QUANTITY, ORDER_QUANTITY_UOM
2910: into l_ordered_quantity, l_order_quantity_uom
2911: FROM OE_ORDER_LINES_ALL
2912: WHERE LINE_ID = l_top_model_line_id;
2913:
2914: g_troline_table(i).top_model_quantity := l_ordered_quantity;
2915: l_last_model_quantity := l_ordered_quantity;

Line 4213: FROM OE_ORDER_LINES_ALL

4209:
4210: BEGIN
4211: SELECT ordered_quantity, order_quantity_uom
4212: INTO l_cur_txn_source_req_qty, l_txn_source_line_uom
4213: FROM OE_ORDER_LINES_ALL
4214: WHERE line_id = l_cur_txn_source_line_id;
4215: EXCEPTION
4216: WHEN NO_DATA_FOUND then
4217: print_debug('No Order Line Quantity found', l_debug);

Line 4264: FROM OE_ORDER_LINES_ALL

4260: ELSE
4261: BEGIN
4262: SELECT ordered_quantity, order_quantity_uom
4263: INTO l_set_txn_source_req_qty, l_txn_source_line_uom
4264: FROM OE_ORDER_LINES_ALL
4265: WHERE line_id = l_set_txn_source_line_id;
4266: EXCEPTION
4267: WHEN NO_DATA_FOUND then
4268: print_debug('No Order Line Quantity found', l_debug);

Line 13182: ',oe_order_lines_all OOLA ';

13178: elsif cur_rec.parameter_id IN (2004, 2005, 2006) then
13179: -- Ship Method, Carrier, Scheduled Ship Date
13180: if v_order_line_flag = 'N' then
13181: g_Unreleased_SQL := g_Unreleased_SQL ||
13182: ',oe_order_lines_all OOLA ';
13183: g_WHERE_SQL := g_WHERE_SQL ||
13184: ' WDD.source_header_id=OOLA.header_id AND WDD.SOURCE_LINE_ID=OOLA.LINE_ID and ';
13185: end if;
13186: v_order_line_flag := 'Y';

Line 18154: OE_ORDER_LINES_ALL OOL,

18150: from
18151: WSH_DELIVERY_DETAILS WDD,
18152: HZ_PARTIES HP,
18153: hz_cust_accounts CUST_ACCT,
18154: OE_ORDER_LINES_ALL OOL,
18155: wms_wp_wave_headers_b WWH,
18156: WMS_WP_WAVE_LINES WWL,
18157: WSH_NEW_DELIVERIES WND,
18158: MTL_SYSTEM_ITEMS_KFV MSIV,