eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: BOMBV_MFG_DEPARTMENT_RESOURCES

Product:	BOM - Bills of Material
Description:	- Retrofitted
Implementation/DBA Data:	APPS.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

Name
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