VIEW: APPS.EDW_BRES_RESCAT_LCV

Source

View Text - Preformatted

SELECT RC.RESOURCE_CODE||'-'|| mp.organization_code||'-'|| inst.instance_code ,inst.instance_code ,nvl(mp.organization_code, 'NA_EDW') ,nvl(RT.meaning,'NA_EDW') ,RC.RESOURCE_CODE||'('||mp.organization_code||')' ,substrb(RT.MEANING||'('||mp.organization_code||')',1,320) ,substrb(RC.DESCRIPTION,1,240) ,RC.LAST_UPDATE_DATE ,RC.CREATION_DATE ,NULL ,NULL ,NULL ,NULL ,NULL ,NULL FROM mfg_lookups rt, bom_resources rc, mtl_parameters mp, edw_local_instance inst WHERE rt.lookup_type = 'BOM_RESOURCE_TYPE' and rt.lookup_code = rc.resource_type and rc.organization_id = mp.organization_id + 0 WITH READ ONLY

View Text - HTML Formatted

SELECT RC.RESOURCE_CODE||'-'|| MP.ORGANIZATION_CODE||'-'|| INST.INSTANCE_CODE
, INST.INSTANCE_CODE
, NVL(MP.ORGANIZATION_CODE
, 'NA_EDW')
, NVL(RT.MEANING
, 'NA_EDW')
, RC.RESOURCE_CODE||'('||MP.ORGANIZATION_CODE||')'
, SUBSTRB(RT.MEANING||'('||MP.ORGANIZATION_CODE||')'
, 1
, 320)
, SUBSTRB(RC.DESCRIPTION
, 1
, 240)
, RC.LAST_UPDATE_DATE
, RC.CREATION_DATE
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
FROM MFG_LOOKUPS RT
, BOM_RESOURCES RC
, MTL_PARAMETERS MP
, EDW_LOCAL_INSTANCE INST
WHERE RT.LOOKUP_TYPE = 'BOM_RESOURCE_TYPE'
AND RT.LOOKUP_CODE = RC.RESOURCE_TYPE
AND RC.ORGANIZATION_ID = MP.ORGANIZATION_ID + 0 WITH READ ONLY