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_REP_ASMT_DTS_V

Object Details

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

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Comments
PROJECT_ORGANIZATION_ID	NUMBER	(15)	Internal identifier of project organization
PROJECT_ORGANIZATION_NAME	VARCHAR2	(4000)	Project organization name
PROJECT_ID	NUMBER	(15)	Internal Identifier of project
PROJECT_NAME	VARCHAR2	(30)	Project name
PROJECT_NUMBER	VARCHAR2	(25)	Project number
PROJECT_NAME_NUMBER	VARCHAR2	(57)	Project name concatenated with project number
ASSIGNMENT_ID	NUMBER		Internal Identifier of assignment
ASSIGNMENT_NAME	VARCHAR2	(80)	Assignment name
ASSIGNMENT_NUMBER	NUMBER		Assignment number
PROJECT_ROLE_ID	NUMBER		Internal Identifier of project role
PROJECT_ROLE_NAME	VARCHAR2	(80)	Project role name
RESOURCE_ID	NUMBER		Internal identifier of the resource
RESOURCE_NAME	VARCHAR2	(4000)	Resource name
RESOURCE_JOB_LEVEL	NUMBER		Resource job level
RESOURCE_CAPACITY_HOURS	NUMBER		Capacity hours of the resource in the assignment period
RESOURCE_CAPACITY_DAYS	NUMBER		Resource capacity hours factored by FTE day definition
RESOURCE_CAPACITY_WEEKS	NUMBER		Resource capacity hours factored by FTE week definition
RESOURCE_JOB_GROUP	VARCHAR2	(30)	Resource job group
RESOURCE_JOB	VARCHAR2	(700)	Resource job
RESOURCE_ORGANIZATION	VARCHAR2	(4000)	Organization which the resource belongs to in the assignment period
RESOURCE_CUR_ORGANIZATION	VARCHAR2	(4000)	Current organization which the resource belongs to
ASMT_START_DATE	DATE		Assignment start date
ASMT_END_DATE	DATE		Assignment end date
PROVISIONAL_HOURS	NUMBER		Number of provisional hours
PROVISIONAL_DAYS	NUMBER		Number of provisional hours factored by FTE day definition
PROVISIONAL_WEEKS	NUMBER		Number of provisional hours factored by FTE week definition
CONFIRMED_HOURS	NUMBER		Number of confirmed hours
CONFIRMED_DAYS	NUMBER		Number of confirmed hours factored by FTE day definition
CONFIRMED_WEEKS	NUMBER		Number of confirmed hours factored by FTE week definition
EFFORT_HOURS	NUMBER		Effort hours
EFFORT_DAYS	NUMBER		Effort hours factored by FTE day definition
EFFORT_WEEKS	NUMBER		Effort hours factored by FTE week definition
BILL_RATE_CURRENCY	VARCHAR2	(56)	Bill rate concatenated with currency code
REVENUE_BILL_RATE	NUMBER		Bill rate
REVENUE_CURRENCY_CODE	VARCHAR2	(15)	Currency code for the bill rate
WORK_TYPE_NAME	VARCHAR2	(80)	Work type name
STAFFING_PRIORITY	VARCHAR2	(80)	Staffing priority
PROJECT_SUBTEAM_NAME	VARCHAR2	(80)	Project subteam name
COUNTRY	VARCHAR2	(80)	Country
REGION	VARCHAR2	(240)	Region
CITY	VARCHAR2	(80)	City
LOCATION	VARCHAR2	(402)	Location in the form of Country.Region.City
EXTENTION_POSSIBLE	VARCHAR2	(1)	Flag specifies if the assignment can be extended
EXPENSE_OWNER_NAME	VARCHAR2	(80)	Expense owner name
EXPENSE_LIMIT	NUMBER		Expense limit
ASSIGNMENT_DURATION	NUMBER		Assignment duration
APPROVAL_STATUS	VARCHAR2	(80)	Approval status
SCHEDULE_STATUS	VARCHAR2	(80)	Schedule status
EXPENDITURE_TYPE	VARCHAR2	(30)	Expenditure type
BILL_RATE_OVERRIDE_CURR	VARCHAR2	(71)	Bill rate override concatenated with bill rate override currency code
BILL_RATE_OVERRIDE	NUMBER		Bill rate override
BILL_RATE_CURR_OVERRIDE	VARCHAR2	(30)	Currency code for bill rate override
MARKUP_PERCENT	NUMBER		Markup percent
MARKUP_PERCENT_OVERRIDE	NUMBER		Markup percent override
TP_RATE_OVERRIDE_CURR	VARCHAR2	(71)	Transfer price override concatenated with transfer price override currency
TP_RATE_OVERRIDE	NUMBER		Transfer price override
TP_CURRENCY_OVERRIDE	VARCHAR2	(30)	Currency code for transfer price override
TP_BASIS_OVERRIDE	VARCHAR2	(30)	Transfer price basis override
TP_PERCENT_OVERRIDE	NUMBER		Transfer price percentage override
DESCRIPTION	VARCHAR2	(2000)	Description
ADDITIONAL_INFORMATION	VARCHAR2	(2000)	Additional information
CALENDAR_TYPE	VARCHAR2	(30)	Calendar type
RESOURCE_CALENDAR_PERCENT	NUMBER		Resource calendar percentage
EXPENDITURE_TYPE_CLASS	VARCHAR2	(30)	Expenditure type class
NOTE_TO_APPROVER	VARCHAR2	(240)	Note to approver
SEARCH_MIN_AVAILABILITY	NUMBER		Minimum availability specified for search
SEARCH_COUNTRY_CODE	VARCHAR2	(2)	Search country code
SEARCH_MIN_CANDIDATE_SCORE	NUMBER		Minimum candidate score
LAST_AUTO_SEARCH_DATE	DATE		Last date that auto search was run
COMPETENCE_MATCH_WEIGHTING	NUMBER		Competence weighting for search
AVAILABILITY_MATCH_WEIGHTING	NUMBER		Availability weighting for search
JOB_LEVEL_MATCH_WEIGHTING	NUMBER		Job level weighting for search
ATTRIBUTE_CATEGORY	VARCHAR2	(30)	Attribute category
ATTRIBUTE1	VARCHAR2	(150)	Attribute 1
ATTRIBUTE2	VARCHAR2	(150)	Attribute 2
ATTRIBUTE3	VARCHAR2	(150)	Attribute 3
ATTRIBUTE4	VARCHAR2	(150)	Attribute 4
ATTRIBUTE5	VARCHAR2	(150)	Attribute 5
ATTRIBUTE6	VARCHAR2	(150)	Attribute 6
ATTRIBUTE7	VARCHAR2	(150)	Attribute 7
ATTRIBUTE8	VARCHAR2	(150)	Attribute 8
ATTRIBUTE9	VARCHAR2	(150)	Attribute 9
ATTRIBUTE10	VARCHAR2	(150)	Attribute 10
ATTRIBUTE11	VARCHAR2	(150)	Attribute 11
ATTRIBUTE12	VARCHAR2	(150)	Attribute 12
ATTRIBUTE13	VARCHAR2	(150)	Attribute 13
ATTRIBUTE14	VARCHAR2	(150)	Attribute 14
ATTRIBUTE15	VARCHAR2	(150)	Attribute 15

Query Text

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


SELECT PROJECT_ORGANIZATION_ID
,      PROJECT_ORGANIZATION_NAME
,      PROJECT_ID
,      PROJECT_NAME
,      PROJECT_NUMBER
,      PROJECT_NAME_NUMBER
,      ASSIGNMENT_ID
,      ASSIGNMENT_NAME
,      ASSIGNMENT_NUMBER
,      PROJECT_ROLE_ID
,      PROJECT_ROLE_NAME
,      RESOURCE_ID
,      RESOURCE_NAME
,      RESOURCE_JOB_LEVEL
,      RESOURCE_CAPACITY_HOURS
,      RESOURCE_CAPACITY_DAYS
,      RESOURCE_CAPACITY_WEEKS
,      RESOURCE_JOB_GROUP
,      RESOURCE_JOB
,      RESOURCE_ORGANIZATION
,      RESOURCE_CUR_ORGANIZATION
,      ASMT_START_DATE
,      ASMT_END_DATE
,      PROVISIONAL_HOURS
,      PROVISIONAL_DAYS
,      PROVISIONAL_WEEKS
,      CONFIRMED_HOURS
,      CONFIRMED_DAYS
,      CONFIRMED_WEEKS
,      EFFORT_HOURS
,      EFFORT_DAYS
,      EFFORT_WEEKS
,      BILL_RATE_CURRENCY
,      REVENUE_BILL_RATE
,      REVENUE_CURRENCY_CODE
,      WORK_TYPE_NAME
,      STAFFING_PRIORITY
,      PROJECT_SUBTEAM_NAME
,      COUNTRY
,      REGION
,      CITY
,      LOCATION
,      EXTENTION_POSSIBLE
,      EXPENSE_OWNER_NAME
,      EXPENSE_LIMIT
,      ASSIGNMENT_DURATION
,      APPROVAL_STATUS
,      SCHEDULE_STATUS
,      EXPENDITURE_TYPE
,      BILL_RATE_OVERRIDE_CURR
,      BILL_RATE_OVERRIDE
,      BILL_RATE_CURR_OVERRIDE
,      MARKUP_PERCENT
,      MARKUP_PERCENT_OVERRIDE
,      TP_RATE_OVERRIDE_CURR
,      TP_RATE_OVERRIDE
,      TP_CURRENCY_OVERRIDE
,      TP_BASIS_OVERRIDE
,      TP_PERCENT_OVERRIDE
,      DESCRIPTION
,      ADDITIONAL_INFORMATION
,      CALENDAR_TYPE
,      RESOURCE_CALENDAR_PERCENT
,      EXPENDITURE_TYPE_CLASS
,      NOTE_TO_APPROVER
,      SEARCH_MIN_AVAILABILITY
,      SEARCH_COUNTRY_CODE
,      SEARCH_MIN_CANDIDATE_SCORE
,      LAST_AUTO_SEARCH_DATE
,      COMPETENCE_MATCH_WEIGHTING
,      AVAILABILITY_MATCH_WEIGHTING
,      JOB_LEVEL_MATCH_WEIGHTING
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
FROM APPS.PA_REP_ASMT_DTS_V;

Dependencies

[top of page]

APPS.PA_REP_ASMT_DTS_V references the following:

APPS: FND_GLOBAL - show dependent code; FND_GRANTS; FND_OBJECTS; FND_PROFILE - show dependent code; FND_TERRITORIES_TL; FND_USER; PA_ASSIGNMENT_UTILS - show dependent code; PA_EXPENDITURES_UTILS - show dependent code; PA_IMPLEMENTATIONS_ALL; PA_LOCATIONS; PA_LOOKUPS; PA_PROJECTS_ALL; PA_PROJECT_ASSIGNMENTS; PA_PROJECT_PARTIES; PA_PROJECT_ROLE_TYPES; PA_PROJECT_STATUSES; PA_PROJECT_SUBTEAMS; PA_PROJECT_SUBTEAM_PARTIES; PA_RESOURCES_DENORM; PA_RESOURCE_UTILS - show dependent code; PA_ROLE_JOB_BG_UTILS - show dependent code; PA_SECURITY_PVT - show dependent code; PA_WORK_TYPES_V; PER_JOBS; PER_JOB_GROUPS
PUBLIC: DUAL

APPS.PA_REP_ASMT_DTS_V is not referenced by any database object