VIEW: APPS.ICX_EDM_PLANNER_TASK_V

Source

View Text - Preformatted

SELECT DISTINCT POD.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 , POD.PROJECT_ID , PROJ.SEGMENT1 PROJECT_NUMBER , PROJ.NAME PROJECT_NAME , PROJ.DESCRIPTION , PLANNER.EMPLOYEE_ID PLANNER_EMPLOYEE_ID , PLANEMP.FULL_NAME FROM PO_DISTRIBUTIONS POD , PO_LINES POL , MTL_SYSTEM_ITEMS ITEM , MTL_PLANNERS PLANNER , PA_TASKS TASK , PA_PROJECTS_ALL PROJ , PER_PEOPLE_F PEOP , HR_ORGANIZATION_UNITS ORG , HR_LOCATIONS LOC , PER_PEOPLE_F PLANEMP WHERE POL.PO_LINE_ID = POD.PO_LINE_ID AND ITEM.INVENTORY_ITEM_ID = POL.ITEM_ID AND PLANNER.PLANNER_CODE = ITEM.PLANNER_CODE AND PLANNER.ORGANIZATION_ID = ITEM.ORGANIZATION_ID AND TASK.PROJECT_ID = POD.PROJECT_ID AND TASK.TASK_ID = POD.TASK_ID AND PROJ.PROJECT_ID = POD.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 PLANEMP.PERSON_ID (+) = PLANNER.EMPLOYEE_ID UNION SELECT DISTINCT WDJ.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 , WDJ.PROJECT_ID , PROJ.SEGMENT1 PROJECT_NUMBER , PROJ.NAME PROJECT_NAME , PROJ.DESCRIPTION , PLANNER.EMPLOYEE_ID PLANNER_EMPLOYEE_ID , PLANEMP.FULL_NAME FROM WIP_DISCRETE_JOBS WDJ , MTL_SYSTEM_ITEMS ITEM , MTL_PLANNERS PLANNER , PA_TASKS TASK , PA_PROJECTS_ALL PROJ , PER_PEOPLE_F PEOP , HR_ORGANIZATION_UNITS ORG , HR_LOCATIONS LOC , PER_PEOPLE_F PLANEMP WHERE ITEM.INVENTORY_ITEM_ID = WDJ.PRIMARY_ITEM_ID AND PLANNER.ORGANIZATION_ID = WDJ.ORGANIZATION_ID AND ITEM.PLANNER_CODE = PLANNER.PLANNER_CODE AND ITEM.ORGANIZATION_ID = PLANNER.ORGANIZATION_ID AND TASK.PROJECT_ID = WDJ.PROJECT_ID AND TASK.TASK_ID = WDJ.TASK_ID AND PROJ.PROJECT_ID = WDJ.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 PLANEMP.PERSON_ID (+) = PLANNER.EMPLOYEE_ID UNION SELECT DISTINCT PRD.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 , PRD.PROJECT_ID , PROJ.SEGMENT1 PROJECT_NUMBER , PROJ.NAME PROJECT_NAME , PROJ.DESCRIPTION , PLANNER.EMPLOYEE_ID PLANNER_EMPLOYEE_ID , PLANEMP.FULL_NAME FROM PO_REQ_DISTRIBUTIONS PRD , PO_REQUISITION_LINES PRL , MTL_SYSTEM_ITEMS ITEM , MTL_PLANNERS PLANNER , PA_TASKS TASK , PA_PROJECTS_ALL PROJ , PER_PEOPLE_F PEOP , HR_ORGANIZATION_UNITS ORG , HR_LOCATIONS LOC , PER_PEOPLE_F PLANEMP WHERE PRL.REQUISITION_LINE_ID = PRD.REQUISITION_LINE_ID AND ITEM.INVENTORY_ITEM_ID = PRL.ITEM_ID AND PLANNER.PLANNER_CODE = ITEM.PLANNER_CODE AND PLANNER.ORGANIZATION_ID = ITEM.ORGANIZATION_ID AND TASK.PROJECT_ID = PRD.PROJECT_ID AND TASK.TASK_ID = PRD.TASK_ID AND PROJ.PROJECT_ID = PRD.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 DISTINCT POD.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
, POD.PROJECT_ID
, PROJ.SEGMENT1 PROJECT_NUMBER
, PROJ.NAME PROJECT_NAME
, PROJ.DESCRIPTION
, PLANNER.EMPLOYEE_ID PLANNER_EMPLOYEE_ID
, PLANEMP.FULL_NAME
FROM PO_DISTRIBUTIONS POD
, PO_LINES POL
, MTL_SYSTEM_ITEMS ITEM
, MTL_PLANNERS PLANNER
, PA_TASKS TASK
, PA_PROJECTS_ALL PROJ
, PER_PEOPLE_F PEOP
, HR_ORGANIZATION_UNITS ORG
, HR_LOCATIONS LOC
, PER_PEOPLE_F PLANEMP
WHERE POL.PO_LINE_ID = POD.PO_LINE_ID
AND ITEM.INVENTORY_ITEM_ID = POL.ITEM_ID
AND PLANNER.PLANNER_CODE = ITEM.PLANNER_CODE
AND PLANNER.ORGANIZATION_ID = ITEM.ORGANIZATION_ID
AND TASK.PROJECT_ID = POD.PROJECT_ID
AND TASK.TASK_ID = POD.TASK_ID
AND PROJ.PROJECT_ID = POD.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 PLANEMP.PERSON_ID (+) = PLANNER.EMPLOYEE_ID UNION SELECT DISTINCT WDJ.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
, WDJ.PROJECT_ID
, PROJ.SEGMENT1 PROJECT_NUMBER
, PROJ.NAME PROJECT_NAME
, PROJ.DESCRIPTION
, PLANNER.EMPLOYEE_ID PLANNER_EMPLOYEE_ID
, PLANEMP.FULL_NAME
FROM WIP_DISCRETE_JOBS WDJ
, MTL_SYSTEM_ITEMS ITEM
, MTL_PLANNERS PLANNER
, PA_TASKS TASK
, PA_PROJECTS_ALL PROJ
, PER_PEOPLE_F PEOP
, HR_ORGANIZATION_UNITS ORG
, HR_LOCATIONS LOC
, PER_PEOPLE_F PLANEMP
WHERE ITEM.INVENTORY_ITEM_ID = WDJ.PRIMARY_ITEM_ID
AND PLANNER.ORGANIZATION_ID = WDJ.ORGANIZATION_ID
AND ITEM.PLANNER_CODE = PLANNER.PLANNER_CODE
AND ITEM.ORGANIZATION_ID = PLANNER.ORGANIZATION_ID
AND TASK.PROJECT_ID = WDJ.PROJECT_ID
AND TASK.TASK_ID = WDJ.TASK_ID
AND PROJ.PROJECT_ID = WDJ.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 PLANEMP.PERSON_ID (+) = PLANNER.EMPLOYEE_ID UNION SELECT DISTINCT PRD.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
, PRD.PROJECT_ID
, PROJ.SEGMENT1 PROJECT_NUMBER
, PROJ.NAME PROJECT_NAME
, PROJ.DESCRIPTION
, PLANNER.EMPLOYEE_ID PLANNER_EMPLOYEE_ID
, PLANEMP.FULL_NAME
FROM PO_REQ_DISTRIBUTIONS PRD
, PO_REQUISITION_LINES PRL
, MTL_SYSTEM_ITEMS ITEM
, MTL_PLANNERS PLANNER
, PA_TASKS TASK
, PA_PROJECTS_ALL PROJ
, PER_PEOPLE_F PEOP
, HR_ORGANIZATION_UNITS ORG
, HR_LOCATIONS LOC
, PER_PEOPLE_F PLANEMP
WHERE PRL.REQUISITION_LINE_ID = PRD.REQUISITION_LINE_ID
AND ITEM.INVENTORY_ITEM_ID = PRL.ITEM_ID
AND PLANNER.PLANNER_CODE = ITEM.PLANNER_CODE
AND PLANNER.ORGANIZATION_ID = ITEM.ORGANIZATION_ID
AND TASK.PROJECT_ID = PRD.PROJECT_ID
AND TASK.TASK_ID = PRD.TASK_ID
AND PROJ.PROJECT_ID = PRD.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