HWM_TCSMR_XFR_PROCESSES

Details

Schema: FUSION
Object owner: HWM
Object type: VIEW

Columns

Name
TCSMR_XFR_PROCESS_ID TCSMR_XFR_PROCESS_CODE TCSMRS_ID PENDING_ENTRIES_THRESHOLD ENTERPRISE_ID OBJECT_VERSION_NUMBER CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN NAME SGUID

Name

TCSMR_XFR_PROCESS_ID

TCSMR_XFR_PROCESS_CODE

TCSMRS_ID

PENDING_ENTRIES_THRESHOLD

ENTERPRISE_ID

OBJECT_VERSION_NUMBER

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

NAME

SGUID

Query

SQL_Statement
SELECT HWM_TCSMR_XFR_PROCESSES_B.TCSMR_XFR_PROCESS_ID, HWM_TCSMR_XFR_PROCESSES_B.TCSMR_XFR_PROCESS_CODE, HWM_TCSMR_XFR_PROCESSES_B.TCSMRS_ID, HWM_TCSMR_XFR_PROCESSES_B.PENDING_ENTRIES_THRESHOLD, HWM_TCSMR_XFR_PROCESSES_B.ENTERPRISE_ID, HWM_TCSMR_XFR_PROCESSES_B.OBJECT_VERSION_NUMBER, HWM_TCSMR_XFR_PROCESSES_B.CREATED_BY, HWM_TCSMR_XFR_PROCESSES_B.CREATION_DATE, HWM_TCSMR_XFR_PROCESSES_B.LAST_UPDATED_BY, HWM_TCSMR_XFR_PROCESSES_B.LAST_UPDATE_DATE, HWM_TCSMR_XFR_PROCESSES_B.LAST_UPDATE_LOGIN, HWM_TCSMR_XFR_PROCESSES_TL.NAME, HWM_TCSMR_XFR_PROCESSES_B.SGUID SGUID FROM HWM_TCSMR_XFR_PROCESSES_B, HWM_TCSMR_XFR_PROCESSES_TL WHERE HWM_TCSMR_XFR_PROCESSES_B.TCSMR_XFR_PROCESS_ID = HWM_TCSMR_XFR_PROCESSES_TL.TCSMR_XFR_PROCESS_ID AND HWM_TCSMR_XFR_PROCESSES_TL.LANGUAGE = USERENV('LANG')

SQL_Statement

SELECT

HWM_TCSMR_XFR_PROCESSES_B.TCSMR_XFR_PROCESS_ID,

HWM_TCSMR_XFR_PROCESSES_B.TCSMR_XFR_PROCESS_CODE,

HWM_TCSMR_XFR_PROCESSES_B.TCSMRS_ID,

HWM_TCSMR_XFR_PROCESSES_B.PENDING_ENTRIES_THRESHOLD,

HWM_TCSMR_XFR_PROCESSES_B.ENTERPRISE_ID,

HWM_TCSMR_XFR_PROCESSES_B.OBJECT_VERSION_NUMBER,

HWM_TCSMR_XFR_PROCESSES_B.CREATED_BY,

HWM_TCSMR_XFR_PROCESSES_B.CREATION_DATE,

HWM_TCSMR_XFR_PROCESSES_B.LAST_UPDATED_BY,

HWM_TCSMR_XFR_PROCESSES_B.LAST_UPDATE_DATE,

HWM_TCSMR_XFR_PROCESSES_B.LAST_UPDATE_LOGIN,

HWM_TCSMR_XFR_PROCESSES_TL.NAME,

HWM_TCSMR_XFR_PROCESSES_B.SGUID SGUID

FROM

HWM_TCSMR_XFR_PROCESSES_B,

HWM_TCSMR_XFR_PROCESSES_TL

WHERE

HWM_TCSMR_XFR_PROCESSES_B.TCSMR_XFR_PROCESS_ID = HWM_TCSMR_XFR_PROCESSES_TL.TCSMR_XFR_PROCESS_ID AND HWM_TCSMR_XFR_PROCESSES_TL.LANGUAGE = USERENV('LANG')