VIEW: APPS.BOMFV_MFG_DEPARTMENT_RESOURCES

Source

View Text - Preformatted

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

View Text - HTML Formatted

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