PER_EDIT_NAME_SETUP

Details

Schema: FUSION
Object owner: PER
Object type: VIEW

Columns

Name
EDIT_NAME_SETUP_ID NAME_STYLE_ID ENTERPRISE_ID DISPLAY_SEQUENCE COLUMN_NAME REQUIRED_FLAG PROMPT COLUMN_LOOKUP MODULE_ID OBJECT_VERSION_NUMBER CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN SEEDED_REQUIRED_FLAG SGUID ACTIVE_FLAG

Name

EDIT_NAME_SETUP_ID

NAME_STYLE_ID

ENTERPRISE_ID

DISPLAY_SEQUENCE

COLUMN_NAME

REQUIRED_FLAG

PROMPT

COLUMN_LOOKUP

MODULE_ID

OBJECT_VERSION_NUMBER

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

SEEDED_REQUIRED_FLAG

SGUID

ACTIVE_FLAG

Query

SQL_Statement
SELECT B.EDIT_NAME_SETUP_ID, B.NAME_STYLE_ID, B.ENTERPRISE_ID, B.DISPLAY_SEQUENCE, B.COLUMN_NAME, B.REQUIRED_FLAG, T.PROMPT, B.COLUMN_LOOKUP, B.MODULE_ID, B.OBJECT_VERSION_NUMBER, B.CREATED_BY, B.CREATION_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN, B.SEEDED_REQUIRED_FLAG, B.SGUID SGUID, B.ACTIVE_FLAG FROM PER_EDIT_NAME_SETUP_B B, PER_EDIT_NAME_SETUP_TL T WHERE B.EDIT_NAME_SETUP_ID = T.EDIT_NAME_SETUP_ID AND T.LANGUAGE = USERENV('LANG')

SQL_Statement

SELECT

B.EDIT_NAME_SETUP_ID,

B.NAME_STYLE_ID,

B.ENTERPRISE_ID,

B.DISPLAY_SEQUENCE,

B.COLUMN_NAME,

B.REQUIRED_FLAG,

T.PROMPT,

B.COLUMN_LOOKUP,

B.MODULE_ID,

B.OBJECT_VERSION_NUMBER,

B.CREATED_BY,

B.CREATION_DATE,

B.LAST_UPDATED_BY,

B.LAST_UPDATE_DATE,

B.LAST_UPDATE_LOGIN,

B.SEEDED_REQUIRED_FLAG,

B.SGUID SGUID,

B.ACTIVE_FLAG

FROM

PER_EDIT_NAME_SETUP_B B,

PER_EDIT_NAME_SETUP_TL T

WHERE

B.EDIT_NAME_SETUP_ID = T.EDIT_NAME_SETUP_ID AND T.LANGUAGE = USERENV('LANG')