VIEW: APPS.PJM_DEFAULT_TASKS_INV_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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