Product: | JTF - CRM Foundation |
---|---|
Description: | Common View with all the task attributes. |
Implementation/DBA Data: | APPS.JTF_TASKS_V |
SELECT JTA.ROW_ID ROW_ID
, JTA.TASK_ID
, JTA.CREATED_BY
, JTA.CREATION_DATE
, JTA.LAST_UPDATED_BY
, JTA.LAST_UPDATE_DATE
, JTA.LAST_UPDATE_LOGIN
, JTA.TASK_NUMBER
, JTA.TASK_NAME
, JTA.TASK_TYPE_ID
, JTTT.NAME TASK_TYPE
, JTA.TASK_STATUS_ID
, JTST.NAME TASK_STATUS
, NVL(JTSB.CLOSED_FLAG
, 'N') CLOSED
, JTA.TASK_PRIORITY_ID
, JTPT.NAME TASK_PRIORITY
, JTA.OWNER_ID
, JTF_TASK_UTL.GET_OWNER(JTA.OWNER_TYPE_CODE
, JTA.OWNER_ID) OWNER
, JTA.OWNER_TYPE_CODE
, JTO2.NAME OWNER_TYPE
, JTA.ASSIGNED_BY_ID
, JTF_TASK_UTL.GET_USER_NAME(JTA.ASSIGNED_BY_ID) ASSIGNED_BY_NAME
, JTA.DESCRIPTION
, JTA.CUSTOMER_ID
, HZP.PARTY_NAME CUSTOMER_NAME
, HZP.PARTY_NUMBER CUSTOMER_NUMBER
, JTA.CUST_ACCOUNT_ID
, HZCA.ACCOUNT_NUMBER CUST_ACCOUNT_NUMBER
, JTA.ADDRESS_ID
, HZL.ADDRESS1
, HZL.ADDRESS2 || DECODE(HZL.ADDRESS2
, ''
, ''
, DECODE(HZL.ADDRESS3
, ''
, ''
, '
, ')) || HZL.ADDRESS3 || DECODE(HZL.ADDRESS3
, ''
, ''
, DECODE(HZL.ADDRESS4
, ''
, ''
, '
, ')) || HZL.ADDRESS4 ADDRESS2
, HZL.CITY || DECODE(HZL.CITY
, ''
, ''
, DECODE(HZL.STATE
, ''
, ''
, '
, ')) || HZL.STATE ||DECODE(HZL.STATE
, ''
, ''
, ' ') || HZL.POSTAL_CODE || DECODE(HZL.STATE
, ''
, ''
, '
, ') || HZL.COUNTRY ADDRESS3
, JTA.PLANNED_START_DATE
, JTA.PLANNED_END_DATE
, JTA.SCHEDULED_START_DATE
, JTA.SCHEDULED_END_DATE
, JTA.ACTUAL_START_DATE
, JTA.ACTUAL_END_DATE
, JTA.TIMEZONE_ID
, FTI.NAME
, FTI.GMT_OFFSET
, JTA.SOURCE_OBJECT_TYPE_CODE
, JTOT.NAME SOURCE_OBJECT_TYPE
, JTA.SOURCE_OBJECT_ID
, JTA.SOURCE_OBJECT_NAME
, JTOB.OBJECT_FUNCTION
, JTOB.OBJECT_PARAMETERS
, JTA.WORKFLOW_PROCESS_ID
, DECODE(JTA.WORKFLOW_PROCESS_ID
, NULL
, 'N'
, JTF_TASK_WORKFLOW_PKG.IS_TASK_ITEM_ACTIVE(JTA.TASK_ID
, JTA.WORKFLOW_PROCESS_ID) ) ACTIVE_WF_PROCESS
, JTTB.WORKFLOW WORKFLOW_PROCESS_NAME
, JTF_TASK_WORKFLOW_PKG.GET_WORKFLOW_DISP_NAME('JTFTASK'
, JTTB.WORKFLOW) WORKFLOW_DISPLAY_NAME
, JTA.DURATION
, JTA.DURATION_UOM
, JTA.PLANNED_EFFORT
, JTA.PLANNED_EFFORT_UOM
, JTA.ACTUAL_EFFORT
, JTA.ACTUAL_EFFORT_UOM
, JTA.PERCENTAGE_COMPLETE
, JTA.REASON_CODE
, JTA.PRIVATE_FLAG
, JTA.PUBLISH_FLAG
, JTA.RESTRICT_CLOSURE_FLAG
, JTA.MULTI_BOOKED_FLAG
, JTA.MILESTONE_FLAG
, JTA.HOLIDAY_FLAG
, JTA.BILLABLE_FLAG
, JTA.BOUND_MODE_CODE
, JTA.SOFT_BOUND_FLAG
, JTA.NOTIFICATION_FLAG
, JTA.NOTIFICATION_PERIOD
, JTA.NOTIFICATION_PERIOD_UOM
, JTA.PARENT_TASK_ID
, JTF_TASK_UTL.GET_PARENT_TASK_NUMBER(JTA.PARENT_TASK_ID) PARENT_TASK_NUMBER
, JTA.RECURRENCE_RULE_ID
, JTA.ALARM_START
, JTA.ALARM_START_UOM
, JTA.ALARM_ON
, JTA.ALARM_COUNT
, JTA.ALARM_FIRED_COUNT
, JTA.ALARM_INTERVAL
, JTA.ALARM_INTERVAL_UOM
, JTA.PALM_FLAG
, JTA.WINCE_FLAG
, JTA.LAPTOP_FLAG
, JTA.DEVICE1_FLAG
, JTA.DEVICE2_FLAG
, JTA.DEVICE3_FLAG
, JTA.DELETED_FLAG
, JTA.COSTS
, JTA.CURRENCY_CODE
, JTA.ATTRIBUTE1
, JTA.ATTRIBUTE2
, JTA.ATTRIBUTE3
, JTA.ATTRIBUTE4
, JTA.ATTRIBUTE5
, JTA.ATTRIBUTE6
, JTA.ATTRIBUTE7
, JTA.ATTRIBUTE8
, JTA.ATTRIBUTE9
, JTA.ATTRIBUTE10
, JTA.ATTRIBUTE11
, JTA.ATTRIBUTE12
, JTA.ATTRIBUTE13
, JTA.ATTRIBUTE14
, JTA.ATTRIBUTE15
, JTA.ATTRIBUTE_CATEGORY
, JTA.OBJECT_VERSION_NUMBER
, JTA.OWNER_TERRITORY_ID
, JTF_TASK_UTL.GET_TERRITORY_NAME(JTA.OWNER_TERRITORY_ID) TERR_NAME
, JTF_TASK_UTL.GET_ESCALATION_LEVEL(JTA.TASK_ID) ESCALATION_LEVEL
, JTA.OPEN_FLAG
, JTA.TEMPLATE_GROUP_ID
, JTA.TASK_CONFIRMATION_STATUS
, JTA.TASK_CONFIRMATION_COUNTER
, JTA.TASK_SPLIT_FLAG
, JTA.ENTITY
, JTA.LOCATION_ID
FROM JTF_TASKS_VL JTA
, JTF_TASK_TYPES_TL JTTT
, JTF_TASK_TYPES_B JTTB
, JTF_TASK_STATUSES_TL JTST
, JTF_TASK_STATUSES_B JTSB
, JTF_TASK_PRIORITIES_TL JTPT
, JTF_OBJECTS_TL JTOT
, JTF_OBJECTS_B JTOB
, JTF_OBJECTS_TL JTO2
, HZ_PARTIES HZP
, HZ_CUST_ACCOUNTS HZCA
, HZ_LOCATIONS HZL
, HZ_PARTY_SITES HZS
, FND_TIMEZONES_VL FTI
WHERE JTA.TASK_TYPE_ID = JTTB.TASK_TYPE_ID
AND JTA.TASK_STATUS_ID = JTSB.TASK_STATUS_ID
AND (JTA.DELETED_FLAG != 'Y' OR JTA.DELETED_FLAG IS NULL)
AND JTA.TASK_PRIORITY_ID = JTPT.TASK_PRIORITY_ID (+)
AND JTA.CUSTOMER_ID = HZP.PARTY_ID (+)
AND JTA.CUST_ACCOUNT_ID = HZCA.CUST_ACCOUNT_ID (+)
AND JTA.ADDRESS_ID = HZS.PARTY_SITE_ID (+)
AND HZS.LOCATION_ID = HZL.LOCATION_ID (+)
AND JTA.SOURCE_OBJECT_TYPE_CODE = JTOB.OBJECT_CODE
AND JTA.OWNER_TYPE_CODE = JTO2.OBJECT_CODE
AND JTA.TIMEZONE_ID = FTI.UPGRADE_TZ_ID (+)
AND JTTB.TASK_TYPE_ID <> 22
AND NVL(JTPT.LANGUAGE
, USERENV('LANG')) = USERENV('LANG')
AND JTTT.LANGUAGE = USERENV('LANG')
AND JTTT.TASK_TYPE_ID = JTA.TASK_TYPE_ID
AND JTST.LANGUAGE = USERENV('LANG')
AND JTST.TASK_STATUS_ID = JTA.TASK_STATUS_ID
AND JTOT.LANGUAGE = USERENV('LANG')
AND JTOT.OBJECT_CODE = JTOB.OBJECT_CODE
AND JTO2.LANGUAGE = USERENV('LANG')