VIEW: APPS.ICX_EDM_PROJECT_TASK_V

Source

View Text - Preformatted

SELECT TASK.TASK_ID , TASK.TASK_NUMBER , TASK.TASK_NAME , TASK.DESCRIPTION , PEOP.FULL_NAME MANAGER , TASK.START_DATE , TASK.COMPLETION_DATE , ORG.NAME ORGANIZATION_NAME , TASK.CARRYING_OUT_ORGANIZATION_ID ORGANIZATION_ID , LOC.LOCATION_CODE , LOC.DESCRIPTION , TASK.PROJECT_ID , PROJ.SEGMENT1 PROJECT_NUMBER , PROJ.NAME PROJECT_NAME , PROJ.DESCRIPTION FROM PA_PROJECTS_ALL PROJ , PA_TASKS TASK , PER_PEOPLE_F PEOP , HR_ORGANIZATION_UNITS ORG , HR_LOCATIONS LOC WHERE PROJ.PROJECT_ID = TASK.PROJECT_ID AND PEOP.PERSON_ID(+) = TASK.TASK_MANAGER_PERSON_ID AND ORG.ORGANIZATION_ID = TASK.CARRYING_OUT_ORGANIZATION_ID AND LOC.LOCATION_ID(+) = ORG.LOCATION_ID AND NVL(PROJ.ORG_ID,NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'), 1, 1), ' ', NULL, SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99)) = NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1), ' ', NULL, SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99)

View Text - HTML Formatted

SELECT TASK.TASK_ID
, TASK.TASK_NUMBER
, TASK.TASK_NAME
, TASK.DESCRIPTION
, PEOP.FULL_NAME MANAGER
, TASK.START_DATE
, TASK.COMPLETION_DATE
, ORG.NAME ORGANIZATION_NAME
, TASK.CARRYING_OUT_ORGANIZATION_ID ORGANIZATION_ID
, LOC.LOCATION_CODE
, LOC.DESCRIPTION
, TASK.PROJECT_ID
, PROJ.SEGMENT1 PROJECT_NUMBER
, PROJ.NAME PROJECT_NAME
, PROJ.DESCRIPTION
FROM PA_PROJECTS_ALL PROJ
, PA_TASKS TASK
, PER_PEOPLE_F PEOP
, HR_ORGANIZATION_UNITS ORG
, HR_LOCATIONS LOC
WHERE PROJ.PROJECT_ID = TASK.PROJECT_ID
AND PEOP.PERSON_ID(+) = TASK.TASK_MANAGER_PERSON_ID
AND ORG.ORGANIZATION_ID = TASK.CARRYING_OUT_ORGANIZATION_ID
AND LOC.LOCATION_ID(+) = ORG.LOCATION_ID
AND NVL(PROJ.ORG_ID
, NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)) = NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)