313: CURSOR cr_primary_attr IS
314: SELECT
315: LOOKUP_CODE,
316: MEANING
317: FROM FND_LOOKUPS
318: WHERE LOOKUP_TYPE ='EGO_ITEM_PRIMARY_ATTRIBUTE_GRP'
319: AND LOOKUP_CODE NOT IN ('APPROVAL_STATUS','ITEM_NUMBER', 'NEW_ITEM_REQUEST') -- 'LONG_DESCRIPTION',
320: AND ENABLED_FLAG = 'Y'
321: AND (NVL(START_DATE_ACTIVE, SYSDATE - 1) < SYSDATE)