1. Tables and Views for Financials
  2. FUN_DOCIO_FLOW_STEPS_VL

FUN_DOCIO_FLOW_STEPS_VL

Details

  • Schema: FUSION

  • Object owner: FUN

  • Object type: VIEW

Columns

Name

FLOW_STEP_ID

FLOW_ID

STEP_CODE

EXECUTION_SEQUENCE

STEP_TYPE_CODE

STEP_OPERATION_CODE

STEP_PROCESS_DETAILS_JSON

STEP_EXIT_RULES_JSON

DESCRIPTION

LANGUAGE

SOURCE_LANG

ENABLED_FLAG

SEED_DATA_SOURCE

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

OBJECT_VERSION_NUMBER

Query

SQL_Statement

SELECT

B.FLOW_STEP_ID,

B.FLOW_ID,

B.STEP_CODE,

B.EXECUTION_SEQUENCE,

B.STEP_TYPE_CODE,

B.STEP_OPERATION_CODE,

B.STEP_PROCESS_DETAILS_JSON,

B.STEP_EXIT_RULES_JSON,

T.DESCRIPTION,

T.LANGUAGE,

T.SOURCE_LANG,

B.ENABLED_FLAG,

B.SEED_DATA_SOURCE,

B.CREATED_BY,

B.CREATION_DATE,

B.LAST_UPDATED_BY,

B.LAST_UPDATE_DATE,

B.LAST_UPDATE_LOGIN,

B.OBJECT_VERSION_NUMBER

FROM

FUN_DOCIO_FLOW_STEPS_B B, FUN_DOCIO_FLOW_STEPS_TL T

WHERE

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