[Home] [Help]
View: BOMFV_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
, '_DF:BOM:BOM_DEPARTMENT_CLASSES:CL'
, 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 =PA.ORGANIZATION_ID
AND CL.ORGANIZATION_ID = AL.ORGANIZATION_ID
AND '_SEC:CL.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY
Columns
Name |
DEPARTMENT_CLASS_CODE |
ORGANIZATION_CODE |
ORGANIZATION_NAME |
DESCRIPTION |
"_DF" |
ORGANIZATION_ID |
UPDATED_ON |
UPDATED_BY |
CREATED_ON |
CREATED_BY |