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

CN_SIM_SRP_PER_FORM_METR_ALL_V

Details

  • Schema: FUSION

  • Object owner: CN

  • Object type: VIEW

Columns

Name

SIMULATION_ID

SIMULATION_DELETE_FLAG

SRP_PER_FORM_METRIC_ID

CURRENCY_CODE

SRP_COMP_PLAN_ID

SRP_PLAN_COMPONENT_ID

SRP_FORM_METRIC_ID

COMP_PLAN_ID

PLAN_COMPONENT_ID

FORMULA_ID

GOAL_ID

PARTICIPANT_ID

PERIOD_ID

COMMISSION_PAID_PTD

COMMISSION_PAID_ITD

COMMISSION_PAID_TUITD

INPUT_ACHIEVED_PTD

INPUT_ACHIEVED_ITD

OUTPUT_ACHIEVED_PTD

OUTPUT_ACHIEVED_ITD

ADVANCE_RECOVERED_PTD

ADVANCE_RECOVERED_ITD

ADVANCE_TO_REC_PTD

ADVANCE_TO_REC_ITD

COMMISSION_PEND_PTD

COMMISSION_PEND_ITD

RECOVERY_AMOUNT_PTD

RECOVERY_AMOUNT_ITD

ROLLOVER

TRANSACTION_AMOUNT_PTD

TRANSACTION_AMOUNT_ITD

PARTICIPANT_RANK

RANK_REQUEST_ID

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_FORM_METRIC_ID","CURRENCY_CODE","SRP_COMP_PLAN_ID","SRP_PLAN_COMPONENT_ID","SRP_FORM_METRIC_ID","COMP_PLAN_ID","PLAN_COMPONENT_ID","FORMULA_ID","GOAL_ID","PARTICIPANT_ID","PERIOD_ID","COMMISSION_PAID_PTD","COMMISSION_PAID_ITD","COMMISSION_PAID_TUITD","INPUT_ACHIEVED_PTD","INPUT_ACHIEVED_ITD","OUTPUT_ACHIEVED_PTD","OUTPUT_ACHIEVED_ITD","ADVANCE_RECOVERED_PTD","ADVANCE_RECOVERED_ITD","ADVANCE_TO_REC_PTD","ADVANCE_TO_REC_ITD","COMMISSION_PEND_PTD","COMMISSION_PEND_ITD","RECOVERY_AMOUNT_PTD","RECOVERY_AMOUNT_ITD","ROLLOVER","TRANSACTION_AMOUNT_PTD","TRANSACTION_AMOUNT_ITD","PARTICIPANT_RANK","RANK_REQUEST_ID","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_METR_ALL

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