[Home] [Help] [Dependency Information]

VIEW: APPS.PA_PROJECT_OPEN_ASSNS_V

Object Details

Object Name:	PA_PROJECT_OPEN_ASSNS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PA.PA_PROJECT_OPEN_ASSNS_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 STAFFING_ANALYST_ID
,      PROJECT_ID
,      PROJECT_NAME
,      PROJECT_NUMBER
,      ORGANIZATION_ID
,      ORGANIZATION_NAME
,      PROJECT_MANAGER_ID
,      PROJECT_MANAGER_NAME
,      PROJECT_MANAGER_RESOURCE_ID
,      ASSIGNMENT_ID
,      ASSIGNMENT_NAME
,      ASSIGNMENT_TYPE
,      START_DATE
,      END_DATE
,      MIN_RESOURCE_JOB_LEVEL
,      MAX_RESOURCE_JOB_LEVEL
,      RECORD_VERSION_NUMBER
,      STATUS_NAME
,      STATUS_CODE
,      ASSIGNMENT_LOCATION_ID
,      STAFFING_PRIORITY_CODE
,      STAFFING_PRIORITY_NAME
,      NO_OF_ACTIVE_CANDIDATES
,      COMPETENCE_MATCH_WEIGHTING
,      AVAILABILITY_MATCH_WEIGHTING
,      JOB_LEVEL_MATCH_WEIGHTING
,      CITY
,      REGION
,      COUNTRY_CODE
,      COUNTRY
,      ASSIGNMENT_EFFORT
,      ASSIGNMENT_DURATION
,      CALENDAR_NAME
,      PROJECT_ROLE_ID
,      PROJECT_ROLE_NAME
,      WORK_TYPE_ID
,      WORK_TYPE_NAME
,      PROJECT_NAME_NUMBER
,      CUSTOMER_NAME
,      ASSIGNMENT_NUMBER
,      PROJECT_SUBTEAM_ID
,      PROJECT_SUBTEAM_NAME
,      DESCRIPTION
,      ADDITIONAL_INFORMATION
,      EXTENSION_POSSIBLE
,      EXPENSE_OWNER
,      EXPENSE_LIMIT
,      SEARCH_MIN_AVAILABILITY
,      ENABLE_AUTOMATED_SEARCH
,      SEARCH_EXP_ORG_HIERARCHY
,      SEARCH_EXP_ORG_STRUCT_VER_ID
,      SEARCH_EXP_START_ORG
,      SEARCH_EXP_START_ORG_ID
,      SEARCH_COUNTRY_NAME
,      SEARCH_COUNTRY_CODE
,      SEARCH_MIN_CANDIDATE_SCORE
,      EXPENDITURE_ORG_ID
,      EXPENDITURE_ORG_NAME
,      EXPENDITURE_ORGANIZATION_ID
,      EXPENDITURE_ORGANIZATION_NAME
,      EXPENDITURE_TYPE_CLASS
,      EXPENDITURE_TYPE
,      FCST_JOB_GROUP_ID
,      FCST_JOB_GROUP_NAME
,      FCST_JOB_ID
,      FCST_JOB_NAME
,      BILL_RATE_OVERRIDE
,      TP_RATE_OVERRIDE
,      ENABLE_AUTO_CAND_NOM_FLAG
,      ACTION_SET_ID
,      ACTION_SET_NAME
,      MULTIPLE_STATUS_FLAG
,      PROJECT_SUBTEAM_PARTY_ID
,      STAFFING_OWNER_PERSON_ID
,      STAFFING_OWNER_NAME
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      ACTION_SET_STATUS_NAME
,      ACTION_SET_STATUS_CODE
FROM APPS.PA_PROJECT_OPEN_ASSNS_V;

Dependencies

[top of page]

APPS

FND_GLOBAL - show dependent code

FND_TERRITORIES_TL

HR_ALL_ORGANIZATION_UNITS

JTF_CALENDARS_TL

PA_ACTION_SETS

PA_ADVERTISED_OPEN_REQ_V

PA_LOCATIONS

PA_LOOKUPS

PA_PROJECTS_ALL

PA_PROJECTS_MAINT_UTILS - show dependent code

PA_PROJECT_ASSIGNMENTS

PA_PROJECT_ROLE_TYPES

PA_PROJECT_STATUSES

PA_PROJECT_SUBTEAMS

PA_PROJECT_SUBTEAM_PARTIES

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_PROJECT_OPEN_ASSNS_V is not referenced by any database object