VIEW: APPS.CSM_TASK_STATUSES_V

Source

View Text - Preformatted

SELECT ACC.ACCESS_ID , B.TASK_STATUS_ID , TL.NAME, B.TASK_STATUS_FLAG , B.ASSIGNMENT_STATUS_FLAG , B.CLOSED_FLAG, B.WORKING_FLAG, B.COMPLETED_FLAG, B.CANCELLED_FLAG, B.rejected_flag, B.accepted_flag, B.on_hold_flag, B.approved_flag, B.assigned_flag, B.START_DATE_ACTIVE, B.END_DATE_ACTIVE, B.SCHEDULABLE_FLAG, B.DELETE_ALLOWED_FLAG, B.USAGE, B.START_DATE_TYPE, B.END_DATE_TYPE, B.TRAVEL_FLAG, B.PLANNED_FLAG, B.ENFORCE_VALIDATION_FLAG, B.VALIDATION_START_DATE, B.VALIDATION_END_DATE FROM JTF_TASK_STATUSES_B B , JTF_TASK_STATUSES_TL TL , CSM_TASK_STATUSES_ACC ACC WHERE B.TASK_STATUS_ID = TL.TASK_STATUS_ID AND TL.LANGUAGE = ASG_BASE.GET_LANGUAGE AND ACC.TASK_STATUS_ID = B.TASK_STATUS_ID

View Text - HTML Formatted

SELECT ACC.ACCESS_ID
, B.TASK_STATUS_ID
, TL.NAME
, B.TASK_STATUS_FLAG
, B.ASSIGNMENT_STATUS_FLAG
, B.CLOSED_FLAG
, B.WORKING_FLAG
, B.COMPLETED_FLAG
, B.CANCELLED_FLAG
, B.REJECTED_FLAG
, B.ACCEPTED_FLAG
, B.ON_HOLD_FLAG
, B.APPROVED_FLAG
, B.ASSIGNED_FLAG
, B.START_DATE_ACTIVE
, B.END_DATE_ACTIVE
, B.SCHEDULABLE_FLAG
, B.DELETE_ALLOWED_FLAG
, B.USAGE
, B.START_DATE_TYPE
, B.END_DATE_TYPE
, B.TRAVEL_FLAG
, B.PLANNED_FLAG
, B.ENFORCE_VALIDATION_FLAG
, B.VALIDATION_START_DATE
, B.VALIDATION_END_DATE
FROM JTF_TASK_STATUSES_B B
, JTF_TASK_STATUSES_TL TL
, CSM_TASK_STATUSES_ACC ACC
WHERE B.TASK_STATUS_ID = TL.TASK_STATUS_ID
AND TL.LANGUAGE = ASG_BASE.GET_LANGUAGE
AND ACC.TASK_STATUS_ID = B.TASK_STATUS_ID