1. Tables and Views for Common Features
  2. FND_BPM_TASK_COMPOSITES_VL

FND_BPM_TASK_COMPOSITES_VL

Details

  • Schema: FUSION

  • Object owner: FND

  • Object type: VIEW

Columns

Name

TASK_COMPOSITE_ID

TASK_COMPOSITE_NAME

TASK_TRANSACTION_TYPE

TASK_TRANSACTION_TYPE_NAME

TASK_OWNING_FAMILY

TASK_OWNING_APPLICATION

TASK_TRANSACTION_GROUP

TASK_DEFINITION_NAME

TASK_DEFINITION_DISPLAY_NAME

TASK_GROUP_DISPLAY_NAME

PRIMARY_TASK_DEFINITION_NAME

TASK_NAME_SPACE

IS_SUBTASK

ENTERPRISE_ID

MODULE_ID

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

IS_TRANSACTION_LOCKED

TRANSACTION_DATA_SQL

LARGE_TRANSACTION_DATA_SQL

SECURED_RESOURCE_NAME

BYPASS_APPROVAL_OUTCOME

BYPASS_APPROVAL

OBJECT_VERSION_NUMBER

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

SGUID

CATEGORY

PARENT_TASK_DEFINITION_NAME

Query

SQL_Statement

SELECT

FND_BPM_TASK_COMPOSITES_B.TASK_COMPOSITE_ID TASK_COMPOSITE_ID,

FND_BPM_TASK_COMPOSITES_B.TASK_COMPOSITE_NAME TASK_COMPOSITE_NAME,

FND_BPM_TASK_COMPOSITES_B.TASK_TRANSACTION_TYPE TASK_TRANSACTION_TYPE,

FND_BPM_TASK_COMPOSITES_TL.TASK_TRANSACTION_TYPE_NAME TASK_TRANSACTION_TYPE_NAME,

FND_BPM_TASK_COMPOSITES_B.TASK_OWNING_FAMILY TASK_OWNING_FAMILY,

FND_BPM_TASK_COMPOSITES_B.TASK_OWNING_APPLICATION TASK_OWNING_APPLICATION,

FND_BPM_TASK_COMPOSITES_B.TASK_TRANSACTION_GROUP TASK_TRANSACTION_GROUP,

FND_BPM_TASK_COMPOSITES_B.TASK_DEFINITION_NAME TASK_DEFINITION_NAME,

FND_BPM_TASK_COMPOSITES_TL.TASK_DEFINITION_DISPLAY_NAME TASK_DEFINITION_DISPLAY_NAME,

FND_BPM_TASK_COMPOSITES_TL.TASK_GROUP_DISPLAY_NAME TASK_GROUP_DISPLAY_NAME,

FND_BPM_TASK_COMPOSITES_B.PRIMARY_TASK_DEFINITION_NAME PRIMARY_TASK_DEFINITION_NAME,

FND_BPM_TASK_COMPOSITES_B.TASK_NAME_SPACE TASK_NAME_SPACE,

FND_BPM_TASK_COMPOSITES_B.IS_SUBTASK IS_SUBTASK,

FND_BPM_TASK_COMPOSITES_B.ENTERPRISE_ID ENTERPRISE_ID,

FND_BPM_TASK_COMPOSITES_B.MODULE_ID MODULE_ID,

FND_BPM_TASK_COMPOSITES_B.ATTRIBUTE1 ATTRIBUTE1,

FND_BPM_TASK_COMPOSITES_B.ATTRIBUTE2 ATTRIBUTE2,

FND_BPM_TASK_COMPOSITES_B.ATTRIBUTE3 ATTRIBUTE3,

FND_BPM_TASK_COMPOSITES_B.ATTRIBUTE4 ATTRIBUTE4,

FND_BPM_TASK_COMPOSITES_B.ATTRIBUTE5 ATTRIBUTE5,

FND_BPM_TASK_COMPOSITES_B.ATTRIBUTE6 ATTRIBUTE6,

FND_BPM_TASK_COMPOSITES_B.ATTRIBUTE7 ATTRIBUTE7,

FND_BPM_TASK_COMPOSITES_B.ATTRIBUTE8 ATTRIBUTE8,

FND_BPM_TASK_COMPOSITES_B.ATTRIBUTE9 ATTRIBUTE9,

FND_BPM_TASK_COMPOSITES_B.ATTRIBUTE10 ATTRIBUTE10,

FND_BPM_TASK_COMPOSITES_B.ATTRIBUTE_NUMBER1 ATTRIBUTE_NUMBER1,

FND_BPM_TASK_COMPOSITES_B.ATTRIBUTE_NUMBER2 ATTRIBUTE_NUMBER2,

FND_BPM_TASK_COMPOSITES_B.ATTRIBUTE_NUMBER3 ATTRIBUTE_NUMBER3,

FND_BPM_TASK_COMPOSITES_B.ATTRIBUTE_NUMBER4 ATTRIBUTE_NUMBER4,

FND_BPM_TASK_COMPOSITES_B.ATTRIBUTE_NUMBER5 ATTRIBUTE_NUMBER5,

FND_BPM_TASK_COMPOSITES_B.ATTRIBUTE_DATE1 ATTRIBUTE_DATE1,

FND_BPM_TASK_COMPOSITES_B.ATTRIBUTE_DATE2 ATTRIBUTE_DATE2,

FND_BPM_TASK_COMPOSITES_B.ATTRIBUTE_DATE3 ATTRIBUTE_DATE3,

FND_BPM_TASK_COMPOSITES_B.ATTRIBUTE_DATE4 ATTRIBUTE_DATE4,

FND_BPM_TASK_COMPOSITES_B.ATTRIBUTE_DATE5 ATTRIBUTE_DATE5,

FND_BPM_TASK_COMPOSITES_B.IS_TRANSACTION_LOCKED,

FND_BPM_TASK_COMPOSITES_B.TRANSACTION_DATA_SQL,

FND_BPM_TASK_COMPOSITES_B.LARGE_TRANSACTION_DATA_SQL LARGE_TRANSACTION_DATA_SQL,

FND_BPM_TASK_COMPOSITES_B.SECURED_RESOURCE_NAME,

FND_BPM_TASK_COMPOSITES_B.BYPASS_APPROVAL_OUTCOME,

FND_BPM_TASK_COMPOSITES_B.BYPASS_APPROVAL,

FND_BPM_TASK_COMPOSITES_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER,

FND_BPM_TASK_COMPOSITES_B.CREATED_BY CREATED_BY,

FND_BPM_TASK_COMPOSITES_B.CREATION_DATE CREATION_DATE,

FND_BPM_TASK_COMPOSITES_B.LAST_UPDATED_BY LAST_UPDATED_BY,

FND_BPM_TASK_COMPOSITES_B.LAST_UPDATE_DATE LAST_UPDATE_DATE,

FND_BPM_TASK_COMPOSITES_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN,

FND_BPM_TASK_COMPOSITES_B.SGUID SGUID,

FND_BPM_TASK_COMPOSITES_B.CATEGORY CATEGORY,

FND_BPM_TASK_COMPOSITES_B.PARENT_TASK_DEFINITION_NAME PARENT_TASK_DEFINITION_NAME

FROM

FND_BPM_TASK_COMPOSITES_B,

FND_BPM_TASK_COMPOSITES_TL

WHERE

FND_BPM_TASK_COMPOSITES_B.TASK_COMPOSITE_ID = FND_BPM_TASK_COMPOSITES_TL.TASK_COMPOSITE_ID AND FND_BPM_TASK_COMPOSITES_TL.LANGUAGE = USERENV('LANG')