VIEW: APPS.MRPFV_PLAN_RESOURCE_CAPACITIES

Source

View Text - Preformatted

SELECT PA.ORGANIZATION_CODE , AL.NAME , AV.COMPILE_DESIGNATOR , LI.LINE_CODE , DE.DEPARTMENT_CODE , RE.RESOURCE_CODE , AV.RESOURCE_HOURS , AV.MAX_RATE , AV.RESOURCE_UNITS , AV.RESOURCE_START_DATE , AV.RESOURCE_END_DATE , LKUP.MEANING , '_DF:CRP:CRP_AVAILABLE_RESOURCES:av' , AV.ORGANIZATION_ID , AV.LINE_ID , AV.DEPARTMENT_ID , AV.RESOURCE_ID , AV.LAST_UPDATE_DATE , AV.LAST_UPDATED_BY , AV.CREATION_DATE , AV.CREATED_BY FROM MFG_LOOKUPS LKUP ,MTL_PARAMETERS PA ,HR_ALL_ORGANIZATION_UNITS AL ,WIP_LINES LI ,BOM_DEPARTMENTS DE ,BOM_RESOURCES RE ,CRP_AVAILABLE_RESOURCES AV WHERE PA.ORGANIZATION_ID = AV.ORGANIZATION_ID AND AL.ORGANIZATION_ID = AV.ORGANIZATION_ID AND LI.LINE_ID(+) = AV.LINE_ID AND LI.ORGANIZATION_ID(+) = AV.ORGANIZATION_ID AND DE.DEPARTMENT_ID(+) = AV.DEPARTMENT_ID AND RE.RESOURCE_ID(+) = AV.RESOURCE_ID AND LKUP.LOOKUP_CODE = AV.UPDATED AND LKUP.LOOKUP_TYPE = 'SYS_YES_NO' AND '_SEC:av.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

View Text - HTML Formatted

SELECT PA.ORGANIZATION_CODE
, AL.NAME
, AV.COMPILE_DESIGNATOR
, LI.LINE_CODE
, DE.DEPARTMENT_CODE
, RE.RESOURCE_CODE
, AV.RESOURCE_HOURS
, AV.MAX_RATE
, AV.RESOURCE_UNITS
, AV.RESOURCE_START_DATE
, AV.RESOURCE_END_DATE
, LKUP.MEANING
, '_DF:CRP:CRP_AVAILABLE_RESOURCES:AV'
, AV.ORGANIZATION_ID
, AV.LINE_ID
, AV.DEPARTMENT_ID
, AV.RESOURCE_ID
, AV.LAST_UPDATE_DATE
, AV.LAST_UPDATED_BY
, AV.CREATION_DATE
, AV.CREATED_BY
FROM MFG_LOOKUPS LKUP
, MTL_PARAMETERS PA
, HR_ALL_ORGANIZATION_UNITS AL
, WIP_LINES LI
, BOM_DEPARTMENTS DE
, BOM_RESOURCES RE
, CRP_AVAILABLE_RESOURCES AV
WHERE PA.ORGANIZATION_ID = AV.ORGANIZATION_ID
AND AL.ORGANIZATION_ID = AV.ORGANIZATION_ID
AND LI.LINE_ID(+) = AV.LINE_ID
AND LI.ORGANIZATION_ID(+) = AV.ORGANIZATION_ID
AND DE.DEPARTMENT_ID(+) = AV.DEPARTMENT_ID
AND RE.RESOURCE_ID(+) = AV.RESOURCE_ID
AND LKUP.LOOKUP_CODE = AV.UPDATED
AND LKUP.LOOKUP_TYPE = 'SYS_YES_NO'
AND '_SEC:AV.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY