DBA Data[Home] [Help]

APPS.ASO_TRADEIN_PVT dependencies on OE_TRANSACTION_TYPES_VL

Line 245: FROM OE_TRANSACTION_TYPES_VL --New Code Yogeshwar (MOAC)

241:
242: CURSOR C_Order_Type(l_order_type_id NUMBER) IS
243: SELECT order_category_code, start_date_active, end_date_active
244: --FROM OE_TRANSACTION_TYPES_ALL Commented Code yogeshwar (MOAC)
245: FROM OE_TRANSACTION_TYPES_VL --New Code Yogeshwar (MOAC)
246: WHERE transaction_type_id = l_order_type_id
247: and Transaction_type_code = 'ORDER' ;
248: --Commented Code Start Yogeshwar
249: /*

Line 333: FROM OE_TRANSACTION_TYPES_VL --New Code Yogeshwar (MOAC)

329:
330: CURSOR C_Order_Line_Type(l_order_line_type_id NUMBER) IS
331: SELECT order_category_code, start_date_active, end_date_active
332: --FROM OE_TRANSACTION_TYPES_ALL Commented Code yogeshwar (MOAC)
333: FROM OE_TRANSACTION_TYPES_VL --New Code Yogeshwar (MOAC)
334: WHERE transaction_type_id = l_order_line_type_id
335: and Transaction_type_code = 'LINE' ;
336: --Commented Code Start Yogeshwar (MOAC)
337: /*