PER_TASKS_IN_CHECKLIST

Details

Schema: FUSION
Object owner: PER
Object type: VIEW

Columns

Name
TASK_IN_CHECKLIST_ID CHECKLIST_ID CHECKLIST_TASK_NAME ELIGIBILITY_OBJECT_ID AME_ATTRIBUTE_IDENTIFIER DESCRIPTION MANDATORY_FLAG TARGET_DURATION TARGET_DURATION_UOM TASK_SEQUENCE ACTION_URL BUSINESS_GROUP_ID OBJECT_VERSION_NUMBER LAST_UPDATE_DATE ELIGIBILITY_PROFILE_ID LAST_UPDATED_BY LAST_UPDATE_LOGIN CREATED_BY CREATION_DATE ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 ATTRIBUTE16 ATTRIBUTE17 ATTRIBUTE18 ATTRIBUTE19 ATTRIBUTE20 ATTRIBUTE21 ATTRIBUTE22 ATTRIBUTE23 ATTRIBUTE24 ATTRIBUTE25 ATTRIBUTE26 ATTRIBUTE27 ATTRIBUTE28 ATTRIBUTE29 ATTRIBUTE30 INFORMATION_CATEGORY INFORMATION1 INFORMATION2 INFORMATION3 INFORMATION4 INFORMATION5 INFORMATION6 INFORMATION7 INFORMATION8 INFORMATION9 INFORMATION10 INFORMATION11 INFORMATION12 INFORMATION13 INFORMATION14 INFORMATION15 INFORMATION16 INFORMATION17 INFORMATION18 INFORMATION19 INFORMATION20 INFORMATION21 INFORMATION22 INFORMATION23 INFORMATION24 INFORMATION25 INFORMATION26 INFORMATION27 INFORMATION28 INFORMATION29 INFORMATION30 RESPONSIBILITY_TYPE ATTRIBUTE_NUMBER1 ATTRIBUTE_NUMBER2 ATTRIBUTE_NUMBER3 ATTRIBUTE_NUMBER4 ATTRIBUTE_NUMBER5 ATTRIBUTE_NUMBER6 ATTRIBUTE_NUMBER7 ATTRIBUTE_NUMBER8 ATTRIBUTE_NUMBER9 ATTRIBUTE_NUMBER10 ATTRIBUTE_NUMBER11 ATTRIBUTE_NUMBER12 ATTRIBUTE_NUMBER13 ATTRIBUTE_NUMBER14 ATTRIBUTE_NUMBER15 ATTRIBUTE_NUMBER16 ATTRIBUTE_NUMBER17 ATTRIBUTE_NUMBER18 ATTRIBUTE_NUMBER19 ATTRIBUTE_NUMBER20 ATTRIBUTE_DATE1 ATTRIBUTE_DATE2 ATTRIBUTE_DATE3 ATTRIBUTE_DATE4 ATTRIBUTE_DATE5 ATTRIBUTE_DATE6 ATTRIBUTE_DATE7 ATTRIBUTE_DATE8 ATTRIBUTE_DATE9 ATTRIBUTE_DATE10 ATTRIBUTE_DATE11 ATTRIBUTE_DATE12 ATTRIBUTE_DATE13 ATTRIBUTE_DATE14 ATTRIBUTE_DATE15 TASK_IN_CHECKLIST_CODE ACTIVE_INACTIVE_FLAG ALLOW_ALLC_TASK_CREATE ALLOW_ALLC_TASK_UPDATE ALLOW_ALLC_TASK_DELETE TASK_DELAY_DURATION_UOM TASK_DELAY_DURATION SGUID ADHOC_USER_GUID ACTION_TYPE TASK_ACTION_ID FLEX_CONTEXT_CODE DOCUMENT_TYPE_ID TASK_CONFIGURATION MODULE_ID USER_DISPLAY_NAME TASK_DETAILS ACTIVATION_ELIGY_PRFL_ID REMINDER_RECURRENCE REMINDER_DURATION REMINDER_RELATIVE_TO GENERATE_ATOM_FEED ATOM_FEED_CONFIGURATION SEED_DATA_SOURCE OWNER_RESP_TYPE OWNER_USER_GUID MEETING_LOCATION MEETING_OFFSET MEETING_TIME ENABLE_TASK_EXPIRY EXPIRY_AFTER_DAYS TASK_CATEGORY DETAIL_CHECKLIST_ID CONTACT_DETAILS TASK_ACTION_CODE SIGN_TEMPLATE ESIGN_TYPE REPORT_PATH QUESTIONNAIRE_ID NOTE_TITLE ATTACHMENT_DOCUMENT_TYPE_ID LEARNING_ITEM_ID LEARN_CONTENT_TYPE REPORT_PARAMETERS ANALYTICS_PATH EXPIRY_RELATIVE_TO TASK_FEATURE1 TASK_FEATURE2 TASK_FEATURE3 TASK_FEATURE4 TASK_FEATURE5 TASK_FEATURE_DETAILS REMINDER_TEMPLATE_ID OBSOLETE_FLAG COMPLETE_ACTION_LABEL REJECT_ACTION_LABEL SAVE_ACTION_LABEL CALENDAR_ACTION_LABEL ACTIVITY_ACTION1_LABEL ACTIVITY_ACTION2_LABEL ACTIVITY_ACTION3_LABEL ACTIVITY_ACTION4_LABEL ACTIVITY_ACTION5_LABEL VIDEO_TYPE DISPLAY_OPTIONS VIDEO_URL LEARN_ENROLLMENT_ID LEARN_COMMUNITY_ID LEARN_ENROLLMENT_TYPE EMBED_TASK_ACTION_CODE CONTENT_PROVIDER_CODE

Name

TASK_IN_CHECKLIST_ID

CHECKLIST_ID

CHECKLIST_TASK_NAME

ELIGIBILITY_OBJECT_ID

AME_ATTRIBUTE_IDENTIFIER

DESCRIPTION

MANDATORY_FLAG

TARGET_DURATION

TARGET_DURATION_UOM

TASK_SEQUENCE

ACTION_URL

BUSINESS_GROUP_ID

OBJECT_VERSION_NUMBER

LAST_UPDATE_DATE

ELIGIBILITY_PROFILE_ID

LAST_UPDATED_BY

LAST_UPDATE_LOGIN

CREATED_BY

CREATION_DATE

ATTRIBUTE_CATEGORY

ATTRIBUTE1

ATTRIBUTE2

ATTRIBUTE3

ATTRIBUTE4

ATTRIBUTE5

ATTRIBUTE6

ATTRIBUTE7

ATTRIBUTE8

ATTRIBUTE9

ATTRIBUTE10

ATTRIBUTE11

ATTRIBUTE12

ATTRIBUTE13

ATTRIBUTE14

ATTRIBUTE15

ATTRIBUTE16

ATTRIBUTE17

ATTRIBUTE18

ATTRIBUTE19

ATTRIBUTE20

ATTRIBUTE21

ATTRIBUTE22

ATTRIBUTE23

ATTRIBUTE24

ATTRIBUTE25

ATTRIBUTE26

ATTRIBUTE27

ATTRIBUTE28

ATTRIBUTE29

ATTRIBUTE30

INFORMATION_CATEGORY

INFORMATION1

INFORMATION2

INFORMATION3

INFORMATION4

INFORMATION5

INFORMATION6

INFORMATION7

INFORMATION8

INFORMATION9

INFORMATION10

INFORMATION11

INFORMATION12

INFORMATION13

INFORMATION14

INFORMATION15

INFORMATION16

INFORMATION17

INFORMATION18

INFORMATION19

INFORMATION20

INFORMATION21

INFORMATION22

INFORMATION23

INFORMATION24

INFORMATION25

INFORMATION26

INFORMATION27

INFORMATION28

INFORMATION29

INFORMATION30

RESPONSIBILITY_TYPE

ATTRIBUTE_NUMBER1

ATTRIBUTE_NUMBER2

ATTRIBUTE_NUMBER3

ATTRIBUTE_NUMBER4

ATTRIBUTE_NUMBER5

ATTRIBUTE_NUMBER6

ATTRIBUTE_NUMBER7

ATTRIBUTE_NUMBER8

ATTRIBUTE_NUMBER9

ATTRIBUTE_NUMBER10

ATTRIBUTE_NUMBER11

ATTRIBUTE_NUMBER12

ATTRIBUTE_NUMBER13

ATTRIBUTE_NUMBER14

ATTRIBUTE_NUMBER15

ATTRIBUTE_NUMBER16

ATTRIBUTE_NUMBER17

ATTRIBUTE_NUMBER18

ATTRIBUTE_NUMBER19

ATTRIBUTE_NUMBER20

ATTRIBUTE_DATE1

ATTRIBUTE_DATE2

ATTRIBUTE_DATE3

ATTRIBUTE_DATE4

ATTRIBUTE_DATE5

ATTRIBUTE_DATE6

ATTRIBUTE_DATE7

ATTRIBUTE_DATE8

ATTRIBUTE_DATE9

ATTRIBUTE_DATE10

ATTRIBUTE_DATE11

ATTRIBUTE_DATE12

ATTRIBUTE_DATE13

ATTRIBUTE_DATE14

ATTRIBUTE_DATE15

TASK_IN_CHECKLIST_CODE

ACTIVE_INACTIVE_FLAG

ALLOW_ALLC_TASK_CREATE

ALLOW_ALLC_TASK_UPDATE

ALLOW_ALLC_TASK_DELETE

TASK_DELAY_DURATION_UOM

TASK_DELAY_DURATION

SGUID

ADHOC_USER_GUID

ACTION_TYPE

TASK_ACTION_ID

FLEX_CONTEXT_CODE

DOCUMENT_TYPE_ID

TASK_CONFIGURATION

MODULE_ID

USER_DISPLAY_NAME

TASK_DETAILS

ACTIVATION_ELIGY_PRFL_ID

REMINDER_RECURRENCE

REMINDER_DURATION

REMINDER_RELATIVE_TO

GENERATE_ATOM_FEED

ATOM_FEED_CONFIGURATION

SEED_DATA_SOURCE

OWNER_RESP_TYPE

OWNER_USER_GUID

MEETING_LOCATION

MEETING_OFFSET

MEETING_TIME

ENABLE_TASK_EXPIRY

EXPIRY_AFTER_DAYS

TASK_CATEGORY

DETAIL_CHECKLIST_ID

CONTACT_DETAILS

TASK_ACTION_CODE

SIGN_TEMPLATE

ESIGN_TYPE

REPORT_PATH

QUESTIONNAIRE_ID

NOTE_TITLE

ATTACHMENT_DOCUMENT_TYPE_ID

LEARNING_ITEM_ID

LEARN_CONTENT_TYPE

REPORT_PARAMETERS

ANALYTICS_PATH

EXPIRY_RELATIVE_TO

TASK_FEATURE1

TASK_FEATURE2

TASK_FEATURE3

TASK_FEATURE4

TASK_FEATURE5

TASK_FEATURE_DETAILS

REMINDER_TEMPLATE_ID

OBSOLETE_FLAG

COMPLETE_ACTION_LABEL

REJECT_ACTION_LABEL

SAVE_ACTION_LABEL

CALENDAR_ACTION_LABEL

ACTIVITY_ACTION1_LABEL

ACTIVITY_ACTION2_LABEL

ACTIVITY_ACTION3_LABEL

ACTIVITY_ACTION4_LABEL

ACTIVITY_ACTION5_LABEL

VIDEO_TYPE

DISPLAY_OPTIONS

VIDEO_URL

LEARN_ENROLLMENT_ID

LEARN_COMMUNITY_ID

LEARN_ENROLLMENT_TYPE

EMBED_TASK_ACTION_CODE

CONTENT_PROVIDER_CODE

Query

SQL_Statement
SELECT B.TASK_IN_CHECKLIST_ID, B.CHECKLIST_ID, T.CHECKLIST_TASK_NAME, B.ELIGIBILITY_OBJECT_ID, B.AME_ATTRIBUTE_IDENTIFIER, T.DESCRIPTION, B.MANDATORY_FLAG, B.TARGET_DURATION, B.TARGET_DURATION_UOM, B.TASK_SEQUENCE, T.ACTION_URL, B.BUSINESS_GROUP_ID, B.OBJECT_VERSION_NUMBER, B.LAST_UPDATE_DATE, B.ELIGIBILITY_PROFILE_ID, B.LAST_UPDATED_BY, B.LAST_UPDATE_LOGIN, B.CREATED_BY, B.CREATION_DATE, B.ATTRIBUTE_CATEGORY, B.ATTRIBUTE1, B.ATTRIBUTE2, B.ATTRIBUTE3, B.ATTRIBUTE4, B.ATTRIBUTE5, B.ATTRIBUTE6, B.ATTRIBUTE7, B.ATTRIBUTE8, B.ATTRIBUTE9, B.ATTRIBUTE10, B.ATTRIBUTE11, B.ATTRIBUTE12, B.ATTRIBUTE13, B.ATTRIBUTE14, B.ATTRIBUTE15, B.ATTRIBUTE16, B.ATTRIBUTE17, B.ATTRIBUTE18, B.ATTRIBUTE19, B.ATTRIBUTE20, B.ATTRIBUTE21, B.ATTRIBUTE22, B.ATTRIBUTE23, B.ATTRIBUTE24, B.ATTRIBUTE25, B.ATTRIBUTE26, B.ATTRIBUTE27, B.ATTRIBUTE28, B.ATTRIBUTE29, B.ATTRIBUTE30, B.INFORMATION_CATEGORY, B.INFORMATION1, B.INFORMATION2, B.INFORMATION3, B.INFORMATION4, B.INFORMATION5, B.INFORMATION6, B.INFORMATION7, B.INFORMATION8, B.INFORMATION9, B.INFORMATION10, B.INFORMATION11, B.INFORMATION12, B.INFORMATION13, B.INFORMATION14, B.INFORMATION15, B.INFORMATION16, B.INFORMATION17, B.INFORMATION18, B.INFORMATION19, B.INFORMATION20, B.INFORMATION21, B.INFORMATION22, B.INFORMATION23, B.INFORMATION24, B.INFORMATION25, B.INFORMATION26, B.INFORMATION27, B.INFORMATION28, B.INFORMATION29, B.INFORMATION30, B.RESPONSIBILITY_TYPE, B.ATTRIBUTE_NUMBER1, B.ATTRIBUTE_NUMBER2, B.ATTRIBUTE_NUMBER3, B.ATTRIBUTE_NUMBER4, B.ATTRIBUTE_NUMBER5, B.ATTRIBUTE_NUMBER6, B.ATTRIBUTE_NUMBER7, B.ATTRIBUTE_NUMBER8, B.ATTRIBUTE_NUMBER9, B.ATTRIBUTE_NUMBER10, B.ATTRIBUTE_NUMBER11, B.ATTRIBUTE_NUMBER12, B.ATTRIBUTE_NUMBER13, B.ATTRIBUTE_NUMBER14, B.ATTRIBUTE_NUMBER15, B.ATTRIBUTE_NUMBER16, B.ATTRIBUTE_NUMBER17, B.ATTRIBUTE_NUMBER18, B.ATTRIBUTE_NUMBER19, B.ATTRIBUTE_NUMBER20, B.ATTRIBUTE_DATE1, B.ATTRIBUTE_DATE2, B.ATTRIBUTE_DATE3, B.ATTRIBUTE_DATE4, B.ATTRIBUTE_DATE5, B.ATTRIBUTE_DATE6, B.ATTRIBUTE_DATE7, B.ATTRIBUTE_DATE8, B.ATTRIBUTE_DATE9, B.ATTRIBUTE_DATE10, B.ATTRIBUTE_DATE11, B.ATTRIBUTE_DATE12, B.ATTRIBUTE_DATE13, B.ATTRIBUTE_DATE14, B.ATTRIBUTE_DATE15, B.TASK_IN_CHECKLIST_CODE, B.ACTIVE_INACTIVE_FLAG, B.ALLOW_ALLC_TASK_CREATE, B.ALLOW_ALLC_TASK_UPDATE, B.ALLOW_ALLC_TASK_DELETE, B.TASK_DELAY_DURATION_UOM, B.TASK_DELAY_DURATION, B.SGUID SGUID, B.ADHOC_USER_GUID, B.ACTION_TYPE, B.TASK_ACTION_ID, B.FLEX_CONTEXT_CODE, B.DOCUMENT_TYPE_ID, B.TASK_CONFIGURATION, B.MODULE_ID, T.USER_DISPLAY_NAME, T.TASK_DETAILS, B.ACTIVATION_ELIGY_PRFL_ID, B.REMINDER_RECURRENCE, B.REMINDER_DURATION, B.REMINDER_RELATIVE_TO, B.GENERATE_ATOM_FEED, B.ATOM_FEED_CONFIGURATION, B.SEED_DATA_SOURCE, B.OWNER_RESP_TYPE, B.OWNER_USER_GUID, T.MEETING_LOCATION, B.MEETING_OFFSET, B.MEETING_TIME, B.ENABLE_TASK_EXPIRY, B.EXPIRY_AFTER_DAYS, B.TASK_CATEGORY, B.DETAIL_CHECKLIST_ID, B.CONTACT_DETAILS, B.TASK_ACTION_CODE, B.SIGN_TEMPLATE, B.ESIGN_TYPE, B.REPORT_PATH, B.QUESTIONNAIRE_ID, T.NOTE_TITLE, B.ATTACHMENT_DOCUMENT_TYPE_ID, B.LEARNING_ITEM_ID, B.LEARN_CONTENT_TYPE, B.REPORT_PARAMETERS, B.ANALYTICS_PATH, B.EXPIRY_RELATIVE_TO, B.TASK_FEATURE1, B.TASK_FEATURE2, B.TASK_FEATURE3, B.TASK_FEATURE4, B.TASK_FEATURE5, B.TASK_FEATURE_DETAILS, B.REMINDER_TEMPLATE_ID, B.OBSOLETE_FLAG, T.COMPLETE_ACTION_LABEL, T.REJECT_ACTION_LABEL, T.SAVE_ACTION_LABEL, T.CALENDAR_ACTION_LABEL, T.ACTIVITY_ACTION1_LABEL, T.ACTIVITY_ACTION2_LABEL, T.ACTIVITY_ACTION3_LABEL, T.ACTIVITY_ACTION4_LABEL, T.ACTIVITY_ACTION5_LABEL, B.VIDEO_TYPE, B.DISPLAY_OPTIONS, B.VIDEO_URL, B.LEARN_ENROLLMENT_ID, B.LEARN_COMMUNITY_ID, B.LEARN_ENROLLMENT_TYPE, B.EMBED_TASK_ACTION_CODE, B.CONTENT_PROVIDER_CODE FROM PER_TASKS_IN_CHECKLIST_B B, PER_TASKS_IN_CHECKLIST_TL T WHERE B.TASK_IN_CHECKLIST_ID = T.TASK_IN_CHECKLIST_ID AND T.LANGUAGE = USERENV('LANG')

SQL_Statement

SELECT

B.TASK_IN_CHECKLIST_ID,

B.CHECKLIST_ID,

T.CHECKLIST_TASK_NAME,

B.ELIGIBILITY_OBJECT_ID,

B.AME_ATTRIBUTE_IDENTIFIER,

T.DESCRIPTION,

B.MANDATORY_FLAG,

B.TARGET_DURATION,

B.TARGET_DURATION_UOM,

B.TASK_SEQUENCE,

T.ACTION_URL,

B.BUSINESS_GROUP_ID,

B.OBJECT_VERSION_NUMBER,

B.LAST_UPDATE_DATE,

B.ELIGIBILITY_PROFILE_ID,

B.LAST_UPDATED_BY,

B.LAST_UPDATE_LOGIN,

B.CREATED_BY,

B.CREATION_DATE,

B.ATTRIBUTE_CATEGORY,

B.ATTRIBUTE1,

B.ATTRIBUTE2,

B.ATTRIBUTE3,

B.ATTRIBUTE4,

B.ATTRIBUTE5,

B.ATTRIBUTE6,

B.ATTRIBUTE7,

B.ATTRIBUTE8,

B.ATTRIBUTE9,

B.ATTRIBUTE10,

B.ATTRIBUTE11,

B.ATTRIBUTE12,

B.ATTRIBUTE13,

B.ATTRIBUTE14,

B.ATTRIBUTE15,

B.ATTRIBUTE16,

B.ATTRIBUTE17,

B.ATTRIBUTE18,

B.ATTRIBUTE19,

B.ATTRIBUTE20,

B.ATTRIBUTE21,

B.ATTRIBUTE22,

B.ATTRIBUTE23,

B.ATTRIBUTE24,

B.ATTRIBUTE25,

B.ATTRIBUTE26,

B.ATTRIBUTE27,

B.ATTRIBUTE28,

B.ATTRIBUTE29,

B.ATTRIBUTE30,

B.INFORMATION_CATEGORY,

B.INFORMATION1,

B.INFORMATION2,

B.INFORMATION3,

B.INFORMATION4,

B.INFORMATION5,

B.INFORMATION6,

B.INFORMATION7,

B.INFORMATION8,

B.INFORMATION9,

B.INFORMATION10,

B.INFORMATION11,

B.INFORMATION12,

B.INFORMATION13,

B.INFORMATION14,

B.INFORMATION15,

B.INFORMATION16,

B.INFORMATION17,

B.INFORMATION18,

B.INFORMATION19,

B.INFORMATION20,

B.INFORMATION21,

B.INFORMATION22,

B.INFORMATION23,

B.INFORMATION24,

B.INFORMATION25,

B.INFORMATION26,

B.INFORMATION27,

B.INFORMATION28,

B.INFORMATION29,

B.INFORMATION30,

B.RESPONSIBILITY_TYPE,

B.ATTRIBUTE_NUMBER1,

B.ATTRIBUTE_NUMBER2,

B.ATTRIBUTE_NUMBER3,

B.ATTRIBUTE_NUMBER4,

B.ATTRIBUTE_NUMBER5,

B.ATTRIBUTE_NUMBER6,

B.ATTRIBUTE_NUMBER7,

B.ATTRIBUTE_NUMBER8,

B.ATTRIBUTE_NUMBER9,

B.ATTRIBUTE_NUMBER10,

B.ATTRIBUTE_NUMBER11,

B.ATTRIBUTE_NUMBER12,

B.ATTRIBUTE_NUMBER13,

B.ATTRIBUTE_NUMBER14,

B.ATTRIBUTE_NUMBER15,

B.ATTRIBUTE_NUMBER16,

B.ATTRIBUTE_NUMBER17,

B.ATTRIBUTE_NUMBER18,

B.ATTRIBUTE_NUMBER19,

B.ATTRIBUTE_NUMBER20,

B.ATTRIBUTE_DATE1,

B.ATTRIBUTE_DATE2,

B.ATTRIBUTE_DATE3,

B.ATTRIBUTE_DATE4,

B.ATTRIBUTE_DATE5,

B.ATTRIBUTE_DATE6,

B.ATTRIBUTE_DATE7,

B.ATTRIBUTE_DATE8,

B.ATTRIBUTE_DATE9,

B.ATTRIBUTE_DATE10,

B.ATTRIBUTE_DATE11,

B.ATTRIBUTE_DATE12,

B.ATTRIBUTE_DATE13,

B.ATTRIBUTE_DATE14,

B.ATTRIBUTE_DATE15,

B.TASK_IN_CHECKLIST_CODE,

B.ACTIVE_INACTIVE_FLAG,

B.ALLOW_ALLC_TASK_CREATE,

B.ALLOW_ALLC_TASK_UPDATE,

B.ALLOW_ALLC_TASK_DELETE,

B.TASK_DELAY_DURATION_UOM,

B.TASK_DELAY_DURATION,

B.SGUID SGUID,

B.ADHOC_USER_GUID,

B.ACTION_TYPE,

B.TASK_ACTION_ID,

B.FLEX_CONTEXT_CODE,

B.DOCUMENT_TYPE_ID,

B.TASK_CONFIGURATION,

B.MODULE_ID,

T.USER_DISPLAY_NAME,

T.TASK_DETAILS,

B.ACTIVATION_ELIGY_PRFL_ID,

B.REMINDER_RECURRENCE,

B.REMINDER_DURATION,

B.REMINDER_RELATIVE_TO,

B.GENERATE_ATOM_FEED,

B.ATOM_FEED_CONFIGURATION,

B.SEED_DATA_SOURCE,

B.OWNER_RESP_TYPE,

B.OWNER_USER_GUID,

T.MEETING_LOCATION,

B.MEETING_OFFSET,

B.MEETING_TIME,

B.ENABLE_TASK_EXPIRY,

B.EXPIRY_AFTER_DAYS,

B.TASK_CATEGORY,

B.DETAIL_CHECKLIST_ID,

B.CONTACT_DETAILS,

B.TASK_ACTION_CODE,

B.SIGN_TEMPLATE,

B.ESIGN_TYPE,

B.REPORT_PATH,

B.QUESTIONNAIRE_ID,

T.NOTE_TITLE,

B.ATTACHMENT_DOCUMENT_TYPE_ID,

B.LEARNING_ITEM_ID,

B.LEARN_CONTENT_TYPE,

B.REPORT_PARAMETERS,

B.ANALYTICS_PATH,

B.EXPIRY_RELATIVE_TO,

B.TASK_FEATURE1,

B.TASK_FEATURE2,

B.TASK_FEATURE3,

B.TASK_FEATURE4,

B.TASK_FEATURE5,

B.TASK_FEATURE_DETAILS,

B.REMINDER_TEMPLATE_ID,

B.OBSOLETE_FLAG,

T.COMPLETE_ACTION_LABEL,

T.REJECT_ACTION_LABEL,

T.SAVE_ACTION_LABEL,

T.CALENDAR_ACTION_LABEL,

T.ACTIVITY_ACTION1_LABEL,

T.ACTIVITY_ACTION2_LABEL,

T.ACTIVITY_ACTION3_LABEL,

T.ACTIVITY_ACTION4_LABEL,

T.ACTIVITY_ACTION5_LABEL,

B.VIDEO_TYPE,

B.DISPLAY_OPTIONS,

B.VIDEO_URL,

B.LEARN_ENROLLMENT_ID,

B.LEARN_COMMUNITY_ID,

B.LEARN_ENROLLMENT_TYPE,

B.EMBED_TASK_ACTION_CODE,

B.CONTENT_PROVIDER_CODE

FROM

PER_TASKS_IN_CHECKLIST_B B,

PER_TASKS_IN_CHECKLIST_TL T

WHERE

B.TASK_IN_CHECKLIST_ID = T.TASK_IN_CHECKLIST_ID AND T.LANGUAGE = USERENV('LANG')