VIEW: APPS.BOMBV_MFG_DEPARTMENT_RESOURCES

Source

View Text - Preformatted

SELECT DE.DEPARTMENT_CODE , RE.RESOURCE_CODE , RE.COST_CODE_TYPE , PA.ORGANIZATION_CODE ORGANIZATION_CODE , AL.NAME ORGANIZATION_NAME , DRE.CAPACITY_UNITS CAPACITY_UNITS , DRE.RESOURCE_GROUP_NAME RESOURCE_GROUP_NAME , '_LA:DRE.AVAILABLE_24_HOURS_FLAG:MFG_LOOKUPS:SYS_YES_NO:MEANING' , '_LA:DRE.SHARE_CAPACITY_FLAG:MFG_LOOKUPS:SYS_YES_NO:MEANING' , '_LA:DRE.CTP_FLAG:MFG_LOOKUPS:SYS_YES_NO:MEANING' , DRE.EXCEPTION_SET_NAME , DRE.SHARE_FROM_DEPT_ID , DRE.DEPARTMENT_ID , DRE.RESOURCE_ID , DRE.ATP_RULE_ID , DRE.LAST_UPDATE_DATE UPDATED_ON , DRE.LAST_UPDATED_BY UPDATED_BY , DRE.CREATION_DATE CREATED_ON , DRE.CREATED_BY FROM HR_ALL_ORGANIZATION_UNITS AL , MTL_PARAMETERS PA , BOM_RESOURCES RE , BOM_DEPARTMENTS DE , BOM_DEPARTMENT_RESOURCES DRE WHERE RE.ORGANIZATION_ID = PA.ORGANIZATION_ID AND RE.ORGANIZATION_ID = AL.ORGANIZATION_ID AND DRE.DEPARTMENT_ID = DE.DEPARTMENT_ID AND DRE.RESOURCE_ID = RE.RESOURCE_ID AND '_SEC:DE.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

View Text - HTML Formatted

SELECT DE.DEPARTMENT_CODE
, RE.RESOURCE_CODE
, RE.COST_CODE_TYPE
, PA.ORGANIZATION_CODE ORGANIZATION_CODE
, AL.NAME ORGANIZATION_NAME
, DRE.CAPACITY_UNITS CAPACITY_UNITS
, DRE.RESOURCE_GROUP_NAME RESOURCE_GROUP_NAME
, '_LA:DRE.AVAILABLE_24_HOURS_FLAG:MFG_LOOKUPS:SYS_YES_NO:MEANING'
, '_LA:DRE.SHARE_CAPACITY_FLAG:MFG_LOOKUPS:SYS_YES_NO:MEANING'
, '_LA:DRE.CTP_FLAG:MFG_LOOKUPS:SYS_YES_NO:MEANING'
, DRE.EXCEPTION_SET_NAME
, DRE.SHARE_FROM_DEPT_ID
, DRE.DEPARTMENT_ID
, DRE.RESOURCE_ID
, DRE.ATP_RULE_ID
, DRE.LAST_UPDATE_DATE UPDATED_ON
, DRE.LAST_UPDATED_BY UPDATED_BY
, DRE.CREATION_DATE CREATED_ON
, DRE.CREATED_BY
FROM HR_ALL_ORGANIZATION_UNITS AL
, MTL_PARAMETERS PA
, BOM_RESOURCES RE
, BOM_DEPARTMENTS DE
, BOM_DEPARTMENT_RESOURCES DRE
WHERE RE.ORGANIZATION_ID = PA.ORGANIZATION_ID
AND RE.ORGANIZATION_ID = AL.ORGANIZATION_ID
AND DRE.DEPARTMENT_ID = DE.DEPARTMENT_ID
AND DRE.RESOURCE_ID = RE.RESOURCE_ID
AND '_SEC:DE.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY