DBA Data[Home] [Help]

APPS.WSH_PR_CRITERIA dependencies on OE_ORDER_LINES_ALL

Line 882: FROM OE_ORDER_LINES_ALL

878:
879: -- cursor to get line information
880: CURSOR get_line_info(v_line_id In NUMBER) IS
881: SELECT HEADER_ID
882: FROM OE_ORDER_LINES_ALL
883: WHERE LINE_ID = v_line_id;
884:
885: -- cursor to get lines within a container
886: CURSOR get_inner_items (v_del_detail_id NUMBER) IS

Line 2014: 'u', ' OE_ORDER_LINES_ALL OL, ');

2010: 'u', ' OE_TRANSACTION_TYPES_TL OTTT, '); --bug 6082122: Added table OE_TRANSACTION_TYPES_TL
2011: END IF;
2012:
2013: Process_Buffer(p_print_flag,
2014: 'u', ' OE_ORDER_LINES_ALL OL, ');
2015: Process_Buffer(p_print_flag,
2016: 'u', ' MTL_SYSTEM_ITEMS MSI ');
2017: /* rlanka : Pack J Enhancement
2018: * Need mtl_category_sets and mtl_category_set_valid_cats only *

Line 3347: FROM OE_ORDER_LINES_ALL

3343:
3344: CURSOR c_order_line(v_line_id IN NUMBER) IS
3345: SELECT ORDERED_QUANTITY,
3346: ORDER_QUANTITY_UOM
3347: FROM OE_ORDER_LINES_ALL
3348: WHERE LINE_ID = v_line_id;
3349:
3350: l_return_status VARCHAR2(100);
3351: l_ordered_quantity NUMBER;