Product: | PJM - Project Manufacturing |
---|---|
Description: | Material Task AutoAssignment view |
Implementation/DBA Data: | APPS.PJM_DEFAULT_TASKS_INV_V |
SELECT PDT.ROWID ROW_ID
, PDT.ASSIGNMENT_TYPE
, PDT.INVENTORY_ITEM_ID
, PDT.PO_HEADER_ID
, PHA.SEGMENT1
, PDT.CATEGORY_ID
, PDT.SUBINVENTORY_CODE
, PDT.PROJECT_ID
, PPA.SEGMENT1
, PPA.NAME
, PDT.ORGANIZATION_ID
, MP.ORGANIZATION_CODE
, HR.NAME
, PDT.CREATION_DATE
, PDT.CREATED_BY
, PDT.LAST_UPDATE_DATE
, PDT.LAST_UPDATED_BY
, PDT.LAST_UPDATE_LOGIN
, PDT.TASK_ID
, PT.TASK_NUMBER
, PT.TASK_NAME
, PDT.PROCURE_FLAG
, 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
, PO_HEADERS_ALL PHA
, PA_PROJECTS_ALL PPA
, PA_TASKS PT
, MTL_PARAMETERS MP
, HR_ORGANIZATION_UNITS HR
WHERE PDT.ASSIGNMENT_TYPE = 'MATERIAL'
AND MP.ORGANIZATION_ID = PDT.ORGANIZATION_ID
AND HR.ORGANIZATION_ID = PDT.ORGANIZATION_ID
AND PHA.PO_HEADER_ID (+) = PDT.PO_HEADER_ID
AND PT.TASK_ID = PDT.TASK_ID
AND PPA.PROJECT_ID = PDT.PROJECT_ID