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') |