FND_BPM_TASK_ATTRIBUTES_VL
Details
-
Schema: FUSION
-
Object owner: FND
-
Object type: VIEW
Columns
Name |
---|
TASK_ATTRIBUTE_ID TASK_ATTRIBUTE_NAME TASK_COMPOSITE_ID TASK_DEFINITION_NAME PARENT_ATTRIBUTE_NAME ATTRIBUTE_TYPE ATTRIBUTE_DATA_TYPE ATTRIBUTE_USAGE TL_LOOKUP_SQL LINK_VALUE OLD_VALUE_TASK_ATTRIBUTE_NAME OLD_VALUE_TL_LOOKUP_SQL CURRENCY_CODE_ATTRIBUTE FACT_NAME FACT_NAME_SPACE FACT_CARDINALITY SECURED_BY ATTRIBUTE_RESOURCE_BUNDLE ATTRIBUTE_RESOURCE_KEY FLEX_BASE_LOCATOR IS_SECURED IS_RATE_DATE IS_SEARCHABLE IS_LIST IS_DISPLAYABLE IS_RECOMMENDABLE IS_FREQUENTLY_USED IS_USER_APPROVER IS_NULLABLE LOV_SERVICE_REFERENCE LOV_SERVICE_SELF_LINK LOV_SERVICE_LIST_LINK LOV_DISPLAY_FIELDS LOV_KEY_FIELD LOV_VALUE_FIELD LOV_PRESENTABLE_FIELDS VOATTRIBUTE_NAME FLEX_TYPE SGUID ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE_NUMBER1 ATTRIBUTE_NUMBER2 ATTRIBUTE_NUMBER3 ATTRIBUTE_NUMBER4 ATTRIBUTE_NUMBER5 ATTRIBUTE_DATE1 ATTRIBUTE_DATE2 ATTRIBUTE_DATE3 ATTRIBUTE_DATE4 ATTRIBUTE_DATE5 ENTERPRISE_ID TASK_ATTRIBUTE_DISPLAY_NAME TASK_ATTRIBUTE_DESCRIPTION CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER CURRENCY_CONVERSION_DATE DATA_COLLECTION_METADATA DATA_COLLECTION_SQL GROUP_NAME GROUP_RES_BUNDLE_NAME GROUP_RES_BUNDLE_KEY |
Query
SQL_Statement |
---|
SELECT FND_BPM_TASK_ATTRIBUTES_B.TASK_ATTRIBUTE_ID TASK_ATTRIBUTE_ID, FND_BPM_TASK_ATTRIBUTES_B.TASK_ATTRIBUTE_NAME TASK_ATTRIBUTE_NAME, FND_BPM_TASK_ATTRIBUTES_B.TASK_COMPOSITE_ID TASK_COMPOSITE_ID, FND_BPM_TASK_ATTRIBUTES_B.TASK_DEFINITION_NAME TASK_DEFINITION_NAME, FND_BPM_TASK_ATTRIBUTES_B.PARENT_ATTRIBUTE_NAME PARENT_ATTRIBUTE_NAME, FND_BPM_TASK_ATTRIBUTES_B.ATTRIBUTE_TYPE ATTRIBUTE_TYPE, FND_BPM_TASK_ATTRIBUTES_B.ATTRIBUTE_DATA_TYPE ATTRIBUTE_DATA_TYPE, FND_BPM_TASK_ATTRIBUTES_B.ATTRIBUTE_USAGE ATTRIBUTE_USAGE, FND_BPM_TASK_ATTRIBUTES_B.TL_LOOKUP_SQL TL_LOOKUP_SQL, FND_BPM_TASK_ATTRIBUTES_B.LINK_VALUE LINK_VALUE, FND_BPM_TASK_ATTRIBUTES_B.OLD_VALUE_TASK_ATTRIBUTE_NAME OLD_VALUE_TASK_ATTRIBUTE_NAME, FND_BPM_TASK_ATTRIBUTES_B.OLD_VALUE_TL_LOOKUP_SQL OLD_VALUE_TL_LOOKUP_SQL, FND_BPM_TASK_ATTRIBUTES_B.CURRENCY_CODE_ATTRIBUTE CURRENCY_CODE_ATTRIBUTE, FND_BPM_TASK_ATTRIBUTES_B.FACT_NAME FACT_NAME, FND_BPM_TASK_ATTRIBUTES_B.FACT_NAME_SPACE FACT_NAME_SPACE, FND_BPM_TASK_ATTRIBUTES_B.FACT_CARDINALITY FACT_CARDINALITY, FND_BPM_TASK_ATTRIBUTES_B.SECURED_BY SECURED_BY, FND_BPM_TASK_ATTRIBUTES_B.ATTRIBUTE_RESOURCE_BUNDLE ATTRIBUTE_RESOURCE_BUNDLE, FND_BPM_TASK_ATTRIBUTES_B.ATTRIBUTE_RESOURCE_KEY ATTRIBUTE_RESOURCE_KEY, FND_BPM_TASK_ATTRIBUTES_B.FLEX_BASE_LOCATOR FLEX_BASE_LOCATOR, FND_BPM_TASK_ATTRIBUTES_B.IS_SECURED IS_SECURED, FND_BPM_TASK_ATTRIBUTES_B.IS_RATE_DATE IS_RATE_DATE, FND_BPM_TASK_ATTRIBUTES_B.IS_SEARCHABLE IS_SEARCHABLE, FND_BPM_TASK_ATTRIBUTES_B.IS_LIST IS_LIST, FND_BPM_TASK_ATTRIBUTES_B.IS_DISPLAYABLE IS_DISPLAYABLE, FND_BPM_TASK_ATTRIBUTES_B.IS_RECOMMENDABLE IS_RECOMMENDABLE, FND_BPM_TASK_ATTRIBUTES_B.IS_FREQUENTLY_USED IS_FREQUENTLY_USED, FND_BPM_TASK_ATTRIBUTES_B.IS_USER_APPROVER IS_USER_APPROVER, FND_BPM_TASK_ATTRIBUTES_B.IS_NULLABLE IS_NULLABLE, FND_BPM_TASK_ATTRIBUTES_B.LOV_SERVICE_REFERENCE LOV_SERVICE_REFERENCE, FND_BPM_TASK_ATTRIBUTES_B.LOV_SERVICE_SELF_LINK LOV_SERVICE_SELF_LINK, FND_BPM_TASK_ATTRIBUTES_B.LOV_SERVICE_LIST_LINK LOV_SERVICE_LIST_LINK, FND_BPM_TASK_ATTRIBUTES_B.LOV_DISPLAY_FIELDS LOV_DISPLAY_FIELDS, FND_BPM_TASK_ATTRIBUTES_B.LOV_KEY_FIELD LOV_KEY_FIELD, FND_BPM_TASK_ATTRIBUTES_B.LOV_VALUE_FIELD LOV_VALUE_FIELD, FND_BPM_TASK_ATTRIBUTES_B.LOV_PRESENTABLE_FIELDS LOV_PRESENTABLE_FIELDS, FND_BPM_TASK_ATTRIBUTES_B.VOATTRIBUTE_NAME, FND_BPM_TASK_ATTRIBUTES_B.FLEX_TYPE, FND_BPM_TASK_ATTRIBUTES_B.SGUID SGUID, FND_BPM_TASK_ATTRIBUTES_B.ATTRIBUTE1 ATTRIBUTE1, FND_BPM_TASK_ATTRIBUTES_B.ATTRIBUTE2 ATTRIBUTE2, FND_BPM_TASK_ATTRIBUTES_B.ATTRIBUTE3 ATTRIBUTE3, FND_BPM_TASK_ATTRIBUTES_B.ATTRIBUTE4 ATTRIBUTE4, FND_BPM_TASK_ATTRIBUTES_B.ATTRIBUTE5 ATTRIBUTE5, FND_BPM_TASK_ATTRIBUTES_B.ATTRIBUTE6 ATTRIBUTE6, FND_BPM_TASK_ATTRIBUTES_B.ATTRIBUTE7 ATTRIBUTE7, FND_BPM_TASK_ATTRIBUTES_B.ATTRIBUTE8 ATTRIBUTE8, FND_BPM_TASK_ATTRIBUTES_B.ATTRIBUTE9 ATTRIBUTE9, FND_BPM_TASK_ATTRIBUTES_B.ATTRIBUTE10 ATTRIBUTE10, FND_BPM_TASK_ATTRIBUTES_B.ATTRIBUTE_NUMBER1 ATTRIBUTE_NUMBER1, FND_BPM_TASK_ATTRIBUTES_B.ATTRIBUTE_NUMBER2 ATTRIBUTE_NUMBER2, FND_BPM_TASK_ATTRIBUTES_B.ATTRIBUTE_NUMBER3 ATTRIBUTE_NUMBER3, FND_BPM_TASK_ATTRIBUTES_B.ATTRIBUTE_NUMBER4 ATTRIBUTE_NUMBER4, FND_BPM_TASK_ATTRIBUTES_B.ATTRIBUTE_NUMBER5 ATTRIBUTE_NUMBER5, FND_BPM_TASK_ATTRIBUTES_B.ATTRIBUTE_DATE1 ATTRIBUTE_DATE1, FND_BPM_TASK_ATTRIBUTES_B.ATTRIBUTE_DATE2 ATTRIBUTE_DATE2, FND_BPM_TASK_ATTRIBUTES_B.ATTRIBUTE_DATE3 ATTRIBUTE_DATE3, FND_BPM_TASK_ATTRIBUTES_B.ATTRIBUTE_DATE4 ATTRIBUTE_DATE4, FND_BPM_TASK_ATTRIBUTES_B.ATTRIBUTE_DATE5 ATTRIBUTE_DATE5, FND_BPM_TASK_ATTRIBUTES_B.ENTERPRISE_ID ENTERPRISE_ID, FND_BPM_TASK_ATTRIBUTES_TL.TASK_ATTRIBUTE_DISPLAY_NAME TASK_ATTRIBUTE_DISPLAY_NAME, FND_BPM_TASK_ATTRIBUTES_TL.TASK_ATTRIBUTE_DESCRIPTION TASK_ATTRIBUTE_DESCRIPTION, FND_BPM_TASK_ATTRIBUTES_B.CREATED_BY CREATED_BY, FND_BPM_TASK_ATTRIBUTES_B.CREATION_DATE CREATION_DATE, FND_BPM_TASK_ATTRIBUTES_B.LAST_UPDATED_BY LAST_UPDATED_BY, FND_BPM_TASK_ATTRIBUTES_B.LAST_UPDATE_DATE LAST_UPDATE_DATE, FND_BPM_TASK_ATTRIBUTES_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, FND_BPM_TASK_ATTRIBUTES_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, FND_BPM_TASK_ATTRIBUTES_B.CURRENCY_CONVERSION_DATE CURRENCY_CONVERSION_DATE, FND_BPM_TASK_ATTRIBUTES_B.DATA_COLLECTION_METADATA DATA_COLLECTION_METADATA, FND_BPM_TASK_ATTRIBUTES_B.DATA_COLLECTION_SQL DATA_COLLECTION_SQL, FND_BPM_TASK_ATTRIBUTES_B.GROUP_NAME GROUP_NAME, FND_BPM_TASK_ATTRIBUTES_B.GROUP_RES_BUNDLE_NAME GROUP_RES_BUNDLE_NAME, FND_BPM_TASK_ATTRIBUTES_B.GROUP_RES_BUNDLE_KEY GROUP_RES_BUNDLE_KEY FROM FND_BPM_TASK_ATTRIBUTES_B FND_BPM_TASK_ATTRIBUTES_B , FND_BPM_TASK_ATTRIBUTES_TL FND_BPM_TASK_ATTRIBUTES_TL WHERE FND_BPM_TASK_ATTRIBUTES_B.TASK_ATTRIBUTE_ID = FND_BPM_TASK_ATTRIBUTES_TL.TASK_ATTRIBUTE_ID AND FND_BPM_TASK_ATTRIBUTES_TL.LANGUAGE = USERENV('LANG') |