eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

Table: PA_PROJECT_ASSIGNMENTS

Product:	PA - Projects
Description:	PA_PROJECT_ASSIGNMENTS stores details of all Assignments for a project.
Implementation/DBA Data:	PA.PA_PROJECT_ASSIGNMENTS

Primary Key: PA_PROJECT_ASSIGNMENTS_PK

ASSIGNMENT_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
PA_PROJECT_ASSIGNMENTS	PA_RESOURCES	PA_PROJECT_ASSIGNMENTS.RESOURCE_ID
PA_PROJECT_ASSIGNMENTS	PA_PROJECT_STATUSES	PA_PROJECT_ASSIGNMENTS.STATUS_CODE
PA_PROJECT_ASSIGNMENTS	PA_TEAM_TEMPLATES	PA_PROJECT_ASSIGNMENTS.ASSIGNMENT_TEMPLATE_ID
PA_PROJECT_ASSIGNMENTS	PA_PROJECTS_ALL	PA_PROJECT_ASSIGNMENTS.PROJECT_ID
PA_PROJECT_ASSIGNMENTS	PA_PROJECT_ASSIGNMENTS	PA_PROJECT_ASSIGNMENTS.SOURCE_ASSIGNMENT_ID
PA_PROJECT_ASSIGNMENTS	FND_TERRITORIES	PA_PROJECT_ASSIGNMENTS.SEARCH_COUNTRY_CODE
PA_PROJECT_ASSIGNMENTS	PER_ORG_STRUCTURE_VERSIONS	PA_PROJECT_ASSIGNMENTS.SEARCH_EXP_ORG_STRUCT_VER_ID
PA_PROJECT_ASSIGNMENTS	HR_ALL_ORGANIZATION_UNITS	PA_PROJECT_ASSIGNMENTS.SEARCH_EXP_START_ORG_ID
PA_PROJECT_ASSIGNMENTS	PA_PROJECT_PARTIES	PA_PROJECT_ASSIGNMENTS.PROJECT_PARTY_ID
PA_PROJECT_ASSIGNMENTS	HR_ALL_ORGANIZATION_UNITS	PA_PROJECT_ASSIGNMENTS.EXPENDITURE_ORGANIZATION_ID
PA_PROJECT_ASSIGNMENTS	PER_JOB_GROUPS	PA_PROJECT_ASSIGNMENTS.FCST_JOB_GROUP_ID
PA_PROJECT_ASSIGNMENTS	PER_JOBS	PA_PROJECT_ASSIGNMENTS.FCST_JOB_ID
PA_PROJECT_ASSIGNMENTS	PA_SYSTEM_LINKAGES	PA_PROJECT_ASSIGNMENTS.EXPENDITURE_TYPE_CLASS
PA_PROJECT_ASSIGNMENTS	PA_EXPENDITURE_TYPES	PA_PROJECT_ASSIGNMENTS.EXPENDITURE_TYPE
PA_PROJECT_ASSIGNMENTS	PA_WORK_TYPES_B	PA_PROJECT_ASSIGNMENTS.WORK_TYPE_ID
PA_PROJECT_ASSIGNMENTS	JTF_CALENDARS_B	PA_PROJECT_ASSIGNMENTS.CALENDAR_ID
PA_PROJECT_ASSIGNMENTS	PA_LOCATIONS	PA_PROJECT_ASSIGNMENTS.LOCATION_ID
PA_PROJECT_ASSIGNMENTS	FND_CURRENCIES	PA_PROJECT_ASSIGNMENTS.EXPENSE_LIMIT_CURRENCY_CODE
PA_ASSIGNMENTS_HISTORY	PA_PROJECT_ASSIGNMENTS	PA_ASSIGNMENTS_HISTORY.ASSIGNMENT_ID
PA_CANDIDATES	PA_PROJECT_ASSIGNMENTS	PA_CANDIDATES.ASSIGNMENT_ID
PA_EXPENDITURE_ITEMS_ALL	PA_PROJECT_ASSIGNMENTS	PA_EXPENDITURE_ITEMS_ALL.ASSIGNMENT_ID
PA_FORECAST_ITEMS	PA_PROJECT_ASSIGNMENTS	PA_FORECAST_ITEMS.ASSIGNMENT_ID
PA_OBJECTS	PA_PROJECT_ASSIGNMENTS	PA_OBJECTS.ASSIGNMENT_ID
PA_ORG_FCST_ELEMENTS	PA_PROJECT_ASSIGNMENTS	PA_ORG_FCST_ELEMENTS.ASSIGNMENT_ID
PA_PROJECT_ASSIGNMENTS	PA_PROJECT_ASSIGNMENTS	PA_PROJECT_ASSIGNMENTS.SOURCE_ASSIGNMENT_ID
PA_RESOURCE_ASSIGNMENTS	PA_PROJECT_ASSIGNMENTS	PA_RESOURCE_ASSIGNMENTS.PROJECT_ASSIGNMENT_ID
PA_SCHEDULES	PA_PROJECT_ASSIGNMENTS	PA_SCHEDULES.ASSIGNMENT_ID
PA_SCHEDULES_HISTORY	PA_PROJECT_ASSIGNMENTS	PA_SCHEDULES_HISTORY.ASSIGNMENT_ID
PA_TRANSACTION_INTERFACE_ALL	PA_PROJECT_ASSIGNMENTS	PA_TRANSACTION_INTERFACE_ALL.ASSIGNMENT_ID
PA_TXN_INTERFACE_AUDIT_AR	PA_PROJECT_ASSIGNMENTS	PA_TXN_INTERFACE_AUDIT_AR.ASSIGNMENT_ID
PA_TXN_INTERFACE_AUDIT_ALL	PA_PROJECT_ASSIGNMENTS	PA_TXN_INTERFACE_AUDIT_ALL.ASSIGNMENT_ID
PA_PROJECT_ROLE_TYPES_B	PA_PROJECT_ASSIGNMENTS	PA_PROJECT_ROLE_TYPES_B.PPT_ASSIGNMENT_ID