DBA Data[Home] [Help]

APPS.OE_VALIDATE_HEADER dependencies on OE_ORDER_TYPES_V

Line 1413: FROM OE_ORDER_TYPES_V

1409: BEGIN
1410: -- Bug 3942415
1411: SELECT 'VALID'
1412: INTO l_dummy
1413: FROM OE_ORDER_TYPES_V
1414: WHERE ORDER_TYPE_ID = p_header_rec.order_type_id
1415: AND TRUNC(p_header_rec.ordered_date)
1416: BETWEEN NVL(START_DATE_ACTIVE,TRUNC(p_header_rec.ordered_date))
1417: AND NVL( END_DATE_ACTIVE,TRUNC(p_header_rec.ordered_date));