View: EDW_BRES_RESOURCE_LCV

Product:	ENG - Engineering
Description:	This view holds resource information
Implementation/DBA Data:	APPS.EDW_BRES_RESOURCE_LCV

View Text

SELECT RES.RESOURCE_CODE||'-'|| DEPT.DEPARTMENT_CODE||'-'|| MP.ORGANIZATION_CODE||'-'|| INST.INSTANCE_CODE
, INST.INSTANCE_CODE
, NVL(DEPT.DEPARTMENT_CODE||'-'||MP.ORGANIZATION_CODE||'-'|| INST.INSTANCE_CODE
, 'NA_EDW')
, NVL(DRE.RESOURCE_GROUP_NAME
, 'NA_EDW')
, NVL(RES.RESOURCE_CODE||'-'||MP.ORGANIZATION_CODE||'-'|| INST.INSTANCE_CODE
, 'NA_EDW')
, NVL(RES.RESOURCE_CODE||'-'|| MP.ORGANIZATION_CODE||'-'|| INST.INSTANCE_CODE
, 'NA_EDW')
, DEPT.DEPARTMENT_CODE||'('|| RES.RESOURCE_CODE||'('||MP.ORGANIZATION_CODE||'))'
, DEPT.DEPARTMENT_CODE||'('|| RT.MEANING ||'('||MP.ORGANIZATION_CODE||'))'
, DEPT.DEPARTMENT_CODE||'('|| RES.RESOURCE_CODE||'('|| MP.ORGANIZATION_CODE||'))'
, RES.DESCRIPTION
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, DECODE(DRE.AVAILABLE_24_HOURS_FLAG
, 1
, 'Y'
, 'N')
, GREATEST(DRE.LAST_UPDATE_DATE
, RES.LAST_UPDATE_DATE)
, DRE.CREATION_DATE
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
FROM MFG_LOOKUPS RT
, BOM_DEPARTMENTS DEPT
, BOM_RESOURCES RES
, BOM_DEPARTMENT_RESOURCES DRE
, MTL_PARAMETERS MP
, EDW_LOCAL_INSTANCE INST
WHERE DEPT.DEPARTMENT_ID = DRE.DEPARTMENT_ID
AND DRE.RESOURCE_ID = RES.RESOURCE_ID
AND RES.ORGANIZATION_ID = MP.ORGANIZATION_ID + 0
AND ((RES.LAST_UPDATE_DATE > TO_DATE('1000/01/01'
, 'YYYY/MM/DD')) OR (DRE.LAST_UPDATE_DATE > TO_DATE('1000/01/01'
, 'YYYY/MM/DD')))
AND RT.LOOKUP_TYPE = 'BOM_RESOURCE_TYPE'
AND RT.LOOKUP_CODE = RES.RESOURCE_TYPE UNION ALL SELECT L.LINE_CODE||'-'||MP.ORGANIZATION_CODE||'-'||INST.INSTANCE_CODE
, INST.INSTANCE_CODE
, NVL('LINE-'||L.LINE_CODE||'-'|| MP.ORGANIZATION_CODE||'-'|| INST.INSTANCE_CODE
, 'NA_EDW')
, 'NA_EDW'
, 'NA_EDW'
, 'NA_EDW'
, L.LINE_CODE||'('|| MP.ORGANIZATION_CODE||')'
, L.LINE_CODE
, L.LINE_CODE||'('|| MP.ORGANIZATION_CODE||')'
, L.DESCRIPTION
, L.MINIMUM_RATE
, L.MAXIMUM_RATE
, 'N'
, L.LAST_UPDATE_DATE
, L.CREATION_DATE
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
FROM WIP_LINES L
, MTL_PARAMETERS MP
, EDW_LOCAL_INSTANCE INST
WHERE L.ORGANIZATION_ID = MP.ORGANIZATION_ID /* THE FOLLOWING LINES ARE FOR OPM */ UNION ALL SELECT RS.RESOURCES||'-'||INST.INSTANCE_CODE||'-OPM'
, INST.INSTANCE_CODE
, 'NA_EDW'
, DECODE(RS.RESOURCE_CLASS
, NULL
, 'NA_EDW'
, RS.RESOURCE_CLASS||'-'||INST.INSTANCE_CODE||'-OPM')
, 'NA_EDW'
, 'NA_EDW'
, RS.RESOURCES
, RS.RESOURCES
, RS.RESOURCES
, RS.RESOURCE_DESC
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NULL
, RS.LAST_UPDATE_DATE
, RS.CREATION_DATE
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
FROM CR_RSRC_MST RS
, EDW_LOCAL_INSTANCE INST WITH READ ONLY

Columns