CN_REPOSITORIES_ALL_VL

Details

  • Schema: FUSION

  • Object owner: CN

  • Object type: VIEW

Columns

Name

REPOSITORY_ID

CALENDAR_ID

PERIOD_TYPE_ID

FUNCTIONAL_CURRENCY

PROCESS_CURRENCY

CN_CONVERSION_TYPE

PAYMENT_CONV_TYPE

PAYMENT_DATE_CONV

RESET_BAL_YEAR

HR_SUPER_HIERARCHY_DEPTH

ANALYST_HIERARCHY_DEPTH

PLAN_APPROVAL_ENABLE_FLAG

CUSTOM_TARGET_INCENTIVE

CN_CUST_PLAN_COMP_FLAG

CN_COMM_RATE_PRECISION

AUTO_NOTES_PLAN_RULE

PLAN_APPROVAL_STATUS

PAYSHEETAPPROVAL_STATUS

ENABLE_CLASSIFY

CLASSIFY_TRANSACTION

ENABLE_CREDIT

SRP_ROLLUP_FLAG

ROLLUP_USING

AGGR_TRANS_ROLLUP

CN_CUSTOM_AGGR_TRX

CLASSIFY_BATCH_OPTION

CLASSIFY_BATCH_SIZE

TRX_ROLLUP_METHOD

ROLLUP_BATCH_SIZE

BATCH_RUNNER_STATUS

PAY_PART_BATCH_SIZE

PARTICIPANT_BATCH_SIZE

REPORT_HIERARCHY_ID

CN_DISPLAY_DRAW

YTD_SUMMARY

ATTAINMENT_SUMMARY

COMMISSION_STATEMENT

CREDIT_DETAILS

EARNING_DETAILS

PAYMENT_DETAILS

ORG_ID

OBJECT_VERSION_NUMBER

STATUS

APPLICATION_TYPE

LAST_UPDATE_DATE

LAST_UPDATED_BY

CREATION_DATE

CREATED_BY

LAST_UPDATE_LOGIN

APPLICATION_ID

REPOSITORY_TYPE

COLL_CONV_TYPE

ENABLE_NEGATIVE_PAY

ANALYST_SECURITY

REPOSITORY_NAME

ORG_NAME

MIN_PMT_APPR_AMT

MAX_PMT_APPR_AMT

COLL_CAN_TRX_ZERO

PLAN_IMPORT_RESOLVE

CUSTOM_ROLLUP_PROCEDURE

DEFAULT_PLAN_DOC_TEMPLATE

PAYMENT_HOME_CURRENCY_AMOUNT

ROLE_ASGN_REVIEW_NEW

ROLE_ASGN_REVIEW_OLD

ENABLE_PARTICIPANT_TERMINATE

COMP_END_DATE_PERIOD_OPTIONS

COMP_END_DATE_PERIOD_COUNT

COMP_PLAN_ASSIGN_TERMINATE

PAYMENT_PLAN_ASSIGN_TERMINATE

TRX_CALC_METHOD

CALC_BATCH_SIZE

WORKER_INFORMATION

CN_CUST_PLAN_COMP_OPTION

DISABLE_INCR_CALCULATION

ALLOW_FUTURE_DATED_PAYBATCH

PAYMENT_LOOKBACK

PAYSHEET_VISIBILITY

HCM_FETCH_DATE

PARALLEL_BU_ID

CALC_PROCESS_ORDER

IMP_SRP_FUTURE_HIRE_DATE_FLAG

IMP_NUM_DAYS_BEFORE_HIRE_DATE

Query

SQL_Statement

SELECT

CN_REPOSITORIES_ALL_B.REPOSITORY_ID REPOSITORY_ID,

CN_REPOSITORIES_ALL_B.CALENDAR_ID CALENDAR_ID,

CN_REPOSITORIES_ALL_B.PERIOD_TYPE_ID PERIOD_TYPE_ID,

CN_REPOSITORIES_ALL_B.FUNCTIONAL_CURRENCY FUNCTIONAL_CURRENCY,

CN_REPOSITORIES_ALL_B.PROCESS_CURRENCY PROCESS_CURRENCY,

CN_REPOSITORIES_ALL_B.CN_CONVERSION_TYPE CN_CONVERSION_TYPE,

CN_REPOSITORIES_ALL_B.PAYMENT_CONV_TYPE PAYMENT_CONV_TYPE,

CN_REPOSITORIES_ALL_B.PAYMENT_DATE_CONV PAYMENT_DATE_CONV,

CN_REPOSITORIES_ALL_B.RESET_BAL_YEAR RESET_BAL_YEAR,

CN_REPOSITORIES_ALL_B.HR_SUPER_HIERARCHY_DEPTH,

CN_REPOSITORIES_ALL_B.ANALYST_HIERARCHY_DEPTH,

CN_REPOSITORIES_ALL_B.PLAN_APPROVAL_ENABLE_FLAG,

CN_REPOSITORIES_ALL_B.CUSTOM_TARGET_INCENTIVE CUSTOM_TARGET_INCENTIVE,

CN_REPOSITORIES_ALL_B.CN_CUST_PLAN_COMP_FLAG CN_CUST_PLAN_COMP_FLAG,

CN_REPOSITORIES_ALL_B.CN_COMM_RATE_PRECISION CN_COMM_RATE_PRECISION,

CN_REPOSITORIES_ALL_B.AUTO_NOTES_PLAN_RULE AUTO_NOTES_PLAN_RULE,

CN_REPOSITORIES_ALL_B.PLAN_APPROVAL_STATUS PLAN_APPROVAL_STATUS,

CN_REPOSITORIES_ALL_B.PAYSHEETAPPROVAL_STATUS PAYSHEETAPPROVAL_STATUS,

CN_REPOSITORIES_ALL_B.ENABLE_CLASSIFY ENABLE_CLASSIFY,

CN_REPOSITORIES_ALL_B.CLASSIFY_TRANSACTION CLASSIFY_TRANSACTION,

CN_REPOSITORIES_ALL_B.ENABLE_CREDIT ENABLE_CREDIT,

CN_REPOSITORIES_ALL_B.SRP_ROLLUP_FLAG SRP_ROLLUP_FLAG,

CN_REPOSITORIES_ALL_B.ROLLUP_USING ROLLUP_USING,

CN_REPOSITORIES_ALL_B.AGGR_TRANS_ROLLUP AGGR_TRANS_ROLLUP,

CN_REPOSITORIES_ALL_B.CN_CUSTOM_AGGR_TRX CN_CUSTOM_AGGR_TRX,

CN_REPOSITORIES_ALL_B.CLASSIFY_BATCH_OPTION CLASSIFY_BATCH_OPTION,

CN_REPOSITORIES_ALL_B.CLASSIFY_BATCH_SIZE CLASSIFY_BATCH_SIZE,

CN_REPOSITORIES_ALL_B.TRX_ROLLUP_METHOD TRX_ROLLUP_METHOD,

CN_REPOSITORIES_ALL_B.ROLLUP_BATCH_SIZE ROLLUP_BATCH_SIZE,

CN_REPOSITORIES_ALL_B.BATCH_RUNNER_STATUS BATCH_RUNNER_STATUS,

CN_REPOSITORIES_ALL_B.PAY_PART_BATCH_SIZE PAY_PART_BATCH_SIZE,

CN_REPOSITORIES_ALL_B.PARTICIPANT_BATCH_SIZE PARTICIPANT_BATCH_SIZE,

CN_REPOSITORIES_ALL_B.REPORT_HIERARCHY_ID REPORT_HIERARCHY_ID,

CN_REPOSITORIES_ALL_B.CN_DISPLAY_DRAW CN_DISPLAY_DRAW,

CN_REPOSITORIES_ALL_B.YTD_SUMMARY YTD_SUMMARY,

CN_REPOSITORIES_ALL_B.ATTAINMENT_SUMMARY ATTAINMENT_SUMMARY,

CN_REPOSITORIES_ALL_B.COMMISSION_STATEMENT COMMISSION_STATEMENT,

CN_REPOSITORIES_ALL_B.CREDIT_DETAILS CREDIT_DETAILS,

CN_REPOSITORIES_ALL_B.EARNING_DETAILS EARNING_DETAILS,

CN_REPOSITORIES_ALL_B.PAYMENT_DETAILS PAYMENT_DETAILS,

CN_REPOSITORIES_ALL_B.ORG_ID ORG_ID,

CN_REPOSITORIES_ALL_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER,

CN_REPOSITORIES_ALL_B.STATUS STATUS,

CN_REPOSITORIES_ALL_B.APPLICATION_TYPE APPLICATION_TYPE,

CN_REPOSITORIES_ALL_B.LAST_UPDATE_DATE LAST_UPDATE_DATE,

CN_REPOSITORIES_ALL_B.LAST_UPDATED_BY LAST_UPDATED_BY,

CN_REPOSITORIES_ALL_B.CREATION_DATE CREATION_DATE,

CN_REPOSITORIES_ALL_B.CREATED_BY CREATED_BY,

CN_REPOSITORIES_ALL_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN,

CN_REPOSITORIES_ALL_B.APPLICATION_ID APPLICATION_ID,

CN_REPOSITORIES_ALL_B.REPOSITORY_TYPE REPOSITORY_TYPE,

CN_REPOSITORIES_ALL_B.COLL_CONV_TYPE COLL_CONV_TYPE,

CN_REPOSITORIES_ALL_B.ENABLE_NEGATIVE_PAY ENABLE_NEGATIVE_PAY,

CN_REPOSITORIES_ALL_B.ANALYST_SECURITY ANALYST_SECURITY,

CN_REPOSITORIES_ALL_TL.REPOSITORY_NAME REPOSITORY_NAME,

CN_REPOSITORIES_ALL_TL.ORG_NAME ORG_NAME,

CN_REPOSITORIES_ALL_B.MIN_PMT_APPR_AMT MIN_PMT_APPR_AMT,

CN_REPOSITORIES_ALL_B.MAX_PMT_APPR_AMT MAX_PMT_APPR_AMT,

CN_REPOSITORIES_ALL_B.COLL_CAN_TRX_ZERO,

CN_REPOSITORIES_ALL_B.PLAN_IMPORT_RESOLVE,

CN_REPOSITORIES_ALL_B.CUSTOM_ROLLUP_PROCEDURE CUSTOM_ROLLUP_PROCEDURE,

CN_REPOSITORIES_ALL_B.DEFAULT_PLAN_DOC_TEMPLATE,

CN_REPOSITORIES_ALL_B.PAYMENT_HOME_CURRENCY_AMOUNT,

CN_REPOSITORIES_ALL_B.ROLE_ASGN_REVIEW_NEW,

CN_REPOSITORIES_ALL_B.ROLE_ASGN_REVIEW_OLD,

CN_REPOSITORIES_ALL_B.ENABLE_PARTICIPANT_TERMINATE,

CN_REPOSITORIES_ALL_B.COMP_END_DATE_PERIOD_OPTIONS,

CN_REPOSITORIES_ALL_B.COMP_END_DATE_PERIOD_COUNT,

CN_REPOSITORIES_ALL_B.COMP_PLAN_ASSIGN_TERMINATE,

CN_REPOSITORIES_ALL_B.PAYMENT_PLAN_ASSIGN_TERMINATE,

CN_REPOSITORIES_ALL_B.TRX_CALC_METHOD,

CN_REPOSITORIES_ALL_B.CALC_BATCH_SIZE ,

CN_REPOSITORIES_ALL_B.WORKER_INFORMATION,

CN_REPOSITORIES_ALL_B.CN_CUST_PLAN_COMP_OPTION,

CN_REPOSITORIES_ALL_B.DISABLE_INCR_CALCULATION,

CN_REPOSITORIES_ALL_B.ALLOW_FUTURE_DATED_PAYBATCH,

CN_REPOSITORIES_ALL_B.PAYMENT_LOOKBACK,

CN_REPOSITORIES_ALL_B.PAYSHEET_VISIBILITY,

CN_REPOSITORIES_ALL_B.HCM_FETCH_DATE,

CN_REPOSITORIES_ALL_B.PARALLEL_BU_ID,

CN_REPOSITORIES_ALL_B.CALC_PROCESS_ORDER,

CN_REPOSITORIES_ALL_B.IMP_SRP_FUTURE_HIRE_DATE_FLAG,

CN_REPOSITORIES_ALL_B.IMP_NUM_DAYS_BEFORE_HIRE_DATE

FROM

CN_REPOSITORIES_ALL_B,

CN_REPOSITORIES_ALL_TL

WHERE

CN_REPOSITORIES_ALL_B.REPOSITORY_ID = CN_REPOSITORIES_ALL_TL.REPOSITORY_ID AND CN_REPOSITORIES_ALL_TL.LANGUAGE = USERENV('LANG')