VIEW: APPS.CSM_TASKS_V

Source

View Text - Preformatted

SELECT CSM_UTIL_PKG.GET_NUMBER(ACC.ACCESS_ID), JT.TASK_ID, CSM_UTIL_PKG.GET_VARCHAR(JT.TASK_NUMBER), CSM_UTIL_PKG.GET_VARCHAR(TL.TASK_NAME), CSM_UTIL_PKG.GET_NUMBER(JT.TASK_TYPE_ID), CSM_UTIL_PKG.GET_NUMBER(JT.TASK_STATUS_ID), JT.TASK_PRIORITY_ID, CSM_UTIL_PKG.GET_TASK_ESC_LEVEL(JT.TASK_ID) ESCALATION_LEVEL, JT.PLANNED_START_DATE, JT.PLANNED_END_DATE, JT.PLANNED_EFFORT, JT.PLANNED_EFFORT_UOM, JT.SCHEDULED_START_DATE, JT.SCHEDULED_END_DATE, JT.SOURCE_OBJECT_ID, JT.SOURCE_OBJECT_TYPE_CODE, CSM_UTIL_PKG.GET_DATE(JT.LAST_UPDATE_DATE), JT.ATTRIBUTE_CATEGORY, JT.ATTRIBUTE1, JT.ATTRIBUTE2, JT.ATTRIBUTE3, JT.ATTRIBUTE4, JT.ATTRIBUTE5, JT.ATTRIBUTE6, JT.ATTRIBUTE7, JT.ATTRIBUTE8, JT.ATTRIBUTE9, JT.ATTRIBUTE10, JT.ATTRIBUTE11, JT.ATTRIBUTE12, JT.ATTRIBUTE13, JT.ATTRIBUTE14, JT.ATTRIBUTE15, CSM_UTIL_PKG.GET_NUMBER(JT.CREATED_BY), JT.CUSTOMER_ID, JT.ADDRESS_ID, TL.DESCRIPTION, JT.ACTUAL_START_DATE, JT.ACTUAL_END_DATE ,NVL(JT.OBJECT_VERSION_NUMBER,JT.OBJECT_VERSION_NUMBER) ,JT.ORG_ID ,JT.PRIVATE_FLAG,JT.BOUND_MODE_CODE,JT.SOURCE_OBJECT_NAME ,JT.LAPTOP_FLAG,JT.WINCE_FLAG,JT.DEVICE1_FLAG,JT.LOCATION_ID, JT.CUST_ACCOUNT_ID , CSM_UTIL_PKG.GET_NUMBER(JT.OWNER_ID) as OWNER_ID, CSM_UTIL_PKG.GET_VARCHAR(JT.OWNER_TYPE_CODE) as OWNER_TYPE_CODE , JT.ACTUAL_EFFORT , JT.ACTUAL_EFFORT_UOM, JT.DURATION, JT. DURATION_UOM, CSM_UTIL_PKG.GET_OWNER_NAME(JT.OWNER_TYPE_CODE,JT.OWNER_ID,ASG_BASE.GET_LANGUAGE) AS OWNER_NAME, CSM_UTIL_PKG.GET_NUMBER(JT.LAST_UPDATED_BY) AS LAST_UPDATED_BY, CSM_UTIL_PKG.GET_DATE(JT.LAST_UPDATE_DATE) AS SERVER_LAST_UPDATE_DATE FROM CSM_TASKS_ACC ACC, JTF_TASKS_B JT, JTF_TASKS_TL TL WHERE ACC.USER_ID = ASG_BASE.GET_USER_ID AND ACC.TASK_ID = JT.TASK_ID AND JT.TASK_ID = TL.TASK_ID AND TL.LANGUAGE = ASG_BASE.GET_LANGUAGE

View Text - HTML Formatted

SELECT CSM_UTIL_PKG.GET_NUMBER(ACC.ACCESS_ID)
, JT.TASK_ID
, CSM_UTIL_PKG.GET_VARCHAR(JT.TASK_NUMBER)
, CSM_UTIL_PKG.GET_VARCHAR(TL.TASK_NAME)
, CSM_UTIL_PKG.GET_NUMBER(JT.TASK_TYPE_ID)
, CSM_UTIL_PKG.GET_NUMBER(JT.TASK_STATUS_ID)
, JT.TASK_PRIORITY_ID
, CSM_UTIL_PKG.GET_TASK_ESC_LEVEL(JT.TASK_ID) ESCALATION_LEVEL
, JT.PLANNED_START_DATE
, JT.PLANNED_END_DATE
, JT.PLANNED_EFFORT
, JT.PLANNED_EFFORT_UOM
, JT.SCHEDULED_START_DATE
, JT.SCHEDULED_END_DATE
, JT.SOURCE_OBJECT_ID
, JT.SOURCE_OBJECT_TYPE_CODE
, CSM_UTIL_PKG.GET_DATE(JT.LAST_UPDATE_DATE)
, JT.ATTRIBUTE_CATEGORY
, JT.ATTRIBUTE1
, JT.ATTRIBUTE2
, JT.ATTRIBUTE3
, JT.ATTRIBUTE4
, JT.ATTRIBUTE5
, JT.ATTRIBUTE6
, JT.ATTRIBUTE7
, JT.ATTRIBUTE8
, JT.ATTRIBUTE9
, JT.ATTRIBUTE10
, JT.ATTRIBUTE11
, JT.ATTRIBUTE12
, JT.ATTRIBUTE13
, JT.ATTRIBUTE14
, JT.ATTRIBUTE15
, CSM_UTIL_PKG.GET_NUMBER(JT.CREATED_BY)
, JT.CUSTOMER_ID
, JT.ADDRESS_ID
, TL.DESCRIPTION
, JT.ACTUAL_START_DATE
, JT.ACTUAL_END_DATE
, NVL(JT.OBJECT_VERSION_NUMBER
, JT.OBJECT_VERSION_NUMBER)
, JT.ORG_ID
, JT.PRIVATE_FLAG
, JT.BOUND_MODE_CODE
, JT.SOURCE_OBJECT_NAME
, JT.LAPTOP_FLAG
, JT.WINCE_FLAG
, JT.DEVICE1_FLAG
, JT.LOCATION_ID
, JT.CUST_ACCOUNT_ID
, CSM_UTIL_PKG.GET_NUMBER(JT.OWNER_ID) AS OWNER_ID
, CSM_UTIL_PKG.GET_VARCHAR(JT.OWNER_TYPE_CODE) AS OWNER_TYPE_CODE
, JT.ACTUAL_EFFORT
, JT.ACTUAL_EFFORT_UOM
, JT.DURATION
, JT. DURATION_UOM
, CSM_UTIL_PKG.GET_OWNER_NAME(JT.OWNER_TYPE_CODE
, JT.OWNER_ID
, ASG_BASE.GET_LANGUAGE) AS OWNER_NAME
, CSM_UTIL_PKG.GET_NUMBER(JT.LAST_UPDATED_BY) AS LAST_UPDATED_BY
, CSM_UTIL_PKG.GET_DATE(JT.LAST_UPDATE_DATE) AS SERVER_LAST_UPDATE_DATE
FROM CSM_TASKS_ACC ACC
, JTF_TASKS_B JT
, JTF_TASKS_TL TL
WHERE ACC.USER_ID = ASG_BASE.GET_USER_ID
AND ACC.TASK_ID = JT.TASK_ID
AND JT.TASK_ID = TL.TASK_ID
AND TL.LANGUAGE = ASG_BASE.GET_LANGUAGE