DBA Data[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: ViewPA.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
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
ASSIGNMENT_ID NUMBER
Yes
ASSIGNMENT_NAME VARCHAR2 (80) Yes
ASSIGNMENT_TYPE VARCHAR2 (30) Yes
MULTIPLE_STATUS_FLAG VARCHAR2 (1) Yes
RECORD_VERSION_NUMBER NUMBER
Yes
APPRVL_STATUS_CODE VARCHAR2 (30)
APPRVL_STATUS_NAME VARCHAR2 (80)
STATUS_CODE VARCHAR2 (30)
STATUS_NAME VARCHAR2 (80)
PROJECT_ID NUMBER

PROJECT_ORGANIZATION_ID NUMBER (15) Yes
PROJECT_ORGANIZATION_NAME VARCHAR2 (4000)
PROJECT_ROLE_ID NUMBER

PROJECT_ROLE_NAME VARCHAR2 (80) Yes
RESOURCE_ID NUMBER

RESOURCE_NAME VARCHAR2 (4000)
RESOURCE_ORGANIZATION_ID NUMBER

RESOURCE_ORGANIZATION VARCHAR2 (4000)
RESOURCE_CUR_ORGANZATION_ID NUMBER

RESOURCE_CUR_ORGANIZATION VARCHAR2 (4000)
MANAGER_ID NUMBER (15)
MANAGER_NAME VARCHAR2 (240)
PROJECT_PARTY_ID NUMBER

PROJECT_SUBTEAM_ID NUMBER

PROJECT_SUBTEAM_NAME VARCHAR2 (80)
PROJECT_SUBTEAM_PARTY_ID NUMBER

START_DATE DATE

END_DATE DATE

PROJECT_NAME VARCHAR2 (30) Yes
PROJECT_NUMBER VARCHAR2 (25) Yes
ASSIGNMENT_DURATION NUMBER

ASSIGNMENT_EFFORT NUMBER

EXTENSION_POSSIBLE VARCHAR2 (1)
MIN_RESOURCE_JOB_LEVEL NUMBER

MAX_RESOURCE_JOB_LEVEL NUMBER

ASSIGNMENT_NUMBER NUMBER

ADDITIONAL_INFORMATION VARCHAR2 (2000)
LOCATION_ID NUMBER

CITY VARCHAR2 (80)
REGION VARCHAR2 (240)
COUNTRY_CODE VARCHAR2 (2)
COUNTRY VARCHAR2 (80)
DESCRIPTION VARCHAR2 (2000)
NOTE_TO_APPROVER VARCHAR2 (240)
CALENDAR_ID NUMBER

CALENDAR_NAME VARCHAR2 (50)
CALENDAR_TYPE VARCHAR2 (30)
RESOURCE_CALENDAR_PERCENT NUMBER

WORK_TYPE_ID NUMBER

WORK_TYPE_NAME VARCHAR2 (80) Yes
EXPENSE_OWNER VARCHAR2 (30)
EXPENSE_OWNER_NAME VARCHAR2 (80)
EXPENSE_LIMIT NUMBER

EXPENSE_LIMIT_CURRENCY_CODE VARCHAR2 (15)
FCST_JOB_ID NUMBER

FCST_JOB_NAME VARCHAR2 (700)
FCST_JOB_GROUP_ID NUMBER

FCST_JOB_GROUP_NAME VARCHAR2 (30)
EXPENDITURE_ORG_ID NUMBER

EXPENDITURE_ORG_NAME VARCHAR2 (4000)
EXPENDITURE_ORGANIZATION_ID NUMBER

EXPENDITURE_ORGANIZATION_NAME VARCHAR2 (4000)
EXPENDITURE_TYPE_CLASS VARCHAR2 (30)
EXPENDITURE_TYPE VARCHAR2 (30)
FCST_TP_AMOUNT_TYPE VARCHAR2 (30)
FCST_TP_AMOUNT_TYPE_NAME VARCHAR2 (80)
STAFFING_PRIORITY_CODE VARCHAR2 (30)
STAFFING_PRIORITY_NAME VARCHAR2 (80)
STAFFING_OWNER_PERSON_ID NUMBER

STAFFING_OWNER_NAME VARCHAR2 (4000)
PROJECT_TYPE VARCHAR2 (20) Yes
REVENUE_BILL_RATE NUMBER

REVENUE_CURRENCY_CODE VARCHAR2 (15)
MARKUP_PERCENT NUMBER

PROJECT_SYSTEM_STATUS_CODE VARCHAR2 (30)
NO_OF_ACTIVE_CANDIDATES NUMBER

SOURCE_ASSIGNMENT_ID NUMBER

ASSIGNMENT_TEMPLATE_ID NUMBER

MASS_WF_IN_PROGRESS_FLAG VARCHAR2 (1)
COMPETENCE_MATCH_WEIGHTING NUMBER

AVAILABILITY_MATCH_WEIGHTING NUMBER

JOB_LEVEL_MATCH_WEIGHTING NUMBER

SEARCH_MIN_AVAILABILITY NUMBER

SEARCH_COUNTRY_NAME VARCHAR2 (80)
SEARCH_COUNTRY_CODE VARCHAR2 (2)
SEARCH_EXP_ORG_HIERARCHY VARCHAR2 (30)
SEARCH_EXP_ORG_STRUCT_VER_ID NUMBER

SEARCH_EXP_START_ORG VARCHAR2 (4000)
SEARCH_EXP_START_ORG_ID NUMBER

SEARCH_MIN_CANDIDATE_SCORE NUMBER

ENABLE_AUTO_CAND_NOM_FLAG VARCHAR2 (1)
LAST_AUTO_SEARCH_DATE DATE

ENABLE_AUTOMATED_SEARCH VARCHAR2 (1)
PENDING_APPROVAL_FLAG VARCHAR2 (1)
BILL_RATE_OVERRIDE NUMBER

BILL_RATE_CURR_OVERRIDE VARCHAR2 (30)
MARKUP_PERCENT_OVERRIDE NUMBER

DISCOUNT_PERCENTAGE NUMBER

RATE_DISC_REASON_CODE VARCHAR2 (30)
TP_RATE_OVERRIDE NUMBER

TP_CURRENCY_OVERRIDE VARCHAR2 (30)
TP_CALC_BASE_CODE_OVERRIDE VARCHAR2 (30)
TP_PERCENT_APPLIED_OVERRIDE NUMBER

MULTI_CURRENCY_BILLING_FLAG VARCHAR2 (1)
CREATION_DATE DATE
Yes
FCST_PROCESS_LAST_RUN_DATE DATE

TRANSFER_PRICE_RATE NUMBER

TRANSFER_PR_RATE_CURR VARCHAR2 (15)
RESOURCE_LIST_MEMBER_ID NUMBER

RESOURCE_LIST_MEMBER_NAME VARCHAR2 (4000)
ATTRIBUTE_CATEGORY VARCHAR2 (30)
ATTRIBUTE1 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)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
PLANNING_RESOURCE_NAME VARCHAR2 (80)
PROJECT_STATUS VARCHAR2 (80)
PERSON_TYPE VARCHAR2 (80) Yes
EMAIL_ADDRESS VARCHAR2 (240)
LAST_UPDATE_DATE DATE
Yes
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.PA_PROJECT_ASSIGNMENTS_V references the following:

SchemaAPPS
SynonymFND_LOOKUP_VALUES
SynonymFND_TERRITORIES_TL
PL/SQL PackageHR_GENERAL - show dependent code
PL/SQL PackageHR_PERSON_NAME - show dependent code
PL/SQL PackageHR_SECURITY - show dependent code
SynonymJTF_CALENDARS_TL
PL/SQL PackagePA_EXPENDITURES_UTILS - show dependent code
PL/SQL PackagePA_GENERATE_FORECAST_PUB - show dependent code
SynonymPA_LOCATIONS
ViewPA_LOOKUPS
PL/SQL PackagePA_PLANNING_RESOURCE_UTILS - show dependent code
SynonymPA_PROJECTS_ALL
SynonymPA_PROJECT_ASSIGNMENTS
ViewPA_PROJECT_ROLE_TYPES
SynonymPA_PROJECT_STATUSES
SynonymPA_PROJECT_SUBTEAMS
SynonymPA_PROJECT_SUBTEAM_PARTIES
SynonymPA_RESOURCES_DENORM
SynonymPA_RESOURCE_LIST_MEMBERS
PL/SQL PackagePA_RESOURCE_UTILS - show dependent code
PL/SQL PackagePA_ROLE_JOB_BG_UTILS - show dependent code
ViewPA_WORK_TYPES_V
SynonymPER_JOBS
SynonymPER_JOB_GROUPS
SynonymPER_ORGANIZATION_STRUCTURES
SynonymPER_ORG_STRUCTURE_VERSIONS
ViewPER_PEOPLE_F
APPS.PA_PROJECT_ASSIGNMENTS_V is referenced by following:

SchemaAPPS
Package BodyPA_ASGMT_WFSTD - show dependent code
Package BodyPA_ASSIGNMENTS_PUB - show dependent code
Package BodyPA_MASS_ASGMT_TRX - show dependent code
Package BodyPA_SCHEDULE_PUB - show dependent code