DBA Data[Home] [Help]

APPS.OE_ORDER_COPY_UTIL dependencies on OE_TRANSACTION_TYPES_ALL

Line 176: FROM OE_transaction_TYPES_all --FROM OE_ORDER_TYPES_V

172: -- copy accross organization. Hence cat code is directly selected from master
173: -- table instead of org specific view.
174: CURSOR GET_ORDER_CAT (p_order_type_in NUMBER) IS
175: SELECT ORDER_CATEGORY_CODE --SELECT ORDER_CATEGORY_CODE
176: FROM OE_transaction_TYPES_all --FROM OE_ORDER_TYPES_V
177: WHERE TRANSACTION_TYPE_ID = p_order_type_in; --WHERE ORDER_TYPE_ID = p_order_type_in;
178: --
179: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
180: --

Line 225: FROM OE_transaction_TYPES_all --FROM OE_LINE_TYPES_V

221: -- copy accross organization. Hence cat code is directly selected from master
222: -- table instead of org specific view.
223: CURSOR GET_LINE_CAT (p_line_type_in NUMBER) IS
224: SELECT ORDER_CATEGORY_CODE --SELECT ORDER_CATEGORY_CODE
225: FROM OE_transaction_TYPES_all --FROM OE_LINE_TYPES_V
226: WHERE TRANSACTION_TYPE_ID = p_line_type_in; --WHERE LINE_TYPE_ID = p_line_type_in;
227: --
228: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
229: --