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.

DBA Data [Home] [Help] [Dependency Information]

VIEW: APPS.PA_PROJ_ASSIGNMENTS_AMG_V

Object Details

Object Name:	PA_PROJ_ASSIGNMENTS_AMG_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PA.PA_PROJ_ASSIGNMENTS_AMG_V
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

This view shows all project assignments.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
PROJECT_ID	NUMBER	(15)	Yes	The identifier of the project to which the assignment belongs
PROJECT_NAME	VARCHAR2	(30)	Yes	The name of the project to which the assignment belongs
PROJECT_NUMBER	VARCHAR2	(25)	Yes	The number of the project to which the assignment belongs
ORGANIZATION_ID	NUMBER	(15)	Yes	The identifier of the project organization
ORGANIZATION_NAME	VARCHAR2	(4000)		The name of the project organization
PROJECT_MANAGER_ID	NUMBER			(no changes)
PROJECT_MANAGER_NAME	VARCHAR2	(4000)		The name of the project manager
ASSIGNMENT_ID	NUMBER		Yes	The identifier of the assignment
ASSIGNMENT_NAME	VARCHAR2	(80)	Yes	The name of the assignment
ASSIGNMENT_TYPE	VARCHAR2	(30)	Yes	The type of the assignment
ASSIGNMENT_NUMBER	NUMBER			The system-generated reference number of the assignment
ASSIGNMENT_DESCRIPTION	VARCHAR2	(2000)		The description of the assignment
ASSIGNMENT_START_DATE	DATE			The start date of the assignment
ASSIGNMENT_END_DATE	DATE			The end date of the assignment
RESOURCE_ID	NUMBER			The identifier of the resource on the assignment
RESOURCE_NAME	VARCHAR2	(4000)		The name of the resource on the assignment
RESOURCE_ORGANIZATION_ID	NUMBER		Yes	The identifier of the expenditure organization to which the resource belongs as of the current date (sysdate)
RESOURCE_ORGANIZATION	VARCHAR2	(4000)		The name of the expenditure organization to which the resource belongs as of the current date (sysdate)
MANAGER_ID	NUMBER	(15)		The person identifier of the manager of the resource
MANAGER_NAME	VARCHAR2	(240)		The name of the manager of the resource
ASSIGNMENT_DURATION	NUMBER			The duration of the assignment
ASSIGNMENT_EFFORT	NUMBER			The total effort for the assignment
APPROVAL_STATUS_CODE	VARCHAR2	(30)		The approval status code of the assignment
APPROVAL_STATUS_NAME	VARCHAR2	(80)		The approval status name of the assignment
NOTE_TO_APPROVER	VARCHAR2	(240)		The note to the approver of the assignment from the submitter
RESOURCE_LIST_MEMBER_ID	NUMBER			The identifier of the planning resource on the assignment
RESOURCE_LIST_MEMBER_ALIAS	VARCHAR2	(80)		The short name of the planning resource on the assignment
PLANNING_RESOURCE_NAME	VARCHAR2	(4000)		The name of the planning resource on the assignment
ADDITIONAL_INFORMATION	VARCHAR2	(2000)		The additional information of the assignment
RECORD_VERSION_NUMBER	NUMBER		Yes	The system-generated version of the assignment record
ASSIGNMENT_STATUS_NAME	VARCHAR2	(80)		The status name of the assignment
ASSIGNMENT_STATUS_CODE	VARCHAR2	(30)		The status code of the assignment
MULTIPLE_STATUS_FLAG	VARCHAR2	(1)	Yes	Flag indicating whether the underlying schedule of the assignment has more than one status
EXPENDITURE_ORG_ID	NUMBER			The operating unit identifier for the assignment
EXPENDITURE_ORG_NAME	VARCHAR2	(4000)		The operating unit name for the assignment
EXPENDITURE_ORGANIZATION_ID	NUMBER			The expenditure organization identifier for the assignment
EXPENDITURE_ORGANIZATION_NAME	VARCHAR2	(4000)		The expenditure organization name for the assignment
LOCATION_ID	NUMBER			The location identifier for the assignment
LOCATION_CITY	VARCHAR2	(80)		The city for the assignment
LOCATION_REGION	VARCHAR2	(240)		The state or region for the assignment
LOCATION_COUNTRY_CODE	VARCHAR2	(2)		The country code for the assignment
LOCATION_COUNTRY_NAME	VARCHAR2	(80)		The country name for the assignment
STAFFING_PRIORITY_CODE	VARCHAR2	(30)		The staffing priority code of the assignment
STAFFING_PRIORITY_NAME	VARCHAR2	(80)		The staffing priority name of the assignment
CALENDAR_ID	NUMBER			The identifier of the calendar for the assignment
CALENDAR_NAME	VARCHAR2	(50)		The name of the calendar for the assignment
CALENDAR_TYPE	VARCHAR2	(30)		The type of the calendar for the assignment
RESOURCE_CALENDAR_PERCENT	NUMBER			The daily percentage of the resource's calendar for the assignment
PROJECT_ROLE_ID	NUMBER			The identifier of the project role for the assignment
PROJECT_ROLE_NAME	VARCHAR2	(80)	Yes	The name of the project role for the assignment
WORK_TYPE_ID	NUMBER			The identifier of the work type for the assignment
WORK_TYPE_NAME	VARCHAR2	(80)	Yes	The name of the work type for the assignment
PROJECT_SUBTEAM_ID	NUMBER			The identifier of the project subteam to which this assignment belongs
PROJECT_SUBTEAM_NAME	VARCHAR2	(80)		The name of the project subteam to which this assignment belongs
EXTENSION_POSSIBLE	VARCHAR2	(1)		This flag indicates whether the assignment can be extended or not
EXPENSE_OWNER	VARCHAR2	(30)		The owner of the expenses of the assignment
EXPENSE_LIMIT	NUMBER			The limit for the expenses of the assignment
EXPENDITURE_TYPE_CLASS	VARCHAR2	(30)		The expenditure type class to be used to generate forecast transactions on the assignment
EXPENDITURE_TYPE	VARCHAR2	(30)		The expenditure type to be used to generate forecast transactions on the assignment
RATE_DISC_REASON_CODE	VARCHAR2	(30)		The discount reason code for the assignment
DISCOUNT_PERCENTAGE	NUMBER			The discount percentage for the assignment
BILL_RATE_OVERRIDE	NUMBER			The override bill rate for the assignment
BILL_RATE_CURR_OVERRIDE	VARCHAR2	(30)		The override bill rate currency code for the assignment
MARKUP_PERCENT_OVERRIDE	NUMBER			The override markup percent for the assignment
TP_RATE_OVERRIDE	NUMBER			The override transfer price rate for the assignment
TP_CURRENCY_OVERRIDE	VARCHAR2	(30)		The override transfer price rate currency code for the assignment
TP_CALC_BASE_CODE_OVERRIDE	VARCHAR2	(30)		The override transfer price basis code for the assignment
TP_PERCENT_APPLIED_OVERRIDE	NUMBER			The percentage of the transfer price basis
STAFFING_OWNER_PERSON_ID	NUMBER			The identifier of the staffing owner of the assignment
STAFFING_OWNER_PERSON_NAME	VARCHAR2	(4000)		The name of the staffing owner of the assignment
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfield context
ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield segment
ORIG_SYSTEM_CODE	VARCHAR2	(80)		The identifier of the external project management system from which the assignment data was imported
ORIG_SYSTEM_REFERENCE	VARCHAR2	(240)		The identifier of the assignment data in the external project management system from which the assignment data was imported
CREATION_DATE	DATE		Yes	The creation date of the assignment
LAST_UPDATE_DATE	DATE		Yes	The last updated date of the assignment

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT PROJECT_ID
,      PROJECT_NAME
,      PROJECT_NUMBER
,      ORGANIZATION_ID
,      ORGANIZATION_NAME
,      PROJECT_MANAGER_ID
,      PROJECT_MANAGER_NAME
,      ASSIGNMENT_ID
,      ASSIGNMENT_NAME
,      ASSIGNMENT_TYPE
,      ASSIGNMENT_NUMBER
,      ASSIGNMENT_DESCRIPTION
,      ASSIGNMENT_START_DATE
,      ASSIGNMENT_END_DATE
,      RESOURCE_ID
,      RESOURCE_NAME
,      RESOURCE_ORGANIZATION_ID
,      RESOURCE_ORGANIZATION
,      MANAGER_ID
,      MANAGER_NAME
,      ASSIGNMENT_DURATION
,      ASSIGNMENT_EFFORT
,      APPROVAL_STATUS_CODE
,      APPROVAL_STATUS_NAME
,      NOTE_TO_APPROVER
,      RESOURCE_LIST_MEMBER_ID
,      RESOURCE_LIST_MEMBER_ALIAS
,      PLANNING_RESOURCE_NAME
,      ADDITIONAL_INFORMATION
,      RECORD_VERSION_NUMBER
,      ASSIGNMENT_STATUS_NAME
,      ASSIGNMENT_STATUS_CODE
,      MULTIPLE_STATUS_FLAG
,      EXPENDITURE_ORG_ID
,      EXPENDITURE_ORG_NAME
,      EXPENDITURE_ORGANIZATION_ID
,      EXPENDITURE_ORGANIZATION_NAME
,      LOCATION_ID
,      LOCATION_CITY
,      LOCATION_REGION
,      LOCATION_COUNTRY_CODE
,      LOCATION_COUNTRY_NAME
,      STAFFING_PRIORITY_CODE
,      STAFFING_PRIORITY_NAME
,      CALENDAR_ID
,      CALENDAR_NAME
,      CALENDAR_TYPE
,      RESOURCE_CALENDAR_PERCENT
,      PROJECT_ROLE_ID
,      PROJECT_ROLE_NAME
,      WORK_TYPE_ID
,      WORK_TYPE_NAME
,      PROJECT_SUBTEAM_ID
,      PROJECT_SUBTEAM_NAME
,      EXTENSION_POSSIBLE
,      EXPENSE_OWNER
,      EXPENSE_LIMIT
,      EXPENDITURE_TYPE_CLASS
,      EXPENDITURE_TYPE
,      RATE_DISC_REASON_CODE
,      DISCOUNT_PERCENTAGE
,      BILL_RATE_OVERRIDE
,      BILL_RATE_CURR_OVERRIDE
,      MARKUP_PERCENT_OVERRIDE
,      TP_RATE_OVERRIDE
,      TP_CURRENCY_OVERRIDE
,      TP_CALC_BASE_CODE_OVERRIDE
,      TP_PERCENT_APPLIED_OVERRIDE
,      STAFFING_OWNER_PERSON_ID
,      STAFFING_OWNER_PERSON_NAME
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ORIG_SYSTEM_CODE
,      ORIG_SYSTEM_REFERENCE
,      CREATION_DATE
,      LAST_UPDATE_DATE
FROM APPS.PA_PROJ_ASSIGNMENTS_AMG_V;

Dependencies

[top of page]

APPS.PA_PROJ_ASSIGNMENTS_AMG_V references the following:

APPS: FND_TERRITORIES_TL; JTF_CALENDARS_TL; PA_EXPENDITURES_UTILS - show dependent code; PA_LOCATIONS; PA_LOOKUPS; PA_PLANNING_RESOURCE_UTILS - show dependent code; PA_PROJECTS_ALL; PA_PROJECT_ASSIGNMENTS; PA_PROJECT_ROLE_TYPES; PA_PROJECT_STATUSES; PA_PROJECT_SUBTEAMS; PA_PROJECT_SUBTEAM_PARTIES; PA_RESOURCES_DENORM; PA_RESOURCE_LIST_MEMBERS; PA_RESOURCE_PVT - show dependent code; PA_RESOURCE_UTILS - show dependent code; PA_ROLE_JOB_BG_UTILS - show dependent code; PA_WORK_TYPES_V; PER_JOBS; PER_JOB_GROUPS; PER_ORGANIZATION_STRUCTURES; PER_ORG_STRUCTURE_VERSIONS

APPS.PA_PROJ_ASSIGNMENTS_AMG_V is not referenced by any database object