PSP Views (179)
PSP - Labor Distribution — documented views from Oracle EBS ETRM 12.2.2. Click any name for its documentation, columns and AI summary.
| View | Description |
|---|---|
PSPBV_ADJUSTMENT_APPROVERS |
PSPBV_ADJUSTMENT_APPROVERS displays information about the person who approves distribution adjustments. |
PSPBV_AUTOPOP_ACCTS |
|
PSPBV_AUTOPOP_LOOKUP_PARAMETER |
|
PSPBV_AUTOPOP_RULE_CLAUSE |
|
PSPBV_AUTO_POPULATION_RULE |
|
PSPBV_AUTO_SEGMENTS |
|
PSPBV_BUSINESS_MANAGERS |
PSPBV_BUSINESS_MANAGERS displays information about the business managers who are in charge of the effort certification process. |
PSPBV_CLEARING_ACCOUNTS |
PSPBV_CLEARING_ACCOUNTS displays information about the General Ledger clearing account used to charge the payroll costs. |
PSPBV_COSTED_PAYROLL_LINES |
PSPBV_COSTED_PAYROLL_LINES displays information about the payroll lines imported from payroll systems. |
PSPBV_COST_DIST_LINE_ADJUST |
PSPBV_COST_DIST_LINE_ADJUST displays information regarding distribution lines created due to adjustments. |
PSPBV_COST_DIST_SUM_LINES |
PSPBV_COST_DIST_SUM_LINES displays summarized information on distribution lines. This view reduces the number of lines posted in General Le |
PSPBV_DIST_ADJUST_HISTORIES |
PSPBV_DIST_ADJUST_HISTORIES displays the adjusted lines that are transferred to General Ledger or Grants Management successfully. |
PSPBV_DIST_LINE_ADJUST_BATCHES |
PSPBV_DIST_LINE_ADJUST_BATCHES displays information about a batch of distribution adjustments. |
PSPBV_EFFORT_REPORTS |
PSPBV_EFFORT_REPORTS displays the total effort of an employee in a period distributed between the tasks and projects. |
PSPBV_EFFORT_REPORT_APPROVALS |
PSPBV_EFFORT_REPORT_APPROVALS displays the person who certifies a given Effort Report. |
PSPBV_EFFORT_REPORT_DETAILS |
PSPBV_EFFORT_REPORT_DETAILS displays information about each charging account in the Effort Report. |
PSPBV_EFFORT_REPORT_MESSAGES |
PSPBV_EFFORT_REPORT_MESSAGES displays standard messages of accepting and certifying Effort Reports. This message is printed on the hard cop |
PSPBV_EFFORT_REPORT_PERIODS |
PSPBV_EFFORT_REPORT_PERIODS displays the definition of Effort Report periods with begin date and end date. |
PSPBV_EFFORT_REPORT_TEMPLATES |
PSPBV_EFFORT_REPORT_TEMPLATES displays the Effort Report selection criteria that can be reused. |
PSPBV_ELEMENT_GROUPS |
PSPBV_EFFORT_REPORT_TEMPLATES displays the Effort Report selection criteria that can be reused. |
PSPBV_ENC_ELEMENTS |
|
PSPBV_ENC_LINES |
|
PSPBV_ENC_LINES_HISTORY |
|
PSPBV_ENC_PAYROLLS |
|
PSPBV_ENC_PAYROLL_ASSIGNMENTS |
|
PSPBV_ENC_SUMMARY_LINES |
|
PSPBV_ENC_TRANS_CONTROLS |
|
PSPBV_GENERATED_DIST_HISTORIES |
PSPBV_GENERATED_DIST_HISTORIES displays the distributed Oracle Payroll and non-Oracle payroll sublines that are successfully transferred to |
PSPBV_GENERATE_COST_DIST_LINES |
PSPBV_GENERATE_COST_DIST_LINES displays information about cost distribution lines generated in Labor Distribution. |
PSPBV_GLOBAL_SCHEDULE_LINES |
PSPBV_GLOBAL_SCHEDULE_LINES displays information about the charging account to be used at the site level for the earnings element. |
PSPBV_LABOR_DIST_ASSIGNMENTS |
PSPBV_LABOR_DIST_ASSIGNMENTS displays assignment identifiers from Oracle Human Resources that have schedules in Labor Distribution. |
PSPBV_LABOR_DIST_ELEMENT_TYPES |
PSPBV_LABOR_DIST_ELEMENT_TYPES displays information about earnings elements defined in Oracle Human Resources and Payroll and imported to La |
PSPBV_LABOR_SCHEDULE_LINES |
PSPBV_LABOR_SCHEDULE_LINES displays schedule information or charging instructions for different employees, assignments, element types, and o |
PSPBV_ORGANIZATION_ACCOUNTS |
PSPBV_ORGANIZATION_ACCOUNTS displays information about a charging account which is used as the organization default acct. or org. suspense a |
PSPBV_ORG_SCHEDULE_LINES |
PSPBV_ORG_SCHEDULE_LINES displays information about a charging account in a schedule that is used at the organization level. |
PSPBV_PAYROLL_SOURCES |
PSPBV_PAYROLL_SOURCES displays information about payroll sources for non-Oracle payroll lines and pre-generated distribution lines that are |
PSPBV_PAYROLL_SUB_LINES |
PSPBV_PAYROLL_SUB_LINES displays information about Oracle sublines or non-Oracle payroll sublines. |
PSPBV_PAYROLL_TRANS_CONTROLS |
PSPBV_PAYROLL_TRANS_CONTROLS displays information about the payroll transaction control. |
PSPBV_PREGEN_DIST_HISTORIES |
PSPBV_PREGEN_DIST_HISTORIES displays the distributed Oracle Payroll and non-Oracle payroll sublines that are transferred to General Ledger a |
PSPBV_PREGEN_DIST_LINES |
PSPBV_PREGEN_DIST_LINES displays information about imported pre-generated distribution lines brought into Labor Distribution from time card |
PSPBV_PREGEN_DIST_LINE_BATCHES |
PSPBV_PREGEN_DIST_LINE_BATCHES displays information about pre-generated distribution lines batches. |
PSPBV_SCHEDULE_HIERARCHIES |
PSPBV_SCHEDULE_HIERARCHIES displays information about the schedule hierarchy level for an employee assignment. |
PSPBV_TEMPLATE_AWARDS |
PSPBV_TEMPLATE_AWARDS displays the list of awards selected in the effort report selection criteria template. |
PSPBV_TEMPLATE_ORGANIZATIONS |
PSPBV_TEMPLATE_ORGANIZATIONS displays the list of organization identifiers selected in the effort report selection criteria template. |
PSPBV_TEMPLATE_PROJECTS |
PSPBV_TEMPLATE_PROJECTS displays the list of projects selected in the effort report selection criteria template. |
PSPFV_ADJUSTMENT_APPROVERS |
PSPFV_ADJUSTMENT_APPROVERS displays information about the person who approves distribution adjustments. |
PSPFV_AUTOPOP_ACCTS |
|
PSPFV_AUTOPOP_LOOKUP_PARAMETER |
|
PSPFV_AUTOPOP_RULE_CLAUSE |
|
PSPFV_AUTO_POPULATION_RULE |
|
PSPFV_AUTO_SEGMENTS |
|
PSPFV_BUSINESS_MANAGERS |
PSPFV_BUSINESS_MANAGERS displays information about the business managers who are in charge of the effort certification process. |
PSPFV_CLEARING_ACCOUNTS |
PSPFV_CLEARING_ACCOUNTS displays information about the General Ledger clearing account used to charge the payroll costs. |
PSPFV_COSTED_PAYROLL_LINES |
PSPFV_COSTED_PAYROLL_LINES displays information about the payroll lines imported from payroll systems. |
PSPFV_COST_DIST_LINE_ADJUST |
PSPFV_COST_DIST_LINE_ADJUST displays information regarding distribution lines created due to adjustments. |
PSPFV_COST_DIST_SUM_LINES |
|
PSPFV_DIST_ADJUST_HISTORIES |
|
PSPFV_DIST_LINE_ADJUST_BATCHES |
|
PSPFV_EFFORT_REPORTS |
|
PSPFV_EFFORT_REPORT_APPROVALS |
|
PSPFV_EFFORT_REPORT_DETAILS |
|
PSPFV_EFFORT_REPORT_MESSAGES |
|
PSPFV_EFFORT_REPORT_PERIODS |
|
PSPFV_EFFORT_REPORT_TEMPLATES |
|
PSPFV_ELEMENT_GROUPS |
|
PSPFV_ENC_ELEMENTS |
|
PSPFV_ENC_LINES |
|
PSPFV_ENC_LINES_HISTORY |
|
PSPFV_ENC_PAYROLLS |
|
PSPFV_ENC_PAYROLL_ASSIGNMENTS |
|
PSPFV_ENC_SUMMARY_LINES |
|
PSPFV_ENC_TRANS_CONTROLS |
|
PSPFV_GENERATED_DIST_HISTORIES |
|
PSPFV_GENERATE_COST_DIST_LINES |
|
PSPFV_LABOR_DIST_ASSIGNMENTS |
|
PSPFV_LABOR_DIST_ELEMENT_TYPES |
|
PSPFV_LABOR_SCHEDULE_LINES |
|
PSPFV_ORGANIZATION_ACCOUNTS |
|
PSPFV_ORG_SCHEDULE_LINES |
|
PSPFV_PAYROLL_SOURCES |
|
PSPFV_PAYROLL_SUB_LINES |
|
PSPFV_PAYROLL_TRANS_CONTROLS |
|
PSPFV_PREGEN_DIST_HISTORIES |
|
PSPFV_PREGEN_DIST_LINES |
|
PSPFV_PREGEN_DIST_LINE_BATCHES |
|
PSPFV_SCHEDULE_HIERARCHIES |
|
PSPFV_TEMPLATE_AWARDS |
|
PSPFV_TEMPLATE_ORGANIZATIONS |
|
PSPFV_TEMPLATE_PROJECTS |
|
PSP_ACCOUNTS_ELEMENTS_V |
Shows unique global elements that have accounts defined for them |
PSP_ACCOUNTS_ORGANIZATIONS_V |
Shows unique organizations that have default or suspense accounts defined for them |
PSP_ADJUSTMENT_COMBO_V |
|
PSP_ASG_SCHEDULE_V |
|
PSP_ASSIGNMENTS_V |
Shows assignments for an employee |
PSP_AUTO_ACCTS_V |
|
PSP_AUTO_FILL_BEGIN_DATES_V |
Based on the PSP_AUTO_FILL_DATES table |
PSP_AUTO_FILL_END_DATES_V |
Based on the PSP_AUTO_FILL_DATES table |
PSP_AUTO_NA_BYPASS_V |
Based on PSP_AUTO_NA_BYPASS table |
PSP_AUTO_PARAMS_V |
|
PSP_BATCH_NAMES_V |
View no longer used in Oracle Labor Distribution |
PSP_CLEARING_ACCOUNT_V |
Shows clearing accounts information |
PSP_DEFAULT_LABOR_SCHEDULES_V |
Shows default labor schedules defined for organizations |
PSP_DEFAULT_LABOR_SCH_ENC_V |
|
PSP_DEST_ACCT_LINES_V |
Contains distribution lines and charging instructions for lines selected for adjustment |
PSP_DISTRIBUTION_BATCH_NAME_V |
View based on PSP_DISTRIBUTION_INTERFACE table |
PSP_DISTRIBUTION_COMBO_V |
Based on PSP_DISTRIBUTION_LINES_HISTORY, PSP_PRE_GEN_DIST_LINES_HISTORY, and PSP_ADJUSTMENT_LINES_HISTORY tables |
PSP_DISTRIBUTION_INTERFACE_V |
Based on PSP_DISTRIBUTION_INTERFACE table |
PSP_DISTRIBUTION_INTERFACE_V2 |
Based on PSP_DISTRIBUTION_INTERFACE table for master block in Maintain Pre-generated Distribution Lines window |
PSP_DISTRIBUTION_LINES_C_V |
Shows distribution lines that are for credit |
PSP_DISTRIBUTION_LINES_D_V |
Shows distribution lines that are for debit |
PSP_EFFORT_MESSAGES_V |
Based on PSP_EFFORT_MESSAGES |
PSP_EFFORT_REPORT_ELEMENTS_V |
Shows element types to be used in effort reports |
PSP_EFFORT_REPORT_PERIODS_V |
Based on PSP_EFFORT_REPORT_PERIODS |
PSP_ELEMENT_GROUPS_V |
Shows element groups |
PSP_ELEMENT_GROUP_V |
Shows element groups for Schedule Summary window |
PSP_ELEMENT_SET_MEMBERS_V |
|
PSP_ELEMENT_TYPES_V |
Shows element types imported into Labor Distribution from Oracle Human Resources |
PSP_ELEMENT_TYPE_ACCOUNTS_V |
Shows elements and accounts defined for them |
PSP_ELEMENT_TYPE_ACCT_ENC_V |
|
PSP_EMPLOYEES_V |
Shows employees in Labor Scheduling and Schedule Lines window |
PSP_ENC_CI_BASE_SUMM_GL_V |
View for setting up GL Charging instruction based summarization for labor encumbrances. |
PSP_ENC_CI_BASE_SUMM_OGM_V |
View for setting up OGM charging instructions for labor encumbrance |
PSP_ENC_EFFECTIVE_DATE_V |
View for setting up end dates for labor encumbrance |
PSP_ENC_ELEMENTS_V |
View for setting up elements for labor encumbrance |
PSP_ENC_END_DATES_V |
View for setting up end dates for labor encumbrances |
PSP_ENC_END_DATE_ORG_V |
View for setting up end dates for labor encumbrance organizations |
PSP_ENC_PAYROLLS_V |
View for setting up payrolls for labor encumbrance |
PSP_ENC_PAYROLL_ASSIGNMENT_V |
View for setting up payroll assignments for labor encumbrances |
PSP_ENC_PERIOD_EXTN_GL_V |
View for setting up gl period extension for labor encumbrances |
PSP_ENC_SETUP_OPTIONS_V |
View for setup options for labor encumbrances |
PSP_ENC_TIME_BASE_SUMM_V |
View for setting up time based summarization for labor encumbrance |
PSP_ER_STATUS_V |
Show Effort Report Error Status Summary |
PSP_GROUP_ELEMENT_LIST_V |
Shows element types associated with element groups |
PSP_LAYOUT_LOOKUP_CODE_V |
|
PSP_LOOKUPS |
Filters the data in fnd_lookups to select only those belonging to Oracle Labor Distribution |
PSP_MATRIX_DRIVER2_V |
Shows the schedule lines in matrix block in the Monthly Schedule Summary window |
PSP_MATRIX_DRIVER3_V |
Based on the PSP_MATRIX_DRIVER3 table |
PSP_MATRIX_DRIVER_V |
Shows the schedule lines in matrix block in the Schedule Lines window |
PSP_ORGANIZATION_ACCOUNTS_V |
Shows default or suspense accounts defined for organizations |
PSP_ORGANIZATION_ACCOUNT_ENC_V |
|
PSP_ORGANIZATION_SCHEDULES_V |
Shows organizations with existing default labor schedules |
PSP_ORIG_ACCT_LINES_V |
Based on PSP_TEMP_ORIG_SUMLINES |
PSP_ORIG_LINE_DETAILS_V |
|
PSP_PAYROLL_BATCH_NAMES_V |
Based on the PSP_PAYROLL_INTERFACE table |
PSP_PAYROLL_INTERFACE_V |
Based on the PSP_PAYROLL_INTERFACE table------View modified on 14-NOV-2001 by Ritesh to fix Bug:2103460. Group By clause, Several where clau |
PSP_PAYROLL_LINES_C_V |
Shows payroll lines that are for credit |
PSP_PAYROLL_LINES_D_V |
Shows payroll lines that are for debit |
PSP_PAYROLL_LINES_V |
Shows payroll lines |
PSP_PAYROLL_SOURCE_TYPES_V |
Shows payroll source codes for the source types |
PSP_PAYROLL_SUBLINES_C_V |
Shows payroll sublines that are for credit |
PSP_PAYROLL_SUBLINES_D_V |
Shows payroll sublines that are for debit |
PSP_PAYROLL_SUBLINES_V |
Shows payroll sublines |
PSP_REPORT_PERIOD_FREQUENCY_V |
|
PSP_REPORT_TEMPLATE_DATES_V |
|
PSP_REP_DA_GRP1_V |
Based on PSP_REP_DIST_PRJ_V and used in the Distribution History of Employees by Award report |
PSP_REP_DEF_CHG_V |
Based on PSP_DISTRIBUTION_LINES_HISTORY for the Distribution History by Default Account report |
PSP_REP_DEF_LOV_V |
Based on PSP_DISTRIBUTION_LINES_HISTORY for the Distribution History by Org report |
PSP_REP_DIST_ORG_V |
|
PSP_REP_DIST_PRJ_V |
Based on the PSP_DISTRIBUTION_LINES_HISTORY table |
PSP_REP_DP_GRP1_V |
Based on the PSP_DISTRIBUTION_LINES_HISTORY table used in the Distribution History by Project report |
PSP_REP_ENC_DEF_V |
based on the PSP_ENC_LINES and HISTORY table used in the Encumbrance Default Usage Report |
PSP_REP_ENC_SSP_V |
based on the PSP_ENC_LINES and HISTORY table used in the Encumbrance Suspense Report |
PSP_REP_ORG_GRP1_V |
Based on the PSP_DISTRIBUTION_LINES_HISTORY table used in the Distribution History by Organization report |
PSP_REP_SCH_EMP_V |
Based on the PSP_SCHEDULE_LINES table used in Labor Schedules for Employees report |
PSP_REP_SSP_CHG1_V |
Based on PSP_REP_SSP_CHG_V that is used in Suspense Account Charging report.5-FEB-02 Ritesh Modified query to fix Bug:2209306 |
PSP_REP_SSP_CHG_V |
Based on PSP_DISTRIBUTION_LINES_HISTORY used in Suspense Account Charging report |
PSP_REP_SUSP_WARN_V |
No longer being used in Oracle Labor Distribution. |
PSP_SCHEDULES_V |
Shows schedules for an employee assignment |
PSP_SCHEDULE_HIERARCHY_V |
Shows schedule hierarchies |
PSP_SCHEDULE_LINES_ENC_V |
View for ENcumbrance to show only GL and POETA |
PSP_SUMMARY_DISTRIB_C_V |
Shows summary lines and distribution lines that are for credit |
PSP_SUMMARY_DISTRIB_D_V |
Shows summary lines and distribution lines that are for debit |
PSP_SUMMARY_LINES_C_V |
Shows summary lines that are for credit |
PSP_SUMMARY_LINES_D_V |
Shows summary lines that are for debit |
PSP_SUMMARY_LINES_V |
Shows summary lines |
PSP_SUMMARY_PREGEN_C_V |
Shows summary lines and pre-generated distribution lines that are for credit |
PSP_SUMMARY_PREGEN_D_V |
Shows summary lines and pre-generated distribution lines that are for debit |
PSP_TIME_PERIODS_V |
Used for PSP_SRS_PERIOD_NAME value set definition |
PSP_XDO_TEMPLATES_V |