VIEW: APPS.BOMBV_MFG_DEPARTMENTS

Source

View Text - Preformatted

SELECT DE.DEPARTMENT_CODE DEPARTMENT_CODE , PA.ORGANIZATION_CODE ORGANIZATION_CODE , AL.NAME ORGANIZATION_NAME , DE.DESCRIPTION DESCRIPTION , DE.DISABLE_DATE INACTIVE_DATE , DE.DEPARTMENT_ID , DE.DEPARTMENT_CLASS_CODE , DE.ORGANIZATION_ID , DE.LOCATION_ID , DE.PA_EXPENDITURE_ORG_ID , DE.LAST_UPDATE_DATE UPDATED_ON , DE.LAST_UPDATED_BY UPDATED_BY , DE.CREATION_DATE CREATED_ON , DE.CREATED_BY FROM HR_ALL_ORGANIZATION_UNITS AL,MTL_PARAMETERS PA,BOM_DEPARTMENTS DE WHERE DE.ORGANIZATION_ID = AL.ORGANIZATION_ID AND DE.ORGANIZATION_ID = PA.ORGANIZATION_ID AND '_SEC:DE.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

View Text - HTML Formatted

SELECT DE.DEPARTMENT_CODE DEPARTMENT_CODE
, PA.ORGANIZATION_CODE ORGANIZATION_CODE
, AL.NAME ORGANIZATION_NAME
, DE.DESCRIPTION DESCRIPTION
, DE.DISABLE_DATE INACTIVE_DATE
, DE.DEPARTMENT_ID
, DE.DEPARTMENT_CLASS_CODE
, DE.ORGANIZATION_ID
, DE.LOCATION_ID
, DE.PA_EXPENDITURE_ORG_ID
, DE.LAST_UPDATE_DATE UPDATED_ON
, DE.LAST_UPDATED_BY UPDATED_BY
, DE.CREATION_DATE CREATED_ON
, DE.CREATED_BY
FROM HR_ALL_ORGANIZATION_UNITS AL
, MTL_PARAMETERS PA
, BOM_DEPARTMENTS DE
WHERE DE.ORGANIZATION_ID = AL.ORGANIZATION_ID
AND DE.ORGANIZATION_ID = PA.ORGANIZATION_ID
AND '_SEC:DE.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY