Product: | PJM - Project Manufacturing |
---|---|
Description: | WIP Material Task AutoAssignment view |
Implementation/DBA Data: | APPS.PJM_DEFAULT_TASKS_WIPM_V |
SELECT PDT.ROWID
, PDT.ASSIGNMENT_TYPE
, PDT.PROJECT_ID
, PPA.SEGMENT1
, PPA.NAME
, PDT.ORGANIZATION_ID
, MP.ORGANIZATION_CODE
, HR.NAME
, PDT.TASK_ID
, PT.TASK_NUMBER
, PT.TASK_NAME
, PDT.WIP_MATL_TXN_TYPE
, PDT.WIP_ENTITY_PATTERN
, PDT.ASSEMBLY_ITEM_ID
, PDT.INVENTORY_ITEM_ID
, PDT.CATEGORY_ID
, PDT.SUBINVENTORY_CODE
, PDT.STANDARD_OPERATION_ID
, BSO.OPERATION_CODE
, PDT.DEPARTMENT_ID
, BD.DEPARTMENT_CODE
, 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
, BOM_DEPARTMENTS BD
, BOM_STANDARD_OPERATIONS BSO
, MTL_PARAMETERS MP
, HR_ORGANIZATION_UNITS HR
WHERE PDT.ASSIGNMENT_TYPE = 'WIPMAT'
AND PPA.PROJECT_ID = PDT.PROJECT_ID
AND PT.TASK_ID = PDT.TASK_ID
AND BSO.STANDARD_OPERATION_ID (+) = PDT.STANDARD_OPERATION_ID
AND BD.DEPARTMENT_ID (+) = PDT.DEPARTMENT_ID
AND MP.ORGANIZATION_ID = PDT.ORGANIZATION_ID
AND HR.ORGANIZATION_ID = PDT.ORGANIZATION_ID