VIEW: APPS.EDW_BRES_DEPT_CLASS_LCV

Source

View Text - Preformatted

SELECT dc.department_class_code||'-'|| mp.organization_code||'-'|| inst.instance_code ,inst.instance_code ,nvl(mp.organization_code, 'NA_EDW') , dc.department_class_code||'('||mp.organization_code||')' ,substrb(dc.department_class_code||'('||mp.organization_code||')',1,320) ,dc.department_class_code||'('||mp.organization_code||')' ,substrb(dc.description,1,240) ,dc.creation_date ,dc.last_update_date ,NULL ,NULL ,NULL ,NULL ,NULL ,NULL FROM bom_department_classes dc, mtl_parameters mp, edw_local_instance inst WHERE dc.organization_id = mp.organization_id + 0 UNION ALL SELECT 'line-'||mp.organization_code||'-'|| inst.instance_code ,inst.instance_code ,nvl(mp.organization_code,'NA_EDW') ,ml.meaning||'('||mp.organization_code||')' ,substrb(ml.meaning,1,320) ,ml.meaning||'('||mp.organization_code||')' ,substrb(ml.description,1,240) ,ml.creation_date ,ml.last_update_date ,NULL ,NULL ,NULL ,NULL ,NULL ,NULL FROM mfg_lookups ml, mtl_parameters mp, edw_local_instance inst WHERE ml.lookup_type='CRP_REPORT_TYPE' AND ml.lookup_code=1 WITH READ ONLY

View Text - HTML Formatted

SELECT DC.DEPARTMENT_CLASS_CODE||'-'|| MP.ORGANIZATION_CODE||'-'|| INST.INSTANCE_CODE
, INST.INSTANCE_CODE
, NVL(MP.ORGANIZATION_CODE
, 'NA_EDW')
, DC.DEPARTMENT_CLASS_CODE||'('||MP.ORGANIZATION_CODE||')'
, SUBSTRB(DC.DEPARTMENT_CLASS_CODE||'('||MP.ORGANIZATION_CODE||')'
, 1
, 320)
, DC.DEPARTMENT_CLASS_CODE||'('||MP.ORGANIZATION_CODE||')'
, SUBSTRB(DC.DESCRIPTION
, 1
, 240)
, DC.CREATION_DATE
, DC.LAST_UPDATE_DATE
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
FROM BOM_DEPARTMENT_CLASSES DC
, MTL_PARAMETERS MP
, EDW_LOCAL_INSTANCE INST
WHERE DC.ORGANIZATION_ID = MP.ORGANIZATION_ID + 0 UNION ALL SELECT 'LINE-'||MP.ORGANIZATION_CODE||'-'|| INST.INSTANCE_CODE
, INST.INSTANCE_CODE
, NVL(MP.ORGANIZATION_CODE
, 'NA_EDW')
, ML.MEANING||'('||MP.ORGANIZATION_CODE||')'
, SUBSTRB(ML.MEANING
, 1
, 320)
, ML.MEANING||'('||MP.ORGANIZATION_CODE||')'
, SUBSTRB(ML.DESCRIPTION
, 1
, 240)
, ML.CREATION_DATE
, ML.LAST_UPDATE_DATE
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
FROM MFG_LOOKUPS ML
, MTL_PARAMETERS MP
, EDW_LOCAL_INSTANCE INST
WHERE ML.LOOKUP_TYPE='CRP_REPORT_TYPE'
AND ML.LOOKUP_CODE=1 WITH READ ONLY