VIEW: APPS.MRPFV_PLANNERS

Source

View Text - Preformatted

SELECT DISTINCT PL.PLANNER_CODE , PA.ORGANIZATION_CODE , AL.NAME , PL.DESCRIPTION , PEOPLE.FULL_NAME , PL.ELECTRONIC_MAIL_ADDRESS , PL.DISABLE_DATE , '_DF:INV:MTL_PLANNERS:pl' , PL.ORGANIZATION_ID , PL.EMPLOYEE_ID , PL.LAST_UPDATE_DATE , PL.LAST_UPDATED_BY , PL.CREATION_DATE , PL.CREATED_BY FROM PER_ALL_PEOPLE_F PEOPLE ,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 PL.EMPLOYEE_ID = PEOPLE.PERSON_ID(+) AND '_SEC:PL.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

View Text - HTML Formatted

SELECT DISTINCT PL.PLANNER_CODE
, PA.ORGANIZATION_CODE
, AL.NAME
, PL.DESCRIPTION
, PEOPLE.FULL_NAME
, PL.ELECTRONIC_MAIL_ADDRESS
, PL.DISABLE_DATE
, '_DF:INV:MTL_PLANNERS:PL'
, PL.ORGANIZATION_ID
, PL.EMPLOYEE_ID
, PL.LAST_UPDATE_DATE
, PL.LAST_UPDATED_BY
, PL.CREATION_DATE
, PL.CREATED_BY
FROM PER_ALL_PEOPLE_F PEOPLE
, 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 PL.EMPLOYEE_ID = PEOPLE.PERSON_ID(+)
AND '_SEC:PL.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY