DBA Data[Home] [Help]

APPS.OE_ORDER_COPY_UTIL dependencies on OE_TRANSACTION_TYPES_ALL

Line 137: FROM OE_transaction_TYPES_all --FROM OE_ORDER_TYPES_V

133: -- copy accross organization. Hence cat code is directly selected from master
134: -- table instead of org specific view.
135: CURSOR GET_ORDER_CAT (p_order_type_in NUMBER) IS
136: SELECT ORDER_CATEGORY_CODE --SELECT ORDER_CATEGORY_CODE
137: FROM OE_transaction_TYPES_all --FROM OE_ORDER_TYPES_V
138: WHERE TRANSACTION_TYPE_ID = p_order_type_in; --WHERE ORDER_TYPE_ID = p_order_type_in;
139: --
140: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
141: --

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: --