APPS.OE_FTE_INTEGRATION_PVT dependencies on OE_ORDER_LINES

Line 253: FROM oe_order_lines

249: ,change_sequence
250: ,source_document_type_id
251: ,source_document_id
252: ,source_document_line_id
253: FROM oe_order_lines
254: WHERE header_id = p_header_id
255: AND NOT (p_action = 'R' AND shipping_method_code is NULL)
256: ORDER BY top_model_line_id, ato_line_id, sort_order;
257:

Line 261: FROM oe_order_lines

257:
258:
259: CURSOR C_INC_ITEMS_PARENT IS
260: SELECT line_id
261: FROM oe_order_lines
262: WHERE item_type_code IN ('MODEL', 'CLASS', 'KIT')
263: AND ato_line_id is NULL
264: AND explosion_date is NULL
265: AND NVL(fulfilled_flag,'N') <> 'Y'

Line 356: FROM oe_order_lines

352: -- Now number of Config lines in the table
353:
354: SELECT count(*)
355: INTO l_config_count
356: FROM oe_order_lines
357: WHERE item_type_code = 'CONFIG'
358: AND ato_line_id IS NOT NULL
359: AND header_id = p_header_id;
360:

Line 825: FROM oe_order_lines_all

821: source_document_line_id, source_document_type_id
822: INTO l_order_source_id, l_orig_sys_document_ref, l_orig_sys_line_ref,
823: l_orig_sys_shipment_ref, l_change_sequence, l_source_document_id,
824: l_source_document_line_id, l_source_document_type_id
825: FROM oe_order_lines_all
826: WHERE line_id = p_x_fte_source_line_tab(l_fte_count).source_line_id;
827: EXCEPTION
828: WHEN NO_DATA_FOUND THEN
829: IF l_debug_level > 0 THEN