DBA Data[Home] [Help]

APPS.OE_VALIDATE_HEADER dependencies on OE_ORDER_TYPES_V

Line 1345: FROM OE_ORDER_TYPES_V

1341: BEGIN
1342: -- Bug 3942415
1343: SELECT 'VALID'
1344: INTO l_dummy
1345: FROM OE_ORDER_TYPES_V
1346: WHERE ORDER_TYPE_ID = p_header_rec.order_type_id
1347: AND TRUNC(p_header_rec.ordered_date)
1348: BETWEEN NVL(START_DATE_ACTIVE,TRUNC(p_header_rec.ordered_date))
1349: AND NVL( END_DATE_ACTIVE,TRUNC(p_header_rec.ordered_date));