View: BOMFV_MFG_DEPARTMENT_RESOURCES

Product:	BOM - Bills of Material
Description:	- Retrofitted
Implementation/DBA Data:	APPS.BOMFV_MFG_DEPARTMENT_RESOURCES

View Text

SELECT DE1.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'
, DE2.DEPARTMENT_CODE SHARED_DEPARTMENT_CODE
, AT.RULE_NAME RULE_NAME
, '_DF:BOM:BOM_DEPARTMENT_RESOURCES:DRE'
, DRE.SHARE_FROM_DEPT_ID
, DRE.DEPARTMENT_ID
, DRE.RESOURCE_ID
, DRE.ATP_RULE_ID
, DRE.EXCEPTION_SET_NAME
, DRE.LAST_UPDATE_DATE
, DRE.LAST_UPDATED_BY
, DRE.CREATION_DATE
, DRE.CREATED_BY
FROM HR_ALL_ORGANIZATION_UNITS AL
, MTL_PARAMETERS PA
, MTL_ATP_RULES AT
, BOM_DEPARTMENTS DE2
, BOM_RESOURCES RE
, BOM_DEPARTMENTS DE1
, BOM_DEPARTMENT_RESOURCES DRE
WHERE DRE.DEPARTMENT_ID = DE1.DEPARTMENT_ID
AND RE.ORGANIZATION_ID = AL.ORGANIZATION_ID
AND RE.ORGANIZATION_ID = PA.ORGANIZATION_ID
AND DRE.RESOURCE_ID = RE.RESOURCE_ID
AND DRE.ATP_RULE_ID = AT.RULE_ID(+)
AND DRE.SHARE_FROM_DEPT_ID = DE2.DEPARTMENT_ID(+)
AND '_SEC:DE1.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

Columns