Product: | PJM - Project Manufacturing |
---|---|
Description: | Supply chain Task AutoAssignment view |
Implementation/DBA Data: | APPS.PJM_DEFAULT_TASKS_SCP_V |
SELECT PDT.ROWID ROW_ID
, PDT.ASSIGNMENT_TYPE
, PDT.TASK_ID
, PT.TASK_NUMBER
, PT.TASK_NAME
, PDT.PROJECT_ID
, PPA.SEGMENT1 PROJECT_NUMBER
, PPA.NAME PROJECT_NAME
, PDT.INVENTORY_ITEM_ID
, PDT.CATEGORY_ID
, PDT.ORGANIZATION_ID
, MP.ORGANIZATION_CODE
, HR.NAME ORGANIZATION_NAME
, PDT.TO_ORGANIZATION_ID
, HRO.NAME TO_ORGANIZATION_NAME
, PDT.CREATION_DATE
, PDT.CREATED_BY
, PDT.LAST_UPDATE_DATE
, PDT.LAST_UPDATED_BY
, PDT.LAST_UPDATE_LOGIN
, PDT.TASK_ATTRIBUTE_CATEGORY
, PDT.TASK_ATTRIBUTE1
, PDT.TASK_ATTRIBUTE2
, PDT.TASK_ATTRIBUTE3
, PDT.TASK_ATTRIBUTE4
, PDT.TASK_ATTRIBUTE5
, PDT.TASK_ATTRIBUTE6
, PDT.TASK_ATTRIBUTE7
, PDT.TASK_ATTRIBUTE8
, PDT.TASK_ATTRIBUTE9
, PDT.TASK_ATTRIBUTE10
, PDT.TASK_ATTRIBUTE11
, PDT.TASK_ATTRIBUTE12
, PDT.TASK_ATTRIBUTE13
, PDT.TASK_ATTRIBUTE14
, PDT.TASK_ATTRIBUTE15
, PDT.COMMENTS FROM PJM_DEFAULT_TASKS PDT
, PA_PROJECTS_ALL PPA
, PA_TASKS PT
, MTL_PARAMETERS MP
, HR_ORGANIZATION_UNITS HR
, HR_ORGANIZATION_UNITS HRO WHERE PDT.ASSIGNMENT_TYPE = 'SUPPLY CHAIN' AND PPA.PROJECT_ID = PDT.PROJECT_ID AND PT.TASK_ID = PDT.TASK_ID AND MP.ORGANIZATION_ID = PDT.ORGANIZATION_ID AND HR.ORGANIZATION_ID = PDT.ORGANIZATION_ID AND HRO.ORGANIZATION_ID = PDT.ORGANIZATION_ID