View: JTF_LOOKUPS_AK_ATTRIBUTE_V

Product:	JTF - CRM Foundation
Description:
Implementation/DBA Data:	APPS.JTF_LOOKUPS_AK_ATTRIBUTE_V

View Text

SELECT AOL.DATABASE_OBJECT_NAME DATABASE_OBJECT_NAME
, AOA.COLUMN_NAME DATABASE_COLUMN_NAME
, AOA.ATTRIBUTE_APPLICATION_ID APPLICATION_ID
, AOL.NAME OBJECT_NAME
, AOL.DESCRIPTION OBJECT_DESCRIPTION
, AOA.ATTRIBUTE_CODE ATTRIBUTE_CODE
, AAS.ATTRIBUTE_LABEL_LONG ATTRIBUTE_PROMPT
, AAS.DESCRIPTION ATTRIBUTE_DESCRIPTION
FROM (SELECT FND.LOOKUP_TYPE
, FND.LOOKUP_CODE
, FND.MEANING
, FND.DESCRIPTION
, FND.ENABLED_FLAG
, FND.START_DATE_ACTIVE
, FND.END_DATE_ACTIVE
FROM FND_LOOKUPS FND
WHERE FND.LOOKUP_TYPE = 'JTF_BRM_OBJECT_TYPE'
AND FND.ENABLED_FLAG = 'Y'
AND (FND.START_DATE_ACTIVE <= SYSDATE OR FND.START_DATE_ACTIVE IS NULL)
AND (FND.END_DATE_ACTIVE > SYSDATE OR FND.END_DATE_ACTIVE IS NULL) )FLU
, AK_OBJECTS_TL AOL
, AK_OBJECT_ATTRIBUTES AOA
, AK_ATTRIBUTES_TL AAS
WHERE AOL.DATABASE_OBJECT_NAME = FLU.LOOKUP_CODE
AND AOL.LANGUAGE = USERENV('LANG')
AND AOL.DATABASE_OBJECT_NAME = AOA.DATABASE_OBJECT_NAME
AND AOA.ATTRIBUTE_CODE = AAS.ATTRIBUTE_CODE
AND AOA.ATTRIBUTE_APPLICATION_ID = AAS.ATTRIBUTE_APPLICATION_ID
AND AAS.LANGUAGE = USERENV('LANG')

Columns