VIEW: APPS.JTF_TASKS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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