1. Tables and Views for Sales and Fusion Service
  2. CN_SCENARIOS_ALL_VL

CN_SCENARIOS_ALL_VL

Details

  • Schema: FUSION

  • Object owner: CN

  • Object type: VIEW

Columns

Name

SCENARIO_ID

SCENARIO_NAME

SCENARIO_DESC

SCENARIO_STATUS

START_DATE

END_DATE

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

ATTRIBUTE_CATEGORY

ATTRIBUTE1

ATTRIBUTE2

ATTRIBUTE3

ATTRIBUTE4

ATTRIBUTE5

ATTRIBUTE6

ATTRIBUTE7

ATTRIBUTE8

ATTRIBUTE9

ATTRIBUTE10

ATTRIBUTE11

ATTRIBUTE12

ATTRIBUTE13

ATTRIBUTE14

ATTRIBUTE15

ORG_ID

OBJECT_VERSION_NUMBER

Query

SQL_Statement

SELECT b.scenario_id,

SCENARIO_NAME,

SCENARIO_DESC,

scenario_status ,

b.START_DATE,

b.END_DATE,

b.created_by ,

b.creation_date ,

b.last_updated_by ,

b.last_update_date ,

b.last_update_login,

attribute_category ,

attribute1 ,

attribute2 ,

attribute3 ,

attribute4 ,

attribute5 ,

attribute6 ,

attribute7 ,

attribute8 ,

attribute9 ,

attribute10 ,

attribute11 ,

attribute12 ,

attribute13 ,

attribute14 ,

attribute15 ,

b.ORG_id ,

b.object_version_number

FROM CN_SCENARIOS_ALL_B B, CN_SCENARIOS_ALL_TL T

WHERE B.scenario_id = T.scenario_id AND T.LANGUAGE = userenv('LANG')