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_REQT_DTS_V

Object Details

Object Name:	PA_REP_REQT_DTS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PA.PA_REP_REQT_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
ASMT_START_DATE	DATE		Assignment start date
ASMT_END_DATE	DATE		Assignment end date
EFFORT_HOURS	NUMBER		Effort hours
STAFFING_PRIORITY	VARCHAR2	(80)	Staffing priority
MIN_JOB_LEVEL	NUMBER		Mininum job level required by the assignment
MAX_JOB_LEVEL	NUMBER		Maximum job level required by the assignment
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
COMPETENCIES	VARCHAR2	(4000)	Competencies specified for the assignment
COUNTRY	VARCHAR2	(80)	Country
REGION	VARCHAR2	(240)	Region
CITY	VARCHAR2	(80)	City
LOCATION	VARCHAR2	(402)	Location in the form of Country.Region.City
PROJECT_SUBTEAM_NAME	VARCHAR2	(80)	Project subteam name
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
EFFORT_DAYS	NUMBER		Effort Hours factored by FTE day definition
EFFORT_WEEKS	NUMBER		Effort Hours factored by FTE week definition
STATUS_NAME	VARCHAR2	(80)	Status
NO_OF_ACTIVE_CANDIDATES	NUMBER		Number of active candidates nominated
ADVERTISEMENT_RULE	VARCHAR2	(80)	Advertisement rule
EXPENDITURE_ORG_NAME	VARCHAR2	(4000)	Expenditure OU name
EXPENDITURE_ORGANIZATION_NAME	VARCHAR2	(4000)	Expenditure organization name
EXPENDITURE_TYPE	VARCHAR2	(30)	Expenditure type
FCST_JOB_GROUP_NAME	VARCHAR2	(30)	Forecast job group name
FCST_JOB_NAME	VARCHAR2	(700)	Forecast job name
WORK_TYPE_NAME	VARCHAR2	(80)	Work type name
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
,      ASMT_START_DATE
,      ASMT_END_DATE
,      EFFORT_HOURS
,      STAFFING_PRIORITY
,      MIN_JOB_LEVEL
,      MAX_JOB_LEVEL
,      BILL_RATE_CURRENCY
,      REVENUE_BILL_RATE
,      REVENUE_CURRENCY_CODE
,      COMPETENCIES
,      COUNTRY
,      REGION
,      CITY
,      LOCATION
,      PROJECT_SUBTEAM_NAME
,      EXTENTION_POSSIBLE
,      EXPENSE_OWNER_NAME
,      EXPENSE_LIMIT
,      ASSIGNMENT_DURATION
,      EFFORT_DAYS
,      EFFORT_WEEKS
,      STATUS_NAME
,      NO_OF_ACTIVE_CANDIDATES
,      ADVERTISEMENT_RULE
,      EXPENDITURE_ORG_NAME
,      EXPENDITURE_ORGANIZATION_NAME
,      EXPENDITURE_TYPE
,      FCST_JOB_GROUP_NAME
,      FCST_JOB_NAME
,      WORK_TYPE_NAME
,      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_REQT_DTS_V;

Dependencies

[top of page]

APPS.PA_REP_REQT_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_ACTION_SETS; PA_EXPENDITURES_UTILS - show dependent code; PA_HR_COMPETENCE_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_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_REQT_DTS_V is not referenced by any database object