DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.PA_REQUIREMENTS_AMG_V

Object Details
Object Name: PA_REQUIREMENTS_AMG_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPA.PA_REQUIREMENTS_AMG_V
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


This view shows all project requirements


[View Source]

Columns
Name Datatype Length Mandatory Comments
PROJECT_ID NUMBER (15) Yes The identifier of the project to which the requirement belongs
PROJECT_NAME VARCHAR2 (30) Yes The name of the project to which the requirement belongs
PROJECT_NUMBER VARCHAR2 (25) Yes The number of the project to which the requirement belongs
ORGANIZATION_ID NUMBER (15) Yes The identifier of the project organization
ORGANIZATION_NAME VARCHAR2 (240) Yes The name of the project organization
PROJECT_MANAGER_ID NUMBER

The identifier of the project manager
PROJECT_MANAGER_NAME VARCHAR2 (4000)
The name of the project manager
REQUIREMENT_ID NUMBER
Yes The identifier of the requirement
REQUIREMENT_NAME VARCHAR2 (80) Yes The name of the requirement
REQUIREMENT_NUMBER NUMBER

The system-generated reference number of the requirement
REQUIREMENT_DESCRIPTION VARCHAR2 (2000)
The description of the requirement
REQUIREMENT_START_DATE DATE

The start date of the requirement
REQUIREMENT_END_DATE DATE

The end date of the requirement
REQUIREMENT_DURATION NUMBER

The duration of the requirement
ADDITIONAL_INFORMATION VARCHAR2 (2000)
The additional information of the requirement
MIN_RESOURCE_JOB_LEVEL NUMBER

The minimum acceptable job level for the requirement
MAX_RESOURCE_JOB_LEVEL NUMBER

The maximum acceptable job level for the requirement
RECORD_VERSION_NUMBER NUMBER
Yes The system-generated version of the requirement record
REQUIREMENT_STATUS_NAME VARCHAR2 (80)
The status name of the requirement
REQUIREMENT_STATUS_CODE VARCHAR2 (30)
The status code of the requirement
MULTIPLE_STATUS_FLAG VARCHAR2 (1) Yes Flag indicating whether the underlying schedule of the requirement has more than one status
EXPENDITURE_ORG_ID NUMBER

The expenditure operating unit identifier for the requirement
EXPENDITURE_ORG_NAME VARCHAR2 (4000)
The expenditure operating unit name for the requirement
EXPENDITURE_ORGANIZATION_ID NUMBER

The expenditure organization identifier for the requirement
EXPENDITURE_ORGANIZATION_NAME VARCHAR2 (4000)
The expenditure organization name for the requirement
LOCATION_ID NUMBER

The location identifier for the requirement
LOCATION_CITY VARCHAR2 (80)
The city for the requirement
LOCATION_REGION VARCHAR2 (240)
The state or region for the requirement
LOCATION_COUNTRY_CODE VARCHAR2 (2)
The country code for the requirement
LOCATION_COUNTRY_NAME VARCHAR2 (80)
The country name for the requirement
STAFFING_PRIORITY_CODE VARCHAR2 (30)
The staffing priority code of the requirement
STAFFING_PRIORITY_NAME VARCHAR2 (80)
The staffing priority name of the requirement
NO_OF_ACTIVE_CANDIDATES NUMBER

The number of active candidates for the requirement
COMPETENCE_MATCH_WEIGHTING NUMBER

The weight given to the competence match when evaluating the candidate search score
AVAILABILITY_MATCH_WEIGHTING NUMBER

The weight given to the availability match when evaluating the candidate search score
JOB_LEVEL_MATCH_WEIGHTING NUMBER

The weight given to the job level match when evaluating the candidate search score
CALENDAR_NAME VARCHAR2 (50)
The name of the calendar for the requirement
PROJECT_ROLE_ID NUMBER

The identifier of the project role for the requirement
PROJECT_ROLE_NAME VARCHAR2 (80) Yes The name of the project role for the requirement
WORK_TYPE_ID NUMBER

The identifier of the work type for the requirement
WORK_TYPE_NAME VARCHAR2 (80) Yes The name of the work type for the requirement
PROJECT_SUBTEAM_ID NUMBER

The identifier of the project subteam to which the requirement belongs
PROJECT_SUBTEAM_NAME VARCHAR2 (80)
The name of the project subteam to which the requirement belongs
EXTENSION_POSSIBLE VARCHAR2 (1)
This flag indicates whether the requirement can be extended or not
EXPENSE_OWNER VARCHAR2 (30)
The owner of the expenses of the requirement
EXPENSE_LIMIT NUMBER

The limit for the expenses of the requirement
SEARCH_MIN_AVAILABILITY NUMBER

The minimum availability percentage of resources to be eligible for getting assigned on the requirement
SEARCH_EXP_ORG_HIERARCHY VARCHAR2 (30)
The expenditure organization hierarchy name for the requirement
SEARCH_EXP_ORG_STRUCT_VER_ID NUMBER

The expenditure organization hierarchy identifier for the requirement
SEARCH_EXP_START_ORG VARCHAR2 (4000)
The name of the starting organization in the expenditure organization hierarchy
SEARCH_EXP_START_ORG_ID NUMBER

The identifier of the starting organization in the expenditure organization hierarchy
SEARCH_COUNTRY_NAME VARCHAR2 (80)
The country name to be used in candidate search for the requirement
SEARCH_COUNTRY_CODE VARCHAR2 (2)
The country code to be used in candidate search for the requirement
SEARCH_MIN_CANDIDATE_SCORE NUMBER

The minimum candidate score required for candidate nomination for the requirement
EXPENDITURE_TYPE_CLASS VARCHAR2 (30)
The expenditure type class to be used to generate forecast transactions on the requirement
EXPENDITURE_TYPE VARCHAR2 (30)
The expenditure type to be used to generate forecast transactions on the requirement
FCST_JOB_GROUP_ID NUMBER

The identifier of the job group associated with the forecasting job
FCST_JOB_GROUP_NAME VARCHAR2 (30)
The name of the job group associated with the forecasting job
FCST_JOB_ID NUMBER

The identifier of the forecasting job for the requirement
FCST_JOB_NAME VARCHAR2 (700)
The name of the forecasting job for the requirement
RATE_DISC_REASON_CODE VARCHAR2 (30)
The discount reason code for the requirement
DISCOUNT_PERCENTAGE NUMBER

The discount percentage for the requirement
BILL_RATE_OVERRIDE NUMBER

The override bill rate for the requirement
BILL_RATE_CURR_OVERRIDE VARCHAR2 (30)
The override bill rate currency code for the requirement
MARKUP_PERCENT_OVERRIDE NUMBER

The override markup percent for the requirement
TP_RATE_OVERRIDE NUMBER

The override transfer price rate for the requirement
TP_CURRENCY_OVERRIDE VARCHAR2 (30)
The override transfer price rate currency code for the requirement
TP_CALC_BASE_CODE_OVERRIDE VARCHAR2 (30)
The override transfer price basis code for the requirement
TP_PERCENT_APPLIED_OVERRIDE NUMBER

The percentage of the transfer price basis
ENABLE_AUTO_CAND_NOM_FLAG VARCHAR2 (1)
This flag indicates whether automatic candidate nomination is enabled for the requirement
ADV_ACTION_SET_ID NUMBER (15) Yes The identifier of the advertisement rule to be applied on the requirement
ADV_ACTION_SET_NAME VARCHAR2 (80) Yes The name of the advertisement rule to be applied on the requirement
STAFFING_OWNER_PERSON_ID NUMBER

The identifier of the staffing owner of the requirement
STAFFING_OWNER_PERSON_NAME VARCHAR2 (4000)
The name of the staffing owner of the requirement
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield context
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment
ORIG_SYSTEM_CODE VARCHAR2 (80)
The identifier of the external project management system from which the requirement data was imported
ORIG_SYSTEM_REFERENCE VARCHAR2 (240)
The identifier of the requirement data in the external project management system from which the requirement data was imported
CREATION_DATE DATE
Yes The creation date of the requirement
LAST_UPDATE_DATE DATE
Yes The last updated date of the requirement
Query Text

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


SELECT PROJECT_ID
,      PROJECT_NAME
,      PROJECT_NUMBER
,      ORGANIZATION_ID
,      ORGANIZATION_NAME
,      PROJECT_MANAGER_ID
,      PROJECT_MANAGER_NAME
,      REQUIREMENT_ID
,      REQUIREMENT_NAME
,      REQUIREMENT_NUMBER
,      REQUIREMENT_DESCRIPTION
,      REQUIREMENT_START_DATE
,      REQUIREMENT_END_DATE
,      REQUIREMENT_DURATION
,      ADDITIONAL_INFORMATION
,      MIN_RESOURCE_JOB_LEVEL
,      MAX_RESOURCE_JOB_LEVEL
,      RECORD_VERSION_NUMBER
,      REQUIREMENT_STATUS_NAME
,      REQUIREMENT_STATUS_CODE
,      MULTIPLE_STATUS_FLAG
,      EXPENDITURE_ORG_ID
,      EXPENDITURE_ORG_NAME
,      EXPENDITURE_ORGANIZATION_ID
,      EXPENDITURE_ORGANIZATION_NAME
,      LOCATION_ID
,      LOCATION_CITY
,      LOCATION_REGION
,      LOCATION_COUNTRY_CODE
,      LOCATION_COUNTRY_NAME
,      STAFFING_PRIORITY_CODE
,      STAFFING_PRIORITY_NAME
,      NO_OF_ACTIVE_CANDIDATES
,      COMPETENCE_MATCH_WEIGHTING
,      AVAILABILITY_MATCH_WEIGHTING
,      JOB_LEVEL_MATCH_WEIGHTING
,      CALENDAR_NAME
,      PROJECT_ROLE_ID
,      PROJECT_ROLE_NAME
,      WORK_TYPE_ID
,      WORK_TYPE_NAME
,      PROJECT_SUBTEAM_ID
,      PROJECT_SUBTEAM_NAME
,      EXTENSION_POSSIBLE
,      EXPENSE_OWNER
,      EXPENSE_LIMIT
,      SEARCH_MIN_AVAILABILITY
,      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_TYPE_CLASS
,      EXPENDITURE_TYPE
,      FCST_JOB_GROUP_ID
,      FCST_JOB_GROUP_NAME
,      FCST_JOB_ID
,      FCST_JOB_NAME
,      RATE_DISC_REASON_CODE
,      DISCOUNT_PERCENTAGE
,      BILL_RATE_OVERRIDE
,      BILL_RATE_CURR_OVERRIDE
,      MARKUP_PERCENT_OVERRIDE
,      TP_RATE_OVERRIDE
,      TP_CURRENCY_OVERRIDE
,      TP_CALC_BASE_CODE_OVERRIDE
,      TP_PERCENT_APPLIED_OVERRIDE
,      ENABLE_AUTO_CAND_NOM_FLAG
,      ADV_ACTION_SET_ID
,      ADV_ACTION_SET_NAME
,      STAFFING_OWNER_PERSON_ID
,      STAFFING_OWNER_PERSON_NAME
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ORIG_SYSTEM_CODE
,      ORIG_SYSTEM_REFERENCE
,      CREATION_DATE
,      LAST_UPDATE_DATE
FROM APPS.PA_REQUIREMENTS_AMG_V;

Dependencies

[top of page]

APPS.PA_REQUIREMENTS_AMG_V references the following:

SchemaAPPS
PL/SQL PackageFND_GLOBAL - show dependent code
SynonymFND_TERRITORIES_TL
SynonymHR_ALL_ORGANIZATION_UNITS
SynonymJTF_CALENDARS_TL
SynonymPA_ACTION_SETS
ViewPA_ADVERTISED_OPEN_REQ_V
PL/SQL PackagePA_EXPENDITURES_UTILS - show dependent code
SynonymPA_LOCATIONS
ViewPA_LOOKUPS
SynonymPA_PROJECTS_ALL
SynonymPA_PROJECT_ASSIGNMENTS
ViewPA_PROJECT_ROLE_TYPES
SynonymPA_PROJECT_STATUSES
SynonymPA_PROJECT_SUBTEAMS
SynonymPA_PROJECT_SUBTEAM_PARTIES
PL/SQL PackagePA_RESOURCE_PVT - show dependent code
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

APPS.PA_REQUIREMENTS_AMG_V is not referenced by any database object