DBA Data[Home] [Help]

APPS.BOM_VALIDATE_BOM_COMPONENT dependencies on EGO_CRITERIA_TEMPLATES_V

Line 201: EGO_CRITERIA_TEMPLATES_V TEMPLATES

197: IF (l_parent_item_type IS NOT NULL)
198: THEN
199: SELECT TEMPLATES.CUSTOMIZATION_CODE INTO l_customization_code
200: FROM FND_COMMON_LOOKUPS LOOKUP,
201: EGO_CRITERIA_TEMPLATES_V TEMPLATES
202: WHERE LOOKUP.LOOKUP_TYPE = 'ITEM_TYPE'
203: AND LOOKUP.ENABLED_FLAG = 'Y'
204: AND (LOOKUP.START_DATE_ACTIVE IS NULL OR LOOKUP.START_DATE_ACTIVE < SYSDATE)
205: AND (LOOKUP.END_DATE_ACTIVE IS NULL OR LOOKUP.END_DATE_ACTIVE > SYSDATE)