VIEW: APPS.OE_PC_ATTRIBUTES_V

Source

View Text - Preformatted

SELECT oeattr.rowid, akoat.ATTRIBUTE_APPLICATION_ID, oeobj.entity_id, oeattr.database_object_name, 'VIEW', oeattr.attribute_code, oeattr.attribute_id, akoat.attribute_code, akattrtl.attribute_label_long, oeattr.constraints_enabled_flag, oeattr.constraint_condn_ref_flag, oeattr.state_attribute_flag, akoat.ATTRIBUTE_LABEL_LENGTH, akattr.DATA_TYPE, akoat.data_source_type, akoat.data_storage_type, akoat.TABLE_NAME , akoat.BASE_TABLE_COLUMN_NAME from ak_object_attributes akoat, ak_attributes akattr, ak_attributes_tl akattrtl, oe_ak_obj_attr_ext oeattr, oe_ak_objects_ext oeobj WHERE akoat.database_object_name = oeobj.database_object_name and akoat.attribute_code = oeattr.attribute_code and akoat.attribute_application_id = oeattr.attribute_application_id and oeobj.database_object_name = oeattr.database_object_name and akattr.attribute_code = akoat.attribute_code and akattr.attribute_application_id = akoat.attribute_application_id and akattrtl.attribute_code = akoat.attribute_code and akattrtl.attribute_application_id = akoat.attribute_application_id and akattrtl.language = USERENV('LANG')

View Text - HTML Formatted

SELECT OEATTR.ROWID
, AKOAT.ATTRIBUTE_APPLICATION_ID
, OEOBJ.ENTITY_ID
, OEATTR.DATABASE_OBJECT_NAME
, 'VIEW'
, OEATTR.ATTRIBUTE_CODE
, OEATTR.ATTRIBUTE_ID
, AKOAT.ATTRIBUTE_CODE
, AKATTRTL.ATTRIBUTE_LABEL_LONG
, OEATTR.CONSTRAINTS_ENABLED_FLAG
, OEATTR.CONSTRAINT_CONDN_REF_FLAG
, OEATTR.STATE_ATTRIBUTE_FLAG
, AKOAT.ATTRIBUTE_LABEL_LENGTH
, AKATTR.DATA_TYPE
, AKOAT.DATA_SOURCE_TYPE
, AKOAT.DATA_STORAGE_TYPE
, AKOAT.TABLE_NAME
, AKOAT.BASE_TABLE_COLUMN_NAME
FROM AK_OBJECT_ATTRIBUTES AKOAT
, AK_ATTRIBUTES AKATTR
, AK_ATTRIBUTES_TL AKATTRTL
, OE_AK_OBJ_ATTR_EXT OEATTR
, OE_AK_OBJECTS_EXT OEOBJ
WHERE AKOAT.DATABASE_OBJECT_NAME = OEOBJ.DATABASE_OBJECT_NAME
AND AKOAT.ATTRIBUTE_CODE = OEATTR.ATTRIBUTE_CODE
AND AKOAT.ATTRIBUTE_APPLICATION_ID = OEATTR.ATTRIBUTE_APPLICATION_ID
AND OEOBJ.DATABASE_OBJECT_NAME = OEATTR.DATABASE_OBJECT_NAME
AND AKATTR.ATTRIBUTE_CODE = AKOAT.ATTRIBUTE_CODE
AND AKATTR.ATTRIBUTE_APPLICATION_ID = AKOAT.ATTRIBUTE_APPLICATION_ID
AND AKATTRTL.ATTRIBUTE_CODE = AKOAT.ATTRIBUTE_CODE
AND AKATTRTL.ATTRIBUTE_APPLICATION_ID = AKOAT.ATTRIBUTE_APPLICATION_ID
AND AKATTRTL.LANGUAGE = USERENV('LANG')