View: MRPBV_PLANNERS

Product:	MRP - Master Scheduling/MRP
Description:
Implementation/DBA Data:	APPS.MRPBV_PLANNERS

View Text

SELECT PL.PLANNER_CODE
, PA.ORGANIZATION_CODE
, AL.NAME
, PL.DESCRIPTION
, PL.ELECTRONIC_MAIL_ADDRESS
, PL.DISABLE_DATE
, PL.ORGANIZATION_ID
, PL.EMPLOYEE_ID
, PL.LAST_UPDATE_DATE
, PL.LAST_UPDATED_BY
, PL.CREATION_DATE
, PL.CREATED_BY
FROM MTL_PARAMETERS PA
, HR_ALL_ORGANIZATION_UNITS AL
, MTL_PLANNERS PL
WHERE PL.ORGANIZATION_ID = PA.ORGANIZATION_ID
AND PL.ORGANIZATION_ID = AL.ORGANIZATION_ID
AND '_SEC:PL.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

Columns