APPS.OZF_PRE_PROCESS_PVT dependencies on OE_TRANSACTION_TYPES_VL

Line 2310: FROM oe_transaction_types_vl

2306:
2307: CURSOR get_order_type_id(pc_date_ordered IN DATE
2308: ,pc_order_type IN VARCHAR2) IS
2309: SELECT transaction_type_id
2310: FROM oe_transaction_types_vl
2311: WHERE transaction_type_code = 'ORDER'
2312: AND TO_DATE(TO_CHAR(pc_date_ordered, 'MM/DD/YYYY'), 'MM/DD/YYYY')
2313: BETWEEN start_date_active AND NVL(end_date_active, SYSDATE)
2314: AND name = pc_order_type;

Line 2319: FROM oe_transaction_types_vl

2315:
2316: CURSOR chk_order_type (pc_order_type IN VARCHAR2
2317: ,pc_order_type_id IN NUMBER) IS
2318: SELECT 'X'
2319: FROM oe_transaction_types_vl
2320: WHERE transaction_type_id = pc_order_type_id
2321: UNION ALL
2322: SELECT 'X'
2323: FROM oe_transaction_types_vl

Line 2323: FROM oe_transaction_types_vl

2319: FROM oe_transaction_types_vl
2320: WHERE transaction_type_id = pc_order_type_id
2321: UNION ALL
2322: SELECT 'X'
2323: FROM oe_transaction_types_vl
2324: WHERE name = pc_order_type ;
2325:
2326: CURSOR get_functional_currency IS
2327: SELECT gs.currency_code