eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.BOMBV_MFG_DEPARTMENT_CLASSES

Source

View Text - Preformatted


SELECT CL.DEPARTMENT_CLASS_CODE DEPARTMENT_CLASS_CODE , PA.ORGANIZATION_CODE ORGANIZATION_CODE , AL.NAME ORGANIZATION_NAME , CL.DESCRIPTION DESCRIPTION , CL.ORGANIZATION_ID , CL.LAST_UPDATE_DATE UPDATED_ON , CL.LAST_UPDATED_BY UPDATED_BY , CL.CREATION_DATE CREATED_ON ,CL.CREATED_BY FROM HR_ALL_ORGANIZATION_UNITS AL,MTL_PARAMETERS PA,BOM_DEPARTMENT_CLASSES CL WHERE CL.ORGANIZATION_ID = AL.ORGANIZATION_ID AND CL.ORGANIZATION_ID = PA.ORGANIZATION_ID AND '_SEC:CL.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

View Text - HTML Formatted

SELECT CL.DEPARTMENT_CLASS_CODE DEPARTMENT_CLASS_CODE
, PA.ORGANIZATION_CODE ORGANIZATION_CODE
, AL.NAME ORGANIZATION_NAME
, CL.DESCRIPTION DESCRIPTION
, CL.ORGANIZATION_ID
, CL.LAST_UPDATE_DATE UPDATED_ON
, CL.LAST_UPDATED_BY UPDATED_BY
, CL.CREATION_DATE CREATED_ON
, CL.CREATED_BY
FROM HR_ALL_ORGANIZATION_UNITS AL
, MTL_PARAMETERS PA
, BOM_DEPARTMENT_CLASSES CL
WHERE CL.ORGANIZATION_ID = AL.ORGANIZATION_ID
AND CL.ORGANIZATION_ID = PA.ORGANIZATION_ID
AND '_SEC:CL.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY