FND Design Data [Home] [Help]

Table: PSP_EFFORT_REPORT_DETAILS

Product: PSP - Labor Distribution
Description: Contains assorted details by charging account for a given effort report
Implementation/DBA Data: TablePSP.PSP_EFFORT_REPORT_DETAILS
Primary Key: PSP_EFFORT_DETAILS_PK
  1. ColumnEFFORT_REPORT_ID
  2. ColumnVERSION_NUM
  3. ColumnEFFORT_REPORT_LINE_NUM
Foreign Keys
Table
Foreign Table Foreign Key Column
PSP_EFFORT_REPORT_DETAILS FK Joins to TablePSP_EFFORT_REPORTS PSP_EFFORT_REPORT_DETAILS.EFFORT_REPORT_ID
PSP_EFFORT_REPORT_DETAILS.VERSION_NUM
PSP_EFFORT_REPORT_DETAILS FK Joins to TablePSP_EFFORT_REPORT_ELEMENTS PSP_EFFORT_REPORT_DETAILS.ELEMENT_TYPE_ID
PSP_EFFORT_REPORT_DETAILS FK Joins to TableGL_CODE_COMBINATIONS PSP_EFFORT_REPORT_DETAILS.GL_CODE_COMBINATION_ID
PSP_EFFORT_REPORT_DETAILS FK Joins to TablePA_PROJECTS_ALL PSP_EFFORT_REPORT_DETAILS.PROJECT_ID
PSP_EFFORT_REPORT_DETAILS FK Joins to TableHR_ALL_ORGANIZATION_UNITS PSP_EFFORT_REPORT_DETAILS.EXPENDITURE_ORGANIZATION_ID
PSP_EFFORT_REPORT_DETAILS FK Joins to TablePA_EXPENDITURE_TYPES PSP_EFFORT_REPORT_DETAILS.ELEMENT_TYPE_ID
PSP_EFFORT_REPORT_DETAILS FK Joins to TablePA_TASKS PSP_EFFORT_REPORT_DETAILS.TASK_ID