CML_LCP_PROCESSES_VL

Details

• Schema: FUSION

• Object owner: CML

• Object type: VIEW

Columns

Name
LCP_PROCESS_ID OBJECT_VERSION_NUMBER NAME COMMIT_LIMIT DESCRIPTION LAST_RUN_DATE LAST_REQUEST_ID CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN

Query

SQL_Statement

SELECT CML_LCP_PROCESSES_B.LCP_PROCESS_ID LCP_PROCESS_ID, CML_LCP_PROCESSES_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, CML_LCP_PROCESSES_B.NAME NAME, CML_LCP_PROCESSES_B.COMMIT_LIMIT, CML_LCP_PROCESSES_TL.DESCRIPTION DESCRIPTION, CML_LCP_PROCESSES_B.LAST_RUN_DATE LAST_RUN_DATE, CML_LCP_PROCESSES_B.LAST_REQUEST_ID LAST_REQUEST_ID, CML_LCP_PROCESSES_B.CREATED_BY CREATED_BY, CML_LCP_PROCESSES_B.CREATION_DATE CREATION_DATE, CML_LCP_PROCESSES_B.LAST_UPDATED_BY LAST_UPDATED_BY, CML_LCP_PROCESSES_B.LAST_UPDATE_DATE LAST_UPDATE_DATE, CML_LCP_PROCESSES_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN FROM CML_LCP_PROCESSES_B, CML_LCP_PROCESSES_TL WHERE CML_LCP_PROCESSES_B.LCP_PROCESS_ID = CML_LCP_PROCESSES_TL.LCP_PROCESS_ID AND CML_LCP_PROCESSES_TL.LANGUAGE = USERENV('LANG')