VIEW: APPS.ICX_EDM_CUSTOMER_TASK_V

Source

View Text - Preformatted

SELECT TASK.TASK_ID , TASK.TASK_NUMBER , TASK.TASK_NAME , TASK.DESCRIPTION , PEOP.FULL_NAME TASK_MANAGER , TASK.START_DATE , TASK.COMPLETION_DATE , ORG.NAME TASK_ORGANIZATION , TASK.CARRYING_OUT_ORGANIZATION_ID TASK_ORGANIZATION_ID , LOC.LOCATION_CODE TASK_LOCATION , LOC.DESCRIPTION TASK_LOCATION_DESCRIPTION , TASK.PROJECT_ID , PROJ.SEGMENT1 PROJECT_NUMBER , PROJ.NAME PROJECT_NAME , PROJ.DESCRIPTION PROJECT_DESCRIPTION , CUST.CUSTOMER_ID FROM PA_PROJECT_CUSTOMERS CUST , PA_PROJECTS_ALL PROJ , PA_TASKS TASK , HR_ORGANIZATION_UNITS ORG , PER_PEOPLE_F PEOP , HR_LOCATIONS LOC WHERE PEOP.PERSON_ID(+) = TASK.TASK_MANAGER_PERSON_ID AND LOC.LOCATION_ID(+) = ORG.LOCATION_ID AND ORG.ORGANIZATION_ID = TASK.CARRYING_OUT_ORGANIZATION_ID AND PROJ.PROJECT_ID = TASK.PROJECT_ID AND PROJ.PROJECT_ID = CUST.PROJECT_ID UNION SELECT DISTINCT LINE.TASK_ID , TASK.TASK_NUMBER , TASK.TASK_NAME , TASK.DESCRIPTION , PEOP.FULL_NAME TASK_MANAGER , TASK.START_DATE , TASK.COMPLETION_DATE , ORG.NAME TASK_ORGANIZATION , TASK.CARRYING_OUT_ORGANIZATION_ID TASK_ORGANIZATION_ID , LOC.LOCATION_CODE TASK_LOCATION , LOC.DESCRIPTION TASK_LOCATION_DESCRIPTION , LINE.PROJECT_ID , SEIB.PROJECT_NUMBER , SEIB.PROJECT_NAME , SEIB.PROJECT_NAME PROJECT_DESCRIPTION , HEAD.CUSTOMER_ID FROM SO_LINES LINE , SO_HEADERS HEAD , PJM_SEIBAN_NUMBERS SEIB , PA_TASKS TASK , PER_PEOPLE_F PEOP , HR_ORGANIZATION_UNITS ORG , HR_LOCATIONS LOC WHERE HEAD.HEADER_ID = LINE.HEADER_ID AND TASK.PROJECT_ID(+) = LINE.PROJECT_ID AND TASK.TASK_ID(+) = LINE.TASK_ID AND SEIB.PROJECT_ID(+) = LINE.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

View Text - HTML Formatted

SELECT TASK.TASK_ID
, TASK.TASK_NUMBER
, TASK.TASK_NAME
, TASK.DESCRIPTION
, PEOP.FULL_NAME TASK_MANAGER
, TASK.START_DATE
, TASK.COMPLETION_DATE
, ORG.NAME TASK_ORGANIZATION
, TASK.CARRYING_OUT_ORGANIZATION_ID TASK_ORGANIZATION_ID
, LOC.LOCATION_CODE TASK_LOCATION
, LOC.DESCRIPTION TASK_LOCATION_DESCRIPTION
, TASK.PROJECT_ID
, PROJ.SEGMENT1 PROJECT_NUMBER
, PROJ.NAME PROJECT_NAME
, PROJ.DESCRIPTION PROJECT_DESCRIPTION
, CUST.CUSTOMER_ID
FROM PA_PROJECT_CUSTOMERS CUST
, PA_PROJECTS_ALL PROJ
, PA_TASKS TASK
, HR_ORGANIZATION_UNITS ORG
, PER_PEOPLE_F PEOP
, HR_LOCATIONS LOC
WHERE PEOP.PERSON_ID(+) = TASK.TASK_MANAGER_PERSON_ID
AND LOC.LOCATION_ID(+) = ORG.LOCATION_ID
AND ORG.ORGANIZATION_ID = TASK.CARRYING_OUT_ORGANIZATION_ID
AND PROJ.PROJECT_ID = TASK.PROJECT_ID
AND PROJ.PROJECT_ID = CUST.PROJECT_ID UNION SELECT DISTINCT LINE.TASK_ID
, TASK.TASK_NUMBER
, TASK.TASK_NAME
, TASK.DESCRIPTION
, PEOP.FULL_NAME TASK_MANAGER
, TASK.START_DATE
, TASK.COMPLETION_DATE
, ORG.NAME TASK_ORGANIZATION
, TASK.CARRYING_OUT_ORGANIZATION_ID TASK_ORGANIZATION_ID
, LOC.LOCATION_CODE TASK_LOCATION
, LOC.DESCRIPTION TASK_LOCATION_DESCRIPTION
, LINE.PROJECT_ID
, SEIB.PROJECT_NUMBER
, SEIB.PROJECT_NAME
, SEIB.PROJECT_NAME PROJECT_DESCRIPTION
, HEAD.CUSTOMER_ID
FROM SO_LINES LINE
, SO_HEADERS HEAD
, PJM_SEIBAN_NUMBERS SEIB
, PA_TASKS TASK
, PER_PEOPLE_F PEOP
, HR_ORGANIZATION_UNITS ORG
, HR_LOCATIONS LOC
WHERE HEAD.HEADER_ID = LINE.HEADER_ID
AND TASK.PROJECT_ID(+) = LINE.PROJECT_ID
AND TASK.TASK_ID(+) = LINE.TASK_ID
AND SEIB.PROJECT_ID(+) = LINE.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