DBA Data[Home] [Help]

VIEW: APPS.FIIBV_PROJ_CLS7_LCV

Source

View Text - Preformatted

SELECT class_Code || '-' || eli.instance_code, class_code, class_code, class_category || '-' || eli.instance_code, eli.instance_code, cl.last_update_date, '_DF:PA:PA_CLASS_CODES_DESC_FLEX:cl' from pa_class_codes cl, edw_local_system_parameters ct, edw_local_instance eli WHERE cl.class_category = ct.class_categ7
View Text - HTML Formatted

SELECT CLASS_CODE || '-' || ELI.INSTANCE_CODE
, CLASS_CODE
, CLASS_CODE
, CLASS_CATEGORY || '-' || ELI.INSTANCE_CODE
, ELI.INSTANCE_CODE
, CL.LAST_UPDATE_DATE
, '_DF:PA:PA_CLASS_CODES_DESC_FLEX:CL'
FROM PA_CLASS_CODES CL
, EDW_LOCAL_SYSTEM_PARAMETERS CT
, EDW_LOCAL_INSTANCE ELI
WHERE CL.CLASS_CATEGORY = CT.CLASS_CATEG7