VIEW: APPS.MRPFV_PLAN_DEPT_RESOURCES

Source

View Text - Preformatted

SELECT PA.ORGANIZATION_CODE , AL.NAME , PL.COMPILE_DESIGNATOR , USING_DEPT.DEPARTMENT_CODE , OWNING_DEPT.DEPARTMENT_CODE , RES.RESOURCE_CODE , PL.UTILIZATION , PL.EFFICIENCY , '_DF:CRP:CRP_PLANNED_RESOURCES:pl' , PL.ORGANIZATION_ID , PL.DEPARTMENT_ID , PL.RESOURCE_ID , PL.OWNING_DEPARTMENT_ID , PL.LAST_UPDATE_DATE , PL.LAST_UPDATED_BY , PL.CREATION_DATE , PL.CREATED_BY FROM MTL_PARAMETERS PA ,HR_ALL_ORGANIZATION_UNITS AL ,BOM_DEPARTMENTS USING_DEPT ,BOM_DEPARTMENTS OWNING_DEPT ,BOM_RESOURCES RES ,CRP_PLANNED_RESOURCES PL WHERE PA.ORGANIZATION_ID = PL.ORGANIZATION_ID AND AL.ORGANIZATION_ID = PL.ORGANIZATION_ID AND PL.DEPARTMENT_ID IS NOT NULL AND USING_DEPT.DEPARTMENT_ID = PL.DEPARTMENT_ID AND OWNING_DEPT.DEPARTMENT_ID(+)= PL.OWNING_DEPARTMENT_ID AND RES.RESOURCE_ID = PL.RESOURCE_ID AND '_SEC:PL.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

View Text - HTML Formatted

SELECT PA.ORGANIZATION_CODE
, AL.NAME
, PL.COMPILE_DESIGNATOR
, USING_DEPT.DEPARTMENT_CODE
, OWNING_DEPT.DEPARTMENT_CODE
, RES.RESOURCE_CODE
, PL.UTILIZATION
, PL.EFFICIENCY
, '_DF:CRP:CRP_PLANNED_RESOURCES:PL'
, PL.ORGANIZATION_ID
, PL.DEPARTMENT_ID
, PL.RESOURCE_ID
, PL.OWNING_DEPARTMENT_ID
, PL.LAST_UPDATE_DATE
, PL.LAST_UPDATED_BY
, PL.CREATION_DATE
, PL.CREATED_BY
FROM MTL_PARAMETERS PA
, HR_ALL_ORGANIZATION_UNITS AL
, BOM_DEPARTMENTS USING_DEPT
, BOM_DEPARTMENTS OWNING_DEPT
, BOM_RESOURCES RES
, CRP_PLANNED_RESOURCES PL
WHERE PA.ORGANIZATION_ID = PL.ORGANIZATION_ID
AND AL.ORGANIZATION_ID = PL.ORGANIZATION_ID
AND PL.DEPARTMENT_ID IS NOT NULL
AND USING_DEPT.DEPARTMENT_ID = PL.DEPARTMENT_ID
AND OWNING_DEPT.DEPARTMENT_ID(+)= PL.OWNING_DEPARTMENT_ID
AND RES.RESOURCE_ID = PL.RESOURCE_ID
AND '_SEC:PL.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY