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: PA.PA_PROJECT_ASGMTS_AR#

Object Details

Object Name:	PA_PROJECT_ASGMTS_AR#
Object Type:	VIEW
Owner:	PA
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
PURGE_BATCH_ID	NUMBER	(15)	Yes
PURGE_PROJECT_ID	NUMBER	(15)	Yes
PURGE_RELEASE	VARCHAR2	(50)	Yes
ADDITIONAL_INFORMATION	VARCHAR2	(2000)
APPRVL_STATUS_CODE	VARCHAR2	(30)
ASSIGNMENT_EFFORT	NUMBER
ASSIGNMENT_ID	NUMBER
ASSIGNMENT_NAME	VARCHAR2	(80)
ASSIGNMENT_NUMBER	NUMBER
ASSIGNMENT_TEMPLATE_ID	NUMBER
ASSIGNMENT_TYPE	VARCHAR2	(30)
ATTRIBUTE1	VARCHAR2	(150)
ATTRIBUTE10	VARCHAR2	(150)
ATTRIBUTE11	VARCHAR2	(150)
ATTRIBUTE12	VARCHAR2	(150)
ATTRIBUTE13	VARCHAR2	(150)
ATTRIBUTE14	VARCHAR2	(150)
ATTRIBUTE15	VARCHAR2	(150)
ATTRIBUTE2	VARCHAR2	(150)
ATTRIBUTE3	VARCHAR2	(150)
ATTRIBUTE4	VARCHAR2	(150)
ATTRIBUTE5	VARCHAR2	(150)
ATTRIBUTE6	VARCHAR2	(150)
ATTRIBUTE7	VARCHAR2	(150)
ATTRIBUTE8	VARCHAR2	(150)
ATTRIBUTE9	VARCHAR2	(150)
ATTRIBUTE_CATEGORY	VARCHAR2	(30)
AVAILABILITY_MATCH_WEIGHTING	NUMBER
BILL_RATE_CURR_OVERRIDE	VARCHAR2	(30)
BILL_RATE_OVERRIDE	NUMBER
CALENDAR_ID	NUMBER
CALENDAR_TYPE	VARCHAR2	(30)
COMPETENCE_MATCH_WEIGHTING	NUMBER
CREATED_BY	NUMBER	(15)	Yes
CREATION_DATE	DATE		Yes
DESCRIPTION	VARCHAR2	(2000)
ENABLE_AUTO_CAND_NOM_FLAG	VARCHAR2	(1)
END_DATE	DATE
EXPENDITURE_ORGANIZATION_ID	NUMBER
EXPENDITURE_ORG_ID	NUMBER
EXPENDITURE_TYPE	VARCHAR2	(30)
EXPENDITURE_TYPE_CLASS	VARCHAR2	(30)
EXPENSE_LIMIT	NUMBER
EXPENSE_LIMIT_CURRENCY_CODE	VARCHAR2	(15)
EXPENSE_OWNER	VARCHAR2	(30)
EXTENSION_POSSIBLE	VARCHAR2	(1)
FCST_JOB_GROUP_ID	NUMBER
FCST_JOB_ID	NUMBER
FCST_TP_AMOUNT_TYPE	VARCHAR2	(30)
JOB_LEVEL_MATCH_WEIGHTING	NUMBER
LAST_AUTO_SEARCH_DATE	DATE
LAST_UPDATED_BY	NUMBER	(15)	Yes
LAST_UPDATE_DATE	DATE		Yes
LAST_UPDATE_LOGIN	NUMBER	(15)
LOCATION_ID	NUMBER
MARKUP_PERCENT	NUMBER
MARKUP_PERCENT_OVERRIDE	NUMBER
MASS_WF_IN_PROGRESS_FLAG	VARCHAR2	(1)
MAX_RESOURCE_JOB_LEVEL	NUMBER
MIN_RESOURCE_JOB_LEVEL	NUMBER
MULTIPLE_STATUS_FLAG	VARCHAR2	(1)
NOTE_TO_APPROVER	VARCHAR2	(240)
NO_OF_ACTIVE_CANDIDATES	NUMBER
PENDING_APPROVAL_FLAG	VARCHAR2	(1)
PROJECT_ID	NUMBER
PROJECT_PARTY_ID	NUMBER
PROJECT_ROLE_ID	NUMBER
RECORD_VERSION_NUMBER	NUMBER
RESOURCE_CALENDAR_PERCENT	NUMBER
RESOURCE_ID	NUMBER
REVENUE_BILL_RATE	NUMBER
REVENUE_CURRENCY_CODE	VARCHAR2	(15)
SEARCH_COUNTRY_CODE	VARCHAR2	(2)
SEARCH_EXP_ORG_STRUCT_VER_ID	NUMBER
SEARCH_EXP_START_ORG_ID	NUMBER
SEARCH_MIN_AVAILABILITY	NUMBER
SEARCH_MIN_CANDIDATE_SCORE	NUMBER
SOURCE_ASSIGNMENT_ID	NUMBER
STAFFING_PRIORITY_CODE	VARCHAR2	(30)
START_DATE	DATE
STATUS_CODE	VARCHAR2	(30)
TEMPLATE_FLAG	VARCHAR2	(1)
TP_CALC_BASE_CODE_OVERRIDE	VARCHAR2	(30)
TP_CURRENCY_OVERRIDE	VARCHAR2	(30)
TP_PERCENT_APPLIED_OVERRIDE	NUMBER
TP_RATE_OVERRIDE	NUMBER
WORK_TYPE_ID	NUMBER
DISCOUNT_PERCENTAGE	NUMBER
RATE_DISC_REASON_CODE	VARCHAR2	(30)
STAFFING_OWNER_PERSON_ID	NUMBER
TRANSFER_PRICE_RATE	NUMBER
TRANSFER_PR_RATE_CURR	VARCHAR2	(15)
RESOURCE_LIST_MEMBER_ID	NUMBER

Query Text

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


SELECT PURGE_BATCH_ID
,      PURGE_PROJECT_ID
,      PURGE_RELEASE
,      ADDITIONAL_INFORMATION
,      APPRVL_STATUS_CODE
,      ASSIGNMENT_EFFORT
,      ASSIGNMENT_ID
,      ASSIGNMENT_NAME
,      ASSIGNMENT_NUMBER
,      ASSIGNMENT_TEMPLATE_ID
,      ASSIGNMENT_TYPE
,      ATTRIBUTE1
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE_CATEGORY
,      AVAILABILITY_MATCH_WEIGHTING
,      BILL_RATE_CURR_OVERRIDE
,      BILL_RATE_OVERRIDE
,      CALENDAR_ID
,      CALENDAR_TYPE
,      COMPETENCE_MATCH_WEIGHTING
,      CREATED_BY
,      CREATION_DATE
,      DESCRIPTION
,      ENABLE_AUTO_CAND_NOM_FLAG
,      END_DATE
,      EXPENDITURE_ORGANIZATION_ID
,      EXPENDITURE_ORG_ID
,      EXPENDITURE_TYPE
,      EXPENDITURE_TYPE_CLASS
,      EXPENSE_LIMIT
,      EXPENSE_LIMIT_CURRENCY_CODE
,      EXPENSE_OWNER
,      EXTENSION_POSSIBLE
,      FCST_JOB_GROUP_ID
,      FCST_JOB_ID
,      FCST_TP_AMOUNT_TYPE
,      JOB_LEVEL_MATCH_WEIGHTING
,      LAST_AUTO_SEARCH_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      LOCATION_ID
,      MARKUP_PERCENT
,      MARKUP_PERCENT_OVERRIDE
,      MASS_WF_IN_PROGRESS_FLAG
,      MAX_RESOURCE_JOB_LEVEL
,      MIN_RESOURCE_JOB_LEVEL
,      MULTIPLE_STATUS_FLAG
,      NOTE_TO_APPROVER
,      NO_OF_ACTIVE_CANDIDATES
,      PENDING_APPROVAL_FLAG
,      PROJECT_ID
,      PROJECT_PARTY_ID
,      PROJECT_ROLE_ID
,      RECORD_VERSION_NUMBER
,      RESOURCE_CALENDAR_PERCENT
,      RESOURCE_ID
,      REVENUE_BILL_RATE
,      REVENUE_CURRENCY_CODE
,      SEARCH_COUNTRY_CODE
,      SEARCH_EXP_ORG_STRUCT_VER_ID
,      SEARCH_EXP_START_ORG_ID
,      SEARCH_MIN_AVAILABILITY
,      SEARCH_MIN_CANDIDATE_SCORE
,      SOURCE_ASSIGNMENT_ID
,      STAFFING_PRIORITY_CODE
,      START_DATE
,      STATUS_CODE
,      TEMPLATE_FLAG
,      TP_CALC_BASE_CODE_OVERRIDE
,      TP_CURRENCY_OVERRIDE
,      TP_PERCENT_APPLIED_OVERRIDE
,      TP_RATE_OVERRIDE
,      WORK_TYPE_ID
,      DISCOUNT_PERCENTAGE
,      RATE_DISC_REASON_CODE
,      STAFFING_OWNER_PERSON_ID
,      TRANSFER_PRICE_RATE
,      TRANSFER_PR_RATE_CURR
,      RESOURCE_LIST_MEMBER_ID
FROM PA.PA_PROJECT_ASGMTS_AR#;

Dependencies

[top of page]

PA.PA_PROJECT_ASGMTS_AR# references the following:

PA: PA_PROJECT_ASGMTS_AR

PA.PA_PROJECT_ASGMTS_AR# is referenced by following:

APPS: PA_PROJECT_ASGMTS_AR