DBA Data[Home] [Help]

APPS.GMD_FORMULA_DETAIL_PUB dependencies on MTL_SYSTEM_ITEMS_VL

Line 1605: mtl_system_items_vl it

1601: CURSOR check_validity_rules(pformula_id number, pitem_no varchar2 ) IS
1602: SELECT 1
1603: FROM gmd_recipes_b rcp,
1604: gmd_recipe_validity_rules vr,
1605: mtl_system_items_vl it
1606: WHERE vr.delete_mark = 0
1607: AND vr.validity_rule_status < 1000
1608: AND (vr.end_date IS NULL OR vr.end_date >= SYSDATE)
1609: AND it.concatenated_segments = pitem_no