Product: | MRP - Master Scheduling/MRP |
---|---|
Description: | |
Implementation/DBA Data: | APPS.MRPBV_PLAN_RESOURCE_CAPACITIES |
SELECT AV.COMPILE_DESIGNATOR
, AV.RESOURCE_HOURS
, AV.MAX_RATE
, AV.RESOURCE_UNITS
, AV.RESOURCE_START_DATE
, AV.RESOURCE_END_DATE
, LKUP.MEANING
, 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
, CRP_AVAILABLE_RESOURCES AV
WHERE LKUP.LOOKUP_CODE = AV.UPDATED
AND LKUP.LOOKUP_TYPE = 'SYS_YES_NO'
AND '_SEC:AV.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY