CN_PLAN_COMPONENTS_ALL

Details

Schema: FUSION
Object owner: CN
Object type: VIEW

Columns

Name
PLAN_COMPONENT_ID CALC_VARIABLE_ID ORG_ID INCREMENTAL_TYPE START_DATE END_DATE INCENTIVE_TYPE EARNING_TYPE_ID PLAN_COMP_STATUS AP_LIAB_ID AP_EXP_ID REPORT_GROUP DELETE_FLAG PAYMENT_GROUP_CODE CALCULATION_PHASE CURRENCY_CODE INDIRECT_CREDIT THIRDPARTY_PAYEE_FLAG SALESREP_ENDDATED_FLAG APPROVAL_STATUS PLAN_COMPONENT_NAME DISPLAY_NAME DESCRIPTION ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE15 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE_CATEGORY LAST_UPDATE_DATE LAST_UPDATED_BY CREATION_DATE CREATED_BY LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER INVALID_REASON_CODE INVALID_REASON_TOKENS 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 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

Name

PLAN_COMPONENT_ID

CALC_VARIABLE_ID

ORG_ID

INCREMENTAL_TYPE

START_DATE

END_DATE

INCENTIVE_TYPE

EARNING_TYPE_ID

PLAN_COMP_STATUS

AP_LIAB_ID

AP_EXP_ID

REPORT_GROUP

DELETE_FLAG

PAYMENT_GROUP_CODE

CALCULATION_PHASE

CURRENCY_CODE

INDIRECT_CREDIT

THIRDPARTY_PAYEE_FLAG

SALESREP_ENDDATED_FLAG

APPROVAL_STATUS

PLAN_COMPONENT_NAME

DISPLAY_NAME

DESCRIPTION

ATTRIBUTE1

ATTRIBUTE2

ATTRIBUTE3

ATTRIBUTE4

ATTRIBUTE5

ATTRIBUTE6

ATTRIBUTE7

ATTRIBUTE8

ATTRIBUTE9

ATTRIBUTE10

ATTRIBUTE11

ATTRIBUTE12

ATTRIBUTE15

ATTRIBUTE13

ATTRIBUTE14

ATTRIBUTE_CATEGORY

LAST_UPDATE_DATE

LAST_UPDATED_BY

CREATION_DATE

CREATED_BY

LAST_UPDATE_LOGIN

OBJECT_VERSION_NUMBER

INVALID_REASON_CODE

INVALID_REASON_TOKENS

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

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

Query

SQL_Statement
SELECT B.PLAN_COMPONENT_ID, B.CALC_VARIABLE_ID, B.ORG_ID, B.INCREMENTAL_TYPE, B.START_DATE, B.END_DATE, B.INCENTIVE_TYPE, B.EARNING_TYPE_ID, B.PLAN_COMP_STATUS, B.AP_LIAB_ID, B.AP_EXP_ID, B.REPORT_GROUP, B.DELETE_FLAG, B.PAYMENT_GROUP_CODE, B.CALCULATION_PHASE, B.CURRENCY_CODE, B.INDIRECT_CREDIT, B.THIRDPARTY_PAYEE_FLAG, B.SALESREP_ENDDATED_FLAG, B.APPROVAL_STATUS, T.PLAN_COMPONENT_NAME, T.DISPLAY_NAME, T.DESCRIPTION, B.ATTRIBUTE1, B.ATTRIBUTE2, B.ATTRIBUTE3, B.ATTRIBUTE4, B.ATTRIBUTE5, B.ATTRIBUTE6, B.ATTRIBUTE7, B.ATTRIBUTE8, B.ATTRIBUTE9, B.ATTRIBUTE10, B.ATTRIBUTE11, B.ATTRIBUTE12, B.ATTRIBUTE15, B.ATTRIBUTE13, B.ATTRIBUTE14, B.ATTRIBUTE_CATEGORY, B.LAST_UPDATE_DATE, B.LAST_UPDATED_BY, B.CREATION_DATE, B.CREATED_BY, B.LAST_UPDATE_LOGIN, B.OBJECT_VERSION_NUMBER, B.INVALID_REASON_CODE, B.INVALID_REASON_TOKENS, 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.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 FROM CN_PLAN_COMPONENTS_ALL_B B, CN_PLAN_COMPONENTS_ALL_TL T WHERE B.PLAN_COMPONENT_ID = T.PLAN_COMPONENT_ID AND B.ORG_ID = T.ORG_ID AND T.LANGUAGE = USERENV('LANG')

SQL_Statement

SELECT

B.PLAN_COMPONENT_ID,

B.CALC_VARIABLE_ID,

B.ORG_ID,

B.INCREMENTAL_TYPE,

B.START_DATE,

B.END_DATE,

B.INCENTIVE_TYPE,

B.EARNING_TYPE_ID,

B.PLAN_COMP_STATUS,

B.AP_LIAB_ID,

B.AP_EXP_ID,

B.REPORT_GROUP,

B.DELETE_FLAG,

B.PAYMENT_GROUP_CODE,

B.CALCULATION_PHASE,

B.CURRENCY_CODE,

B.INDIRECT_CREDIT,

B.THIRDPARTY_PAYEE_FLAG,

B.SALESREP_ENDDATED_FLAG,

B.APPROVAL_STATUS,

T.PLAN_COMPONENT_NAME,

T.DISPLAY_NAME,

T.DESCRIPTION,

B.ATTRIBUTE1,

B.ATTRIBUTE2,

B.ATTRIBUTE3,

B.ATTRIBUTE4,

B.ATTRIBUTE5,

B.ATTRIBUTE6,

B.ATTRIBUTE7,

B.ATTRIBUTE8,

B.ATTRIBUTE9,

B.ATTRIBUTE10,

B.ATTRIBUTE11,

B.ATTRIBUTE12,

B.ATTRIBUTE15,

B.ATTRIBUTE13,

B.ATTRIBUTE14,

B.ATTRIBUTE_CATEGORY,

B.LAST_UPDATE_DATE,

B.LAST_UPDATED_BY,

B.CREATION_DATE,

B.CREATED_BY,

B.LAST_UPDATE_LOGIN,

B.OBJECT_VERSION_NUMBER,

B.INVALID_REASON_CODE,

B.INVALID_REASON_TOKENS,

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.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

FROM

CN_PLAN_COMPONENTS_ALL_B B,

CN_PLAN_COMPONENTS_ALL_TL T

WHERE

B.PLAN_COMPONENT_ID = T.PLAN_COMPONENT_ID AND B.ORG_ID = T.ORG_ID AND T.LANGUAGE = USERENV('LANG')