DBA Data[Home] [Help]

APPS.OE_VALIDATE_WF dependencies on OE_TRANSACTION_TYPES_VL

Line 2335: FROM oe_transaction_types_vl

2331: , transaction_type_code
2332: , order_category_code
2333: , start_date_active
2334: , end_date_active
2335: FROM oe_transaction_types_vl
2336: WHERE transaction_type_code = 'ORDER'
2337: AND SYSDATE >= start_date_active
2338: AND TRUNC(SYSDATE) <= NVL(end_date_active, SYSDATE);
2339:

Line 2433: FROM oe_transaction_types_vl

2429:
2430: BEGIN
2431: SELECT name
2432: INTO l_validating_flow
2433: FROM oe_transaction_types_vl
2434: WHERE TRANSACTION_TYPE_ID = l_transaction_tbl(l_record_count).transaction_type_id;
2435: EXCEPTION
2436: WHEN NO_DATA_FOUND THEN
2437: NULL;