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