VIEW: APPS.AST_TASKS_MV

Source

View Text - Preformatted

SELECT task_mb.TASK_ID, task_mb.TASK_NUMBER, task_t.TASK_NAME, task_t.DESCRIPTION, task_mb.TASK_TYPE_ID , TYPE_t.NAME task_type, task_mb.TASK_STATUS_ID , STATUS_t.NAME task_status, task_mb.closed, task_mb.cancelled, task_mb.completed, task_mb.rejected, task_mb.TASK_PRIORITY_ID, priority_t.name task_priority, task_mb.OWNER_ID, task_mb.OWNER_TYPE_CODE, OBJECT2_t.NAME owner_type, task_mb.SOURCE_OBJECT_ID, task_mb.SOURCE_OBJECT_NAME, task_mb.SOURCE_OBJECT_TYPE_CODE, OBJECT_t.NAME source_object_type, task_mb.REASON_CODE, task_mb.PRIVATE_FLAG, task_mb.PUBLISH_FLAG, task_mb.NOTIFICATION_FLAG, task_mb.CUSTOMER_ID , task_mb.ATTRIBUTE_CATEGORY, task_mb.ATTRIBUTE1, task_mb.ATTRIBUTE2, task_mb.ATTRIBUTE3, task_mb.ATTRIBUTE4 , task_mb.ATTRIBUTE5 , task_mb.ATTRIBUTE6 , task_mb.ATTRIBUTE7 , task_mb.ATTRIBUTE8 , task_mb.ATTRIBUTE9 , task_mb.ATTRIBUTE10 , task_mb.ATTRIBUTE11 , task_mb.ATTRIBUTE12 , task_mb.ATTRIBUTE13 , task_mb.ATTRIBUTE14 , task_mb.ATTRIBUTE15, task_mb.CREATED_BY , task_mb.CREATION_DATE , task_mb.LAST_UPDATED_BY , task_mb.LAST_UPDATE_DATE , task_mb.LAST_UPDATE_LOGIN , task_mb.ASSIGNED_BY_ID , task_mb.assigned_by_name, task_mb.CUST_ACCOUNT_ID , task_mb.ADDRESS_ID , task_mb.PLANNED_START_DATE , task_mb.NOTIFICATION_PERIOD , task_mb.NOTIFICATION_PERIOD_UOM , task_mb.RECURRENCE_RULE_ID, task_mb.ALARM_START , task_mb.ALARM_START_UOM, task_mb.DELETED_FLAG, task_mb.ACTUAL_START_DATE, task_mb.ACTUAL_END_DATE, task_mb.DURATION, task_mb.DURATION_UOM, task_mb.PLANNED_EFFORT, task_mb.PLANNED_EFFORT_UOM, task_mb.ACTUAL_EFFORT, task_mb.ACTUAL_EFFORT_UOM, task_mb.PERCENTAGE_COMPLETE, task_mb.PLANNED_END_DATE, task_mb.SCHEDULED_START_DATE, task_mb.SCHEDULED_END_DATE, task_mb.OBJECT_VERSION_NUMBER, task_mb.OWNER_TERRITORY_ID, task_mb.language_code lang FROM (SELECT task_b.TASK_ID, task_b.TASK_NUMBER, task_b.TASK_TYPE_ID , task_b.TASK_STATUS_ID , nvl(status_b.closed_flag,'N') closed, nvl(status_b.cancelled_flag,'N') cancelled, nvl(status_b.completed_flag,'N') completed, nvl(status_b.rejected_flag,'N') rejected, task_b.TASK_PRIORITY_ID, task_b.OWNER_ID, task_b.OWNER_TYPE_CODE, task_b.SOURCE_OBJECT_ID, task_b.SOURCE_OBJECT_NAME, task_b.SOURCE_OBJECT_TYPE_CODE, task_b.REASON_CODE, task_b.PRIVATE_FLAG, task_b.PUBLISH_FLAG, task_b.NOTIFICATION_FLAG, task_b.CUSTOMER_ID , task_b.ATTRIBUTE_CATEGORY, task_b.ATTRIBUTE1, task_b.ATTRIBUTE2, task_b.ATTRIBUTE3, task_b.ATTRIBUTE4 , task_b.ATTRIBUTE5 , task_b.ATTRIBUTE6 , task_b.ATTRIBUTE7 , task_b.ATTRIBUTE8 , task_b.ATTRIBUTE9 , task_b.ATTRIBUTE10 , task_b.ATTRIBUTE11 , task_b.ATTRIBUTE12 , task_b.ATTRIBUTE13 , task_b.ATTRIBUTE14 , task_b.ATTRIBUTE15, task_b.CREATED_BY , task_b.CREATION_DATE , task_b.LAST_UPDATED_BY , task_b.LAST_UPDATE_DATE , task_b.LAST_UPDATE_LOGIN , task_b.ASSIGNED_BY_ID , FND.USER_NAME assigned_by_name, task_b.CUST_ACCOUNT_ID , task_b.ADDRESS_ID , task_b.PLANNED_START_DATE , task_b.NOTIFICATION_PERIOD , task_b.NOTIFICATION_PERIOD_UOM , task_b.RECURRENCE_RULE_ID, task_b.ALARM_START , task_b.ALARM_START_UOM, task_b.DELETED_FLAG, task_b.ACTUAL_START_DATE, task_b.ACTUAL_END_DATE, task_b.DURATION, task_b.DURATION_UOM, task_b.PLANNED_EFFORT, task_b.PLANNED_EFFORT_UOM, task_b.ACTUAL_EFFORT, task_b.ACTUAL_EFFORT_UOM, task_b.PERCENTAGE_COMPLETE, task_b.PLANNED_END_DATE, task_b.SCHEDULED_START_DATE, task_b.SCHEDULED_END_DATE, task_b.OBJECT_VERSION_NUMBER, task_b.OWNER_TERRITORY_ID, fndlang.language_code FROM JTF_TASKS_b task_b, JTF_TASK_STATUSES_b status_b, FND_USER FND, fnd_languages fndlang WHERE fndlang.installed_flag in ('I', 'B') AND (task_b.deleted_flag <> 'Y' OR task_b.deleted_flag is null) AND task_b.task_status_id = status_b.task_status_id AND task_b.assigned_by_id = FND.USER_ID(+) AND task_b.LAST_UPDATE_DATE >= SYSDATE-NVL((select profile_option_value from fnd_profile_option_values where level_id = 10001 and (profile_option_id, application_id) = (select profile_option_id, application_id from fnd_profile_options where profile_option_name = 'AST_MV_NUM_OF_MONTH_DATA')),3)*30 ) task_mb, JTF_TASKS_tL task_t, JTF_TASK_TYPES_TL type_t, JTF_TASK_STATUSES_tL status_t, JTF_TASK_PRIORITIES_TL priority_t, JTF_OBJECTS_tL OBJECT_t, JTF_OBJECTS_tL OBJECT2_t WHERE task_mb.task_id = task_t.task_id AND task_t.language = task_mb.language_code AND task_mb.task_type_id = type_t.task_type_id AND task_mb.task_type_id <> 22 AND type_t.language = task_mb.language_code AND task_mb.task_status_id = status_t.task_status_id AND status_t.language = task_mb.language_code AND task_mb.task_priority_id = priority_t.task_priority_id(+) AND priority_t.language(+) = task_mb.language_code AND task_mb.source_object_type_code = OBJECT_t.OBJECT_CODE AND object_t.language = task_mb.language_code AND task_mb.owner_type_code = OBJECT2_t.object_code AND object2_t.language= task_mb.language_code

View Text - HTML Formatted

SELECT TASK_MB.TASK_ID
, TASK_MB.TASK_NUMBER
, TASK_T.TASK_NAME
, TASK_T.DESCRIPTION
, TASK_MB.TASK_TYPE_ID
, TYPE_T.NAME TASK_TYPE
, TASK_MB.TASK_STATUS_ID
, STATUS_T.NAME TASK_STATUS
, TASK_MB.CLOSED
, TASK_MB.CANCELLED
, TASK_MB.COMPLETED
, TASK_MB.REJECTED
, TASK_MB.TASK_PRIORITY_ID
, PRIORITY_T.NAME TASK_PRIORITY
, TASK_MB.OWNER_ID
, TASK_MB.OWNER_TYPE_CODE
, OBJECT2_T.NAME OWNER_TYPE
, TASK_MB.SOURCE_OBJECT_ID
, TASK_MB.SOURCE_OBJECT_NAME
, TASK_MB.SOURCE_OBJECT_TYPE_CODE
, OBJECT_T.NAME SOURCE_OBJECT_TYPE
, TASK_MB.REASON_CODE
, TASK_MB.PRIVATE_FLAG
, TASK_MB.PUBLISH_FLAG
, TASK_MB.NOTIFICATION_FLAG
, TASK_MB.CUSTOMER_ID
, TASK_MB.ATTRIBUTE_CATEGORY
, TASK_MB.ATTRIBUTE1
, TASK_MB.ATTRIBUTE2
, TASK_MB.ATTRIBUTE3
, TASK_MB.ATTRIBUTE4
, TASK_MB.ATTRIBUTE5
, TASK_MB.ATTRIBUTE6
, TASK_MB.ATTRIBUTE7
, TASK_MB.ATTRIBUTE8
, TASK_MB.ATTRIBUTE9
, TASK_MB.ATTRIBUTE10
, TASK_MB.ATTRIBUTE11
, TASK_MB.ATTRIBUTE12
, TASK_MB.ATTRIBUTE13
, TASK_MB.ATTRIBUTE14
, TASK_MB.ATTRIBUTE15
, TASK_MB.CREATED_BY
, TASK_MB.CREATION_DATE
, TASK_MB.LAST_UPDATED_BY
, TASK_MB.LAST_UPDATE_DATE
, TASK_MB.LAST_UPDATE_LOGIN
, TASK_MB.ASSIGNED_BY_ID
, TASK_MB.ASSIGNED_BY_NAME
, TASK_MB.CUST_ACCOUNT_ID
, TASK_MB.ADDRESS_ID
, TASK_MB.PLANNED_START_DATE
, TASK_MB.NOTIFICATION_PERIOD
, TASK_MB.NOTIFICATION_PERIOD_UOM
, TASK_MB.RECURRENCE_RULE_ID
, TASK_MB.ALARM_START
, TASK_MB.ALARM_START_UOM
, TASK_MB.DELETED_FLAG
, TASK_MB.ACTUAL_START_DATE
, TASK_MB.ACTUAL_END_DATE
, TASK_MB.DURATION
, TASK_MB.DURATION_UOM
, TASK_MB.PLANNED_EFFORT
, TASK_MB.PLANNED_EFFORT_UOM
, TASK_MB.ACTUAL_EFFORT
, TASK_MB.ACTUAL_EFFORT_UOM
, TASK_MB.PERCENTAGE_COMPLETE
, TASK_MB.PLANNED_END_DATE
, TASK_MB.SCHEDULED_START_DATE
, TASK_MB.SCHEDULED_END_DATE
, TASK_MB.OBJECT_VERSION_NUMBER
, TASK_MB.OWNER_TERRITORY_ID
, TASK_MB.LANGUAGE_CODE LANG
FROM (SELECT TASK_B.TASK_ID
, TASK_B.TASK_NUMBER
, TASK_B.TASK_TYPE_ID
, TASK_B.TASK_STATUS_ID
, NVL(STATUS_B.CLOSED_FLAG
, 'N') CLOSED
, NVL(STATUS_B.CANCELLED_FLAG
, 'N') CANCELLED
, NVL(STATUS_B.COMPLETED_FLAG
, 'N') COMPLETED
, NVL(STATUS_B.REJECTED_FLAG
, 'N') REJECTED
, TASK_B.TASK_PRIORITY_ID
, TASK_B.OWNER_ID
, TASK_B.OWNER_TYPE_CODE
, TASK_B.SOURCE_OBJECT_ID
, TASK_B.SOURCE_OBJECT_NAME
, TASK_B.SOURCE_OBJECT_TYPE_CODE
, TASK_B.REASON_CODE
, TASK_B.PRIVATE_FLAG
, TASK_B.PUBLISH_FLAG
, TASK_B.NOTIFICATION_FLAG
, TASK_B.CUSTOMER_ID
, TASK_B.ATTRIBUTE_CATEGORY
, TASK_B.ATTRIBUTE1
, TASK_B.ATTRIBUTE2
, TASK_B.ATTRIBUTE3
, TASK_B.ATTRIBUTE4
, TASK_B.ATTRIBUTE5
, TASK_B.ATTRIBUTE6
, TASK_B.ATTRIBUTE7
, TASK_B.ATTRIBUTE8
, TASK_B.ATTRIBUTE9
, TASK_B.ATTRIBUTE10
, TASK_B.ATTRIBUTE11
, TASK_B.ATTRIBUTE12
, TASK_B.ATTRIBUTE13
, TASK_B.ATTRIBUTE14
, TASK_B.ATTRIBUTE15
, TASK_B.CREATED_BY
, TASK_B.CREATION_DATE
, TASK_B.LAST_UPDATED_BY
, TASK_B.LAST_UPDATE_DATE
, TASK_B.LAST_UPDATE_LOGIN
, TASK_B.ASSIGNED_BY_ID
, FND.USER_NAME ASSIGNED_BY_NAME
, TASK_B.CUST_ACCOUNT_ID
, TASK_B.ADDRESS_ID
, TASK_B.PLANNED_START_DATE
, TASK_B.NOTIFICATION_PERIOD
, TASK_B.NOTIFICATION_PERIOD_UOM
, TASK_B.RECURRENCE_RULE_ID
, TASK_B.ALARM_START
, TASK_B.ALARM_START_UOM
, TASK_B.DELETED_FLAG
, TASK_B.ACTUAL_START_DATE
, TASK_B.ACTUAL_END_DATE
, TASK_B.DURATION
, TASK_B.DURATION_UOM
, TASK_B.PLANNED_EFFORT
, TASK_B.PLANNED_EFFORT_UOM
, TASK_B.ACTUAL_EFFORT
, TASK_B.ACTUAL_EFFORT_UOM
, TASK_B.PERCENTAGE_COMPLETE
, TASK_B.PLANNED_END_DATE
, TASK_B.SCHEDULED_START_DATE
, TASK_B.SCHEDULED_END_DATE
, TASK_B.OBJECT_VERSION_NUMBER
, TASK_B.OWNER_TERRITORY_ID
, FNDLANG.LANGUAGE_CODE
FROM JTF_TASKS_B TASK_B
, JTF_TASK_STATUSES_B STATUS_B
, FND_USER FND
, FND_LANGUAGES FNDLANG
WHERE FNDLANG.INSTALLED_FLAG IN ('I'
, 'B')
AND (TASK_B.DELETED_FLAG <> 'Y' OR TASK_B.DELETED_FLAG IS NULL)
AND TASK_B.TASK_STATUS_ID = STATUS_B.TASK_STATUS_ID
AND TASK_B.ASSIGNED_BY_ID = FND.USER_ID(+)
AND TASK_B.LAST_UPDATE_DATE >= SYSDATE-NVL((SELECT PROFILE_OPTION_VALUE
FROM FND_PROFILE_OPTION_VALUES
WHERE LEVEL_ID = 10001
AND (PROFILE_OPTION_ID
, APPLICATION_ID) = (SELECT PROFILE_OPTION_ID
, APPLICATION_ID
FROM FND_PROFILE_OPTIONS
WHERE PROFILE_OPTION_NAME = 'AST_MV_NUM_OF_MONTH_DATA'))
, 3)*30 ) TASK_MB
, JTF_TASKS_TL TASK_T
, JTF_TASK_TYPES_TL TYPE_T
, JTF_TASK_STATUSES_TL STATUS_T
, JTF_TASK_PRIORITIES_TL PRIORITY_T
, JTF_OBJECTS_TL OBJECT_T
, JTF_OBJECTS_TL OBJECT2_T
WHERE TASK_MB.TASK_ID = TASK_T.TASK_ID
AND TASK_T.LANGUAGE = TASK_MB.LANGUAGE_CODE
AND TASK_MB.TASK_TYPE_ID = TYPE_T.TASK_TYPE_ID
AND TASK_MB.TASK_TYPE_ID <> 22
AND TYPE_T.LANGUAGE = TASK_MB.LANGUAGE_CODE
AND TASK_MB.TASK_STATUS_ID = STATUS_T.TASK_STATUS_ID
AND STATUS_T.LANGUAGE = TASK_MB.LANGUAGE_CODE
AND TASK_MB.TASK_PRIORITY_ID = PRIORITY_T.TASK_PRIORITY_ID(+)
AND PRIORITY_T.LANGUAGE(+) = TASK_MB.LANGUAGE_CODE
AND TASK_MB.SOURCE_OBJECT_TYPE_CODE = OBJECT_T.OBJECT_CODE
AND OBJECT_T.LANGUAGE = TASK_MB.LANGUAGE_CODE
AND TASK_MB.OWNER_TYPE_CODE = OBJECT2_T.OBJECT_CODE
AND OBJECT2_T.LANGUAGE= TASK_MB.LANGUAGE_CODE