VIEW: APPS.PJM_DEFAULT_TASKS_WIPM_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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