[Home] [Help] [Dependency Information]

VIEW: APPS.PA_PROJECT_ASSIGNMENTS_V

Object Details

Object Name:	PA_PROJECT_ASSIGNMENTS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PA.PA_PROJECT_ASSIGNMENTS_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

Query Text

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

SELECT ROW_ID
,      ASSIGNMENT_ID
,      ASSIGNMENT_NAME
,      ASSIGNMENT_TYPE
,      MULTIPLE_STATUS_FLAG
,      RECORD_VERSION_NUMBER
,      APPRVL_STATUS_CODE
,      APPRVL_STATUS_NAME
,      STATUS_CODE
,      STATUS_NAME
,      PROJECT_ID
,      PROJECT_ORGANIZATION_ID
,      PROJECT_ORGANIZATION_NAME
,      PROJECT_ROLE_ID
,      PROJECT_ROLE_NAME
,      RESOURCE_ID
,      RESOURCE_NAME
,      RESOURCE_ORGANIZATION_ID
,      RESOURCE_ORGANIZATION
,      RESOURCE_CUR_ORGANZATION_ID
,      RESOURCE_CUR_ORGANIZATION
,      MANAGER_ID
,      MANAGER_NAME
,      PROJECT_PARTY_ID
,      PROJECT_SUBTEAM_ID
,      PROJECT_SUBTEAM_NAME
,      PROJECT_SUBTEAM_PARTY_ID
,      START_DATE
,      END_DATE
,      PROJECT_NAME
,      PROJECT_NUMBER
,      ASSIGNMENT_DURATION
,      ASSIGNMENT_EFFORT
,      EXTENSION_POSSIBLE
,      MIN_RESOURCE_JOB_LEVEL
,      MAX_RESOURCE_JOB_LEVEL
,      ASSIGNMENT_NUMBER
,      ADDITIONAL_INFORMATION
,      LOCATION_ID
,      CITY
,      REGION
,      COUNTRY_CODE
,      COUNTRY
,      DESCRIPTION
,      NOTE_TO_APPROVER
,      CALENDAR_ID
,      CALENDAR_NAME
,      CALENDAR_TYPE
,      RESOURCE_CALENDAR_PERCENT
,      WORK_TYPE_ID
,      WORK_TYPE_NAME
,      EXPENSE_OWNER
,      EXPENSE_OWNER_NAME
,      EXPENSE_LIMIT
,      EXPENSE_LIMIT_CURRENCY_CODE
,      FCST_JOB_ID
,      FCST_JOB_NAME
,      FCST_JOB_GROUP_ID
,      FCST_JOB_GROUP_NAME
,      EXPENDITURE_ORG_ID
,      EXPENDITURE_ORG_NAME
,      EXPENDITURE_ORGANIZATION_ID
,      EXPENDITURE_ORGANIZATION_NAME
,      EXPENDITURE_TYPE_CLASS
,      EXPENDITURE_TYPE
,      FCST_TP_AMOUNT_TYPE
,      FCST_TP_AMOUNT_TYPE_NAME
,      STAFFING_PRIORITY_CODE
,      STAFFING_PRIORITY_NAME
,      STAFFING_OWNER_PERSON_ID
,      STAFFING_OWNER_NAME
,      PROJECT_TYPE
,      REVENUE_BILL_RATE
,      REVENUE_CURRENCY_CODE
,      MARKUP_PERCENT
,      PROJECT_SYSTEM_STATUS_CODE
,      NO_OF_ACTIVE_CANDIDATES
,      SOURCE_ASSIGNMENT_ID
,      ASSIGNMENT_TEMPLATE_ID
,      MASS_WF_IN_PROGRESS_FLAG
,      COMPETENCE_MATCH_WEIGHTING
,      AVAILABILITY_MATCH_WEIGHTING
,      JOB_LEVEL_MATCH_WEIGHTING
,      SEARCH_MIN_AVAILABILITY
,      SEARCH_COUNTRY_NAME
,      SEARCH_COUNTRY_CODE
,      SEARCH_EXP_ORG_HIERARCHY
,      SEARCH_EXP_ORG_STRUCT_VER_ID
,      SEARCH_EXP_START_ORG
,      SEARCH_EXP_START_ORG_ID
,      SEARCH_MIN_CANDIDATE_SCORE
,      ENABLE_AUTO_CAND_NOM_FLAG
,      LAST_AUTO_SEARCH_DATE
,      ENABLE_AUTOMATED_SEARCH
,      PENDING_APPROVAL_FLAG
,      BILL_RATE_OVERRIDE
,      BILL_RATE_CURR_OVERRIDE
,      MARKUP_PERCENT_OVERRIDE
,      DISCOUNT_PERCENTAGE
,      RATE_DISC_REASON_CODE
,      TP_RATE_OVERRIDE
,      TP_CURRENCY_OVERRIDE
,      TP_CALC_BASE_CODE_OVERRIDE
,      TP_PERCENT_APPLIED_OVERRIDE
,      MULTI_CURRENCY_BILLING_FLAG
,      CREATION_DATE
,      FCST_PROCESS_LAST_RUN_DATE
,      TRANSFER_PRICE_RATE
,      TRANSFER_PR_RATE_CURR
,      RESOURCE_LIST_MEMBER_ID
,      RESOURCE_LIST_MEMBER_NAME
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      PLANNING_RESOURCE_NAME
,      PROJECT_STATUS
,      PERSON_TYPE
,      EMAIL_ADDRESS
,      LAST_UPDATE_DATE
FROM APPS.PA_PROJECT_ASSIGNMENTS_V;

Dependencies

[top of page]

APPS

FND_LOOKUP_VALUES

FND_TERRITORIES_TL

HR_GENERAL - show dependent code

HR_PERSON_NAME - show dependent code

HR_SECURITY - show dependent code

JTF_CALENDARS_TL

PA_EXPENDITURES_UTILS - show dependent code

PA_GENERATE_FORECAST_PUB - 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_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

PER_PEOPLE_F

APPS

PA_ASGMT_WFSTD - show dependent code

PA_ASSIGNMENTS_PUB - show dependent code

PA_MASS_ASGMT_TRX - show dependent code

PA_SCHEDULE_PUB - show dependent code