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

CN_COMP_PLANS_ALL_VL

Details

  • Schema: FUSION

  • Object owner: CN

  • Object type: VIEW

Columns

Name

COMP_PLAN_ID

COMP_PLAN_NAME

DISPLAY_NAME

ORG_ID

DESCRIPTION

PLAN_STATUS

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

ALLOW_ECAT_OVERLAP_FLAG

TARGET_INCENTIVE

APPROVAL_STATUS

ATTRIBUTE_CATEGORY

ATTRIBUTE1

ATTRIBUTE2

ATTRIBUTE3

ATTRIBUTE4

ATTRIBUTE5

ATTRIBUTE6

ATTRIBUTE7

ATTRIBUTE8

ATTRIBUTE9

ATTRIBUTE10

ATTRIBUTE11

ATTRIBUTE12

ATTRIBUTE13

ATTRIBUTE14

ATTRIBUTE15

START_DATE

END_DATE

OBJECT_VERSION_NUMBER

INVALID_REASON_CODE

INVALID_REASON_TOKENS

ATTRIBUTE_NUMBER1

ATTRIBUTE_NUMBER2

ATTRIBUTE_NUMBER3

ATTRIBUTE_NUMBER4

ATTRIBUTE_NUMBER5

ATTRIBUTE_NUMBER6

ATTRIBUTE_NUMBER7

ATTRIBUTE_NUMBER8

ATTRIBUTE_NUMBER9

ATTRIBUTE_NUMBER10

ATTRIBUTE_NUMBER11

ATTRIBUTE_NUMBER12

ATTRIBUTE_NUMBER13

ATTRIBUTE_NUMBER14

ATTRIBUTE_NUMBER15

ATTRIBUTE_DATE1

ATTRIBUTE_DATE2

ATTRIBUTE_DATE3

ATTRIBUTE_DATE4

ATTRIBUTE_DATE5

ATTRIBUTE_DATE6

ATTRIBUTE_DATE7

ATTRIBUTE_DATE8

ATTRIBUTE_DATE9

ATTRIBUTE_DATE10

ATTRIBUTE_DATE11

ATTRIBUTE_DATE12

ATTRIBUTE_DATE13

ATTRIBUTE_DATE14

ATTRIBUTE_DATE15

PLAN_DOC_TEMPLATE

Query

SQL_Statement

SELECT

B.COMP_PLAN_ID,

T.COMP_PLAN_NAME,

T.DISPLAY_NAME,

B.ORG_ID,

T.DESCRIPTION,

PLAN_STATUS,

B.CREATED_BY,

B.CREATION_DATE,

B.LAST_UPDATED_BY,

B.LAST_UPDATE_DATE,

B.LAST_UPDATE_LOGIN,

B.ALLOW_ECAT_OVERLAP_FLAG,

TARGET_INCENTIVE,

APPROVAL_STATUS,

ATTRIBUTE_CATEGORY,

ATTRIBUTE1,

ATTRIBUTE2,

ATTRIBUTE3,

ATTRIBUTE4,

ATTRIBUTE5,

ATTRIBUTE6,

ATTRIBUTE7,

ATTRIBUTE8,

ATTRIBUTE9,

ATTRIBUTE10,

ATTRIBUTE11,

ATTRIBUTE12,

ATTRIBUTE13,

ATTRIBUTE14,

ATTRIBUTE15,

START_DATE,

END_DATE,

B.OBJECT_VERSION_NUMBER,

B.INVALID_REASON_CODE,

B.INVALID_REASON_TOKENS,

B.ATTRIBUTE_NUMBER1,

B.ATTRIBUTE_NUMBER2,

B.ATTRIBUTE_NUMBER3,

B.ATTRIBUTE_NUMBER4,

B.ATTRIBUTE_NUMBER5,

B.ATTRIBUTE_NUMBER6,

B.ATTRIBUTE_NUMBER7,

B.ATTRIBUTE_NUMBER8,

B.ATTRIBUTE_NUMBER9,

B.ATTRIBUTE_NUMBER10,

B.ATTRIBUTE_NUMBER11,

B.ATTRIBUTE_NUMBER12,

B.ATTRIBUTE_NUMBER13,

B.ATTRIBUTE_NUMBER14,

B.ATTRIBUTE_NUMBER15,

B.ATTRIBUTE_DATE1,

B.ATTRIBUTE_DATE2,

B.ATTRIBUTE_DATE3,

B.ATTRIBUTE_DATE4,

B.ATTRIBUTE_DATE5,

B.ATTRIBUTE_DATE6,

B.ATTRIBUTE_DATE7,

B.ATTRIBUTE_DATE8,

B.ATTRIBUTE_DATE9,

B.ATTRIBUTE_DATE10,

B.ATTRIBUTE_DATE11,

B.ATTRIBUTE_DATE12,

B.ATTRIBUTE_DATE13,

B.ATTRIBUTE_DATE14,

B.ATTRIBUTE_DATE15,

B.PLAN_DOC_TEMPLATE

FROM

CN_COMP_PLANS_ALL_B B,

CN_COMP_PLANS_ALL_TL T

WHERE

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