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

CN_SIM_SRP_PER_FORM_EXTS_ALL_V

Details

  • Schema: FUSION

  • Object owner: CN

  • Object type: VIEW

Columns

Name

SIMULATION_ID

SIMULATION_DELETE_FLAG

SRP_PER_FORMULA_EXT_ID

SRP_PER_FORM_METRIC_ID

SRP_COMP_PLAN_ID

PARTICIPANT_ID

COMP_PLAN_ID

PLAN_COMPONENT_ID

PERIOD_ID

FORMULA_ID

INPUT_SEQUENCE

INPUT_ACHIEVED_PTD

INPUT_ACHIEVED_ITD

ATTRIBUTE_CATEGORY

ATTRIBUTE1

ATTRIBUTE2

ATTRIBUTE3

ATTRIBUTE4

ATTRIBUTE5

ATTRIBUTE6

ATTRIBUTE7

ATTRIBUTE8

ATTRIBUTE9

ATTRIBUTE10

ATTRIBUTE11

ATTRIBUTE12

ATTRIBUTE13

ATTRIBUTE14

ATTRIBUTE15

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

ORG_ID

OBJECT_VERSION_NUMBER

Query

SQL_Statement

select "SIMULATION_ID","SIMULATION_DELETE_FLAG","SRP_PER_FORMULA_EXT_ID","SRP_PER_FORM_METRIC_ID","SRP_COMP_PLAN_ID","PARTICIPANT_ID","COMP_PLAN_ID","PLAN_COMPONENT_ID","PERIOD_ID","FORMULA_ID","INPUT_SEQUENCE","INPUT_ACHIEVED_PTD","INPUT_ACHIEVED_ITD","ATTRIBUTE_CATEGORY","ATTRIBUTE1","ATTRIBUTE2","ATTRIBUTE3","ATTRIBUTE4","ATTRIBUTE5","ATTRIBUTE6","ATTRIBUTE7","ATTRIBUTE8","ATTRIBUTE9","ATTRIBUTE10","ATTRIBUTE11","ATTRIBUTE12","ATTRIBUTE13","ATTRIBUTE14","ATTRIBUTE15","CREATED_BY","CREATION_DATE","LAST_UPDATED_BY","LAST_UPDATE_DATE","LAST_UPDATE_LOGIN","ORG_ID","OBJECT_VERSION_NUMBER" from CN_SIM_SRP_PER_FORM_EXTS_ALL

where simulation_id = to_number(sys_context('fusion_ic_cn', 'calc_simulation_id'))