[Home] [Help]
View: BOMBV_MFG_DEPARTMENT_RESOURCES
View Text
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
Columns
| DEPARTMENT_CODE |
| RESOURCE_CODE |
| COST_CODE_TYPE |
| ORGANIZATION_CODE |
| ORGANIZATION_NAME |
| CAPACITY_UNITS |
| RESOURCE_GROUP_NAME |
| "_LA:AVAILABLE_24_HOURS_FLAG" |
| "_LA:SHARE_CAPACITY_FLAG" |
| "_LA:CTP_FLAG" |
| EXCEPTION_SET_NAME |
| SHARE_FROM_DEPT_ID |
| DEPARTMENT_ID |
| RESOURCE_ID |
| ATP_RULE_ID |
| UPDATED_ON |
| UPDATED_BY |
| CREATED_ON |
| CREATED_BY |
| Name |
APPS.BOMBV_MFG_DEPARTMENT_RESOURCES