DBA Data[Home] [Help]

APPS.WSH_PR_CRITERIA dependencies on OE_ORDER_LINES_ALL

Line 914: FROM OE_ORDER_LINES_ALL

910:
911: -- cursor to get line information
912: CURSOR get_line_info(v_line_id In NUMBER) IS
913: SELECT HEADER_ID
914: FROM OE_ORDER_LINES_ALL
915: WHERE LINE_ID = v_line_id;
916:
917: -- cursor to get lines within a container
918: CURSOR get_inner_items (v_del_detail_id NUMBER) IS

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

2092: 'u', ' OE_TRANSACTION_TYPES_TL OTTT, '); --bug 6082122: Added table OE_TRANSACTION_TYPES_TL
2093: END IF;
2094:
2095: Process_Buffer(p_print_flag,
2096: 'u', ' OE_ORDER_LINES_ALL OL, ');
2097: Process_Buffer(p_print_flag,
2098: 'u', ' MTL_SYSTEM_ITEMS MSI ');
2099: /* rlanka : Pack J Enhancement
2100: * Need mtl_category_sets and mtl_category_set_valid_cats only *

Line 3463: FROM OE_ORDER_LINES_ALL

3459:
3460: CURSOR c_order_line(v_line_id IN NUMBER) IS
3461: SELECT ORDERED_QUANTITY,
3462: ORDER_QUANTITY_UOM
3463: FROM OE_ORDER_LINES_ALL
3464: WHERE LINE_ID = v_line_id;
3465:
3466: l_return_status VARCHAR2(100);
3467: l_ordered_quantity NUMBER;