DBA Data[Home] [Help]

APPS.OE_ORDER_COPY_UTIL dependencies on OE_LINE_TYPES_V

Line 186: FROM OE_transaction_TYPES_all --FROM OE_LINE_TYPES_V

182: -- copy accross organization. Hence cat code is directly selected from master
183: -- table instead of org specific view.
184: CURSOR GET_LINE_CAT (p_line_type_in NUMBER) IS
185: SELECT ORDER_CATEGORY_CODE --SELECT ORDER_CATEGORY_CODE
186: FROM OE_transaction_TYPES_all --FROM OE_LINE_TYPES_V
187: WHERE TRANSACTION_TYPE_ID = p_line_type_in; --WHERE LINE_TYPE_ID = p_line_type_in;
188: --
189: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
190: --

Line 261: FROM Oe_line_types_v

257: oe_debug_pub.add( 'BEFORE LINE_TYPE ID' , 2 ) ;
258: END IF;
259: SELECT name
260: INTO l_line_type
261: FROM Oe_line_types_v
262: WHERE line_type_id = l_line_type_id;
263:
264:
265: EXCEPTION