VIEW: APPS.JTF_LOOKUPS_AK_ATTRIBUTE_V

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')