View: BOMBV_MFG_DEPARTMENT_CLASSES

Product:	BOM - Bills of Material
Description:	- Retrofitted
Implementation/DBA Data:	APPS.BOMBV_MFG_DEPARTMENT_CLASSES

View Text

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

Columns