DBA Data[Home] [Help]

APPS.OE_VALIDATE dependencies on MFG_LOOKUPS

Line 21604: FROM MFG_LOOKUPS

21600: END IF;
21601:
21602: SELECT 'VALID'
21603: INTO l_dummy
21604: FROM MFG_LOOKUPS
21605: WHERE LOOKUP_CODE = p_Item_Relationship_Type
21606: AND LOOKUP_TYPE = l_lookup_type
21607: AND ENABLED_FLAG = 'Y'
21608: AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE, SYSDATE)