EGO_RL_RULE_IMPACT_RUNS_VL

Details

  • Schema: FUSION

  • Object owner: EGO

  • Object type: VIEW

Columns

Name

SIMULATION_CODE

SUBMITTED_BY

SUBMITTED_DATE

SIMULATION_ID

STATUS

LAST_UPDATE_DATE

LAST_UPDATED_BY

CREATION_DATE

CREATED_BY

LAST_UPDATE_LOGIN

OBJECT_VERSION_NUMBER

DESCRIPTION

REQUEST_ID

PROCESS_PROD_ITEMS_FLAG

AUTO_UPDATE_REQUEST_ID

AUTO_UPDATE_BATCH_ID

IMPORT_STATUS

Query

SQL_Statement

SELECT

EGO_RL_RULE_IMPACT_RUNS_B.SIMULATION_CODE SIMULATION_CODE,

EGO_RL_RULE_IMPACT_RUNS_B.SUBMITTED_BY SUBMITTED_BY,

EGO_RL_RULE_IMPACT_RUNS_B.SUBMITTED_DATE SUBMITTED_DATE,

EGO_RL_RULE_IMPACT_RUNS_B.SIMULATION_ID SIMULATION_ID,

EGO_RL_RULE_IMPACT_RUNS_B.STATUS STATUS,

EGO_RL_RULE_IMPACT_RUNS_B.LAST_UPDATE_DATE LAST_UPDATE_DATE,

EGO_RL_RULE_IMPACT_RUNS_B.LAST_UPDATED_BY LAST_UPDATED_BY,

EGO_RL_RULE_IMPACT_RUNS_B.CREATION_DATE CREATION_DATE,

EGO_RL_RULE_IMPACT_RUNS_B.CREATED_BY CREATED_BY,

EGO_RL_RULE_IMPACT_RUNS_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN,

EGO_RL_RULE_IMPACT_RUNS_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER,

EGO_RL_RULE_IMPACT_RUNS_TL.DESCRIPTION DESCRIPTION,

EGO_RL_RULE_IMPACT_RUNS_B.REQUEST_ID REQUEST_ID,

EGO_RL_RULE_IMPACT_RUNS_B.PROCESS_PROD_ITEMS_FLAG,

EGO_RL_RULE_IMPACT_RUNS_B.AUTO_UPDATE_REQUEST_ID,

EGO_RL_RULE_IMPACT_RUNS_B.AUTO_UPDATE_BATCH_ID,

EGO_RL_RULE_IMPACT_RUNS_B.IMPORT_STATUS

FROM

EGO_RL_RULE_IMPACT_RUNS_B,

EGO_RL_RULE_IMPACT_RUNS_TL

WHERE

EGO_RL_RULE_IMPACT_RUNS_B.SIMULATION_ID = EGO_RL_RULE_IMPACT_RUNS_TL.SIMULATION_ID AND EGO_RL_RULE_IMPACT_RUNS_TL.LANGUAGE = USERENV('LANG')