1. Tables and Views for SCM
  2. MSC_SOP_PLAN_CYCLE_VL

MSC_SOP_PLAN_CYCLE_VL

Details

  • Schema: FUSION

  • Object owner: MSC

  • Object type: VIEW

Columns

Name

PLAN_CYCLE_ID

START_DATE

END_DATE

OWNER

OBJECT_VERSION_NUMBER

LAST_UPDATED_BY

LAST_UPDATE_DATE

CREATION_DATE

CREATED_BY

LAST_UPDATE_LOGIN

USAGE_STATUS

PLAN_CYCLE_NAME

PLAN_CYCLE_DESC

REDWOOD_FLAG

Query

SQL_Statement

SELECT

B.PLAN_CYCLE_ID,

B.START_DATE,

B.END_DATE,

B.OWNER,

B.OBJECT_VERSION_NUMBER ,

B.LAST_UPDATED_BY ,

B.LAST_UPDATE_DATE ,

B.CREATION_DATE ,

B.CREATED_BY ,

B.LAST_UPDATE_LOGIN ,

B.USAGE_STATUS,

T.PLAN_CYCLE_NAME ,

T.PLAN_CYCLE_DESC,

B.REDWOOD_FLAG

FROM

MSC_SOP_PLAN_CYCLE_B B,

MSC_SOP_PLAN_CYCLE_TL T

WHERE B.PLAN_CYCLE_ID = T.PLAN_CYCLE_ID

AND T.language = USERENV('LANG')