Product: | ICX - Oracle iProcurement |
---|---|
Description: | Task Information Summary View by Key Member |
Implementation/DBA Data: | APPS.ICX_EDM_KEY_MEMBER_TASK_V |
SELECT DISTINCT TASK.TASK_ID
, TASK.TASK_NUMBER
, TASK.TASK_NAME
, TASK.DESCRIPTION
, PEOP.FULL_NAME TASK_MANAGER
, TASK.START_DATE
, TASK.COMPLETION_DATE
, ORG.NAME ORGANIZATION_NAME
, TASK.CARRYING_OUT_ORGANIZATION_ID ORGANIZATION_ID
, LOC.LOCATION_CODE
, LOC.DESCRIPTION
, PLAYER.PROJECT_ID
, PROJ.SEGMENT1 PROJECT_NUMBER
, PROJ.NAME PROJECT_NAME
, PROJ.DESCRIPTION
, PLAYER.PERSON_ID KEY_MEMBER_ID
, KMEM.FULL_NAME KEY_MEMBER_NAME
FROM PA_PROJECTS_ALL PROJ
, PA_TASKS TASK
, PER_PEOPLE_F PEOP
, PER_PEOPLE_F KMEM
, HR_ORGANIZATION_UNITS ORG
, HR_LOCATIONS LOC
, PA_PROJECT_PLAYERS PLAYER
WHERE TASK.PROJECT_ID = PLAYER.PROJECT_ID
AND PROJ.PROJECT_ID = PLAYER.PROJECT_ID
AND KMEM.PERSON_ID = PLAYER.PERSON_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)