[Home] [Help] [Dependency Information]
Object Name: | PA_PROJECTS_PRM_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PA.PA_PROJECTS_PRM_V |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PROJECT_ID | NUMBER | (15) | Yes | The system-generated number that uniquely identifies the project |
NAME | VARCHAR2 | (30) | Yes | User-defined name that uniquely identifies the project |
LONG_NAME | VARCHAR2 | (240) | User-defined long name that uniquely identifies the project | |
SEGMENT1 | VARCHAR2 | (25) | Yes | The project number that uniquely identifies the project. The project number can be user-entered or system-generated as defined in the implementation options |
LAST_UPDATE_DATE | DATE | Yes | Standard Who Column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who Column |
CREATION_DATE | DATE | Yes | Standard Who Column | |
CREATED_BY | NUMBER | (15) | Yes | Standard Who Column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Yes | Standard Who Column |
PROJECT_TYPE | VARCHAR2 | (20) | Yes | The project type that classifies the project and defaults project information upon project entry |
PROJECT_TYPE_CLASS_CODE | VARCHAR2 | (30) | Indicates the class of project type | |
CARRYING_OUT_ORGANIZATION_ID | NUMBER | (15) | Yes | Name of the organization |
CARRYING_OUT_ORGANIZATION_NAME | VARCHAR2 | (240) | Yes | |
PUBLIC_SECTOR_FLAG | VARCHAR2 | (1) | Yes | Flag that indicates whether the project is in the public sector or the private sector |
PUBLIC_SECTOR_MEANING | VARCHAR2 | (80) | Yes | |
PROJECT_STATUS_CODE | VARCHAR2 | (30) | Yes | The status of the project. |
PROJECT_STATUS_NAME | VARCHAR2 | (80) | Yes | The user_defined project status name |
PROJECT_SYSTEM_STATUS_CODE | VARCHAR2 | (30) | Yes | The corresponding system status code |
DESCRIPTION | VARCHAR2 | (250) | The description of the project | |
START_DATE | DATE | The date on which the project starts; expenditure items with item dates before the start date cannot be entered for the project | ||
COMPLETION_DATE | DATE | The date on which the project is completed, expenditure items with item dates after the completion date cannot be entered for the project | ||
CLOSED_DATE | DATE | The date that the project was closed by changing the project status to Closed | ||
DISTRIBUTION_RULE | VARCHAR2 | (30) | The distribution rule that specifies the contract projects revenue accrual and billing method | |
LABOR_INVOICE_FORMAT_ID | NUMBER | (15) | The identifier of the invoice format used to group and format labor expenditure items into invoice lines | |
NON_LABOR_INVOICE_FORMAT_ID | NUMBER | (15) | The identifier of the invoice format used to group and format non-labor expenditure items into invoice lines | |
RETENTION_INVOICE_FORMAT_ID | NUMBER | (15) | The identifier of the invoice format used to format a retention line on the projects invoices | |
RETENTION_PERCENTAGE | NUMBER | (17) | The percentage to be retained on each invoice generated for the project | |
BILLING_OFFSET | NUMBER | (15) | The number of days after the project start date when the first invoice for the project is created | |
BILLING_CYCLE | NUMBER | (15) | Obsolete | |
BILLING_CYCLE_ID | NUMBER | (15) | The identifier of the billing cycle which applies to the project | |
LABOR_STD_BILL_RATE_SCHDL | VARCHAR2 | (20) | The labor standard bill rate schedule that defaults to new tasks created for the project | |
LABOR_BILL_RATE_ORG_ID | NUMBER | (15) | The identifier of the organization that owns the labor standard bill rate schedule | |
LABOR_SCHEDULE_FIXED_DATE | DATE | The fixed date used to determine the effective bill rates of the standard labor bill rate schedule. The project fixed date is a default for the task fixed date | ||
LABOR_SCHEDULE_DISCOUNT | NUMBER | (7) | The percentage to be discounted from the standard labor bill rate schedule. The project discount is a default for the task discount | |
TEMPLATE_FLAG | VARCHAR2 | (1) | Indicates whether the project is a Template or not | |
VERIFICATION_DATE | DATE | Not currently used | ||
CREATED_FROM_PROJECT_ID | NUMBER | (15) | Holds the Project id of the source project. This value would be null for templates | |
CREATED_FROM_PROJECT_NAME | VARCHAR2 | (30) | ||
TEMPLATE_START_DATE_ACTIVE | DATE | The effective start date of the template | ||
NON_LABOR_STD_BILL_RATE_SCHDL | VARCHAR2 | (30) | The non-labor standard bill rate schedule that defaults to new tasks created for the project | |
TEMPLATE_END_DATE_ACTIVE | DATE | Last effective date of the Template | ||
NON_LABOR_BILL_RATE_ORG_ID | NUMBER | (15) | The identifier of the organization that owns the non-labor standard bill rate schedule | |
NON_LABOR_SCHEDULE_FIXED_DATE | DATE | The fixed date used to determine the effective bill rates of the standard non-labor bill rate schedule. The project fixed date is a default for the task fixed date | ||
NON_LABOR_SCHEDULE_DISCOUNT | NUMBER | (7) | The percentage to be discounted from the standard non-labor bill rate schedule.The project discount is a default for the task discount | |
LIMIT_TO_TXN_CONTROLS_FLAG | VARCHAR2 | (1) | Flag that indicates if users can only charge expenditures to the project that are listed in the transaction controls. If flag = Y, then only items listed in the controls are allowed. If flag = N or null, then items not listed are allowed | |
PROJECT_LEVEL_FUNDING_FLAG | VARCHAR2 | (1) | Flag that indicates if the project is funded at the project level (Y) or the top task level (N). This flag is set when the project is baselined | |
INVOICE_COMMENT | VARCHAR2 | (240) | Free text comment that can be printed on an invoice. The invoice comment defined for the project is defaulted to the invoice comment for the draft invoices of the project | |
UNBILLED_RECEIVABLE_DR | NUMBER | (22) | The unbilled receivables balance for the project that is posted to Oracle General Ledger or Oracle Receivables. This value is maintained by the Transfer Revenue and Transfer Invoices processes | |
UNEARNED_REVENUE_CR | NUMBER | (22) | The unearned revenue balance for the project that is posted to Oracle General Ledger or Oracle Receivables. This value is maintained by the Transfer Revenue and Transfer Invoices processes | |
REQUEST_ID | NUMBER | (15) | Standard Who Column | |
PROGRAM_ID | NUMBER | (15) | Standard Who Column | |
PROGRAM_APPLICATION_ID | NUMBER | (15) | Standard Who Column | |
PROGRAM_UPDATE_DATE | DATE | Standard Who Column | ||
SUMMARY_FLAG | VARCHAR2 | (1) | Yes | Flag used with the project key flexfield. The project key flexfield is not implemented |
ENABLED_FLAG | VARCHAR2 | (1) | Yes | Flag used with the key flexfield. The project key flexfield is not implemented |
SEGMENT2 | VARCHAR2 | (25) | Key flexfield segment - not implemented | |
SEGMENT3 | VARCHAR2 | (25) | Key flexfield segment - not implemented | |
SEGMENT4 | VARCHAR2 | (25) | Key flexfield segment - not implemented | |
SEGMENT5 | VARCHAR2 | (25) | Key flexfield segment - not implemented | |
SEGMENT6 | VARCHAR2 | (25) | Key flexfield segment - not implemented | |
SEGMENT7 | VARCHAR2 | (25) | Key flexfield segment - not implemented | |
SEGMENT8 | VARCHAR2 | (25) | Key flexfield segment - not implemented | |
SEGMENT9 | VARCHAR2 | (25) | Key flexfield segment - not implemented | |
SEGMENT10 | VARCHAR2 | (25) | Key flexfield segment - not implemented | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield content field | |
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 | |
COST_IND_RATE_SCH_ID | NUMBER | (15) | The identifier of default costing burden schedule | |
REV_IND_RATE_SCH_ID | NUMBER | (15) | The identifier of default revenue burden schedule | |
INV_IND_RATE_SCH_ID | NUMBER | (15) | The identifier of default invoice burden schedule | |
COST_IND_SCH_FIXED_DATE | DATE | The schedule fixed date of firm costing burden schedule | ||
REV_IND_SCH_FIXED_DATE | DATE | The schedule fixed date of firm revenue burden schedule | ||
INV_IND_SCH_FIXED_DATE | DATE | The schedule fixed date of firm invoice burden schedule | ||
LABOR_SCH_TYPE | VARCHAR2 | (1) | The schedule type of labor expenditure items | |
NON_LABOR_SCH_TYPE | VARCHAR2 | (1) | The schedule type of non-labor expenditure items | |
OVR_COST_IND_RATE_SCH_ID | NUMBER | (15) | This column is not used | |
OVR_REV_IND_RATE_SCH_ID | NUMBER | (15) | This column is not used | |
OVR_INV_IND_RATE_SCH_ID | NUMBER | (15) | This column is not used | |
ORG_ID | NUMBER | (15) | Operating unit identifier for multi-organization installations | |
PM_PRODUCT_CODE | VARCHAR2 | (30) | The identifier of the external project management system from which the project was imported. | |
PM_PROJECT_REFERENCE | VARCHAR2 | (25) | The identifer of the project in the external project management system from which the project was imported. | |
ACTUAL_START_DATE | DATE | The actual start date of the project. Applicable only for a project that has originated from an external system. | ||
ACTUAL_FINISH_DATE | DATE | The actual end date of the project. Applicable only for a project that has originated from an external system. | ||
EARLY_START_DATE | DATE | The early start date of the project. Applicable only for a project that has originated from an external system. | ||
EARLY_FINISH_DATE | DATE | The early finish date of the project. Applicable only for a project that has originated from an external system. | ||
LATE_START_DATE | DATE | The late start date of the project. Applicable only for a project that has originated from an external system. | ||
LATE_FINISH_DATE | DATE | The late finish date of the project. Applicable only for a project that has originated from an external system. | ||
SCHEDULED_START_DATE | DATE | The scheduled start date of the project. Applicable only for a project that has originated from an external system. | ||
SCHEDULED_FINISH_DATE | DATE | The scheduled finish date of the project. Applicable only for a project that has originated from an external system. | ||
ADW_NOTIFY_FLAG | VARCHAR2 | (1) | The flag that indicates whether this row needs to be sent to the interface table or not. This column is required for Oracle Project Analysis Collection Pack. | |
WF_STATUS_CODE | VARCHAR2 | (30) | Indicates the status of the workflow associated with the project | |
PROJECT_CURRENCY_CODE | VARCHAR2 | (15) | Yes | Currency code of the project |
ALLOW_CROSS_CHARGE_FLAG | VARCHAR2 | (1) | Yes | Flag to indicate whether cross charges are allowed |
PROJECT_RATE_DATE | DATE | Default value for project rate date which can be overridden at task | ||
PROJECT_RATE_TYPE | VARCHAR2 | (30) | Default value for project rate type which can be overridden at task | |
OUTPUT_TAX_CODE | VARCHAR2 | (50) | Indicates whether tax rate defined for the project will be used for customer invoices | |
RETENTION_TAX_CODE | VARCHAR2 | (50) | Indicates whether tax rate defined for the retention will be used for customer invoices | |
CC_PROCESS_LABOR_FLAG | VARCHAR2 | (1) | Yes | Flag that indicates cross charge processing is to be performed for labor transactions charged to the project. Default value for the project template is N. This is defaulted to a project from the project template. This value for the project is a default for the task fixed date. |
LABOR_TP_SCHEDULE_ID | NUMBER | Identifier for transfer price schedule to use for cross charged labor transactions. This is defaulted to a project from the project template. This value for the project is a default for the task fixed date. If cc_process_labor_flag is set to Y, this field is required. | ||
LABOR_TP_FIXED_DATE | DATE | Fixed date to find the effective rate of the bill rate or burden schedule when determining the transfer price for labor transactions. This is defaulted to a project from the project template. This value for the project is a default for the task fixed date. | ||
CC_PROCESS_NL_FLAG | VARCHAR2 | (1) | Yes | Flag that indicates cross charge processing is to be performed for non-labor transactions charged to the project. Default value for the project template is N. This is defaulted to a project from the project template. This value for the project is a default for the task fixed date. |
NL_TP_SCHEDULE_ID | NUMBER | Identifier for transfer price schedule to use for cross charged non-labor transactions. This is defaulted to a project from the project template. This value for the project is a default for the task fixed date. If cc_process_nl_flag is set to Y, this field is required. | ||
NL_TP_FIXED_DATE | DATE | Fixed date to find the effective rate of the bill rate or burden schedule when determining the transfer price for non-labor transactions. This is defaulted to a project from the project template. This value for the project is a default for the task fixed date. | ||
CC_TAX_TASK_ID | NUMBER | Identifier of the task to which intercompany tax items on the intercompany AP invoice are charged. | ||
BILL_JOB_GROUP_ID | NUMBER | (15) | Determines which Job Group will be used for Billing functions for the project | |
BILL_JOB_GROUP_NAME | VARCHAR2 | (30) | Name of Job Group used for Billing functions | |
COST_JOB_GROUP_ID | NUMBER | (15) | Determines which Job Group will be used for Costing functions for the project | |
COST_JOB_GROUP_NAME | VARCHAR2 | (30) | Name of Job Group used for Costing functions | |
ROLE_LIST_ID | NUMBER | (15) | Role_list is a list of allowable roles that are displayed when the key/team members are assigned | |
ROLE_LIST_NAME | VARCHAR2 | (80) | Name of role list | |
WORK_TYPE_ID | NUMBER | (15) | Work types are pre-defined types of work, for example, Vacation, Training, and Administration | |
WORK_TYPE_NAME | VARCHAR2 | (80) | Name of work type | |
CALENDAR_ID | NUMBER | (15) | Define a calendar with calendar exceptions primarily public holidays | |
CALENDAR_NAME | VARCHAR2 | (50) | Name of calendar | |
LOCATION_ID | NUMBER | (15) | Define a project work site location | |
COUNTRY_CODE | VARCHAR2 | (2) | Code of the country used to identify a location | |
COUNTRY_NAME | VARCHAR2 | (80) | Country name | |
REGION | VARCHAR2 | (240) | Region code used to identify a location | |
CITY | VARCHAR2 | (80) | City code used to identify a location | |
PROBABILITY_MEMBER_ID | NUMBER | (15) | project probability represents the probability of a project becoming approved. It is used as a weighted average for reporting | |
PROBABILITY_PERCENTAGE | NUMBER | Project probability percentage represents the probability of a project becoming approved. It is used as a weighted average for reporting | ||
PROJECT_VALUE | NUMBER | Project value is used in reporting. For contract projects, it is the revenue amount. For capital and indirect projects, it is the cost amount. It is not assumed that the cost amount is raw or burdened | ||
EXPECTED_APPROVAL_DATE | DATE | The expected date of project approval. This is used for information purposes only | ||
CC_PRVDR_FLAG | VARCHAR2 | (1) | Cross charge provider flag | |
ADMINISTRATIVE_FLAG | VARCHAR2 | (1) | The Adminstrative type of indirect project type | |
UNASSIGNED_TIME | VARCHAR2 | (1) | This column specifies the desired project type to which all unassigned time of a resource should be designated. | |
INITIAL_TEAM_TEMPLATE_ID | NUMBER | (15) | The Team template which you want to add to this new project. | |
INITIAL_TEAM_TEMPLATE_NAME | VARCHAR2 | (80) | Name of the Team template which you want to add to this new project. | |
RECORD_VERSION_NUMBER | NUMBER | (15) | Stores locking sequence number | |
JOB_BILL_RATE_SCHEDULE_ID | NUMBER | Stores the job based bill rate schedule id | ||
EMP_BILL_RATE_SCHEDULE_ID | NUMBER | Stores the employee based bill rate schedule id | ||
COMPETENCE_MATCH_WT | NUMBER | Weighting value for competence match used to calculate Score | ||
AVAILABILITY_MATCH_WT | NUMBER | Weighting value for availability match used to calculate Score | ||
JOB_LEVEL_MATCH_WT | NUMBER | Weighting value for job level match used to calculate Score | ||
ENABLE_AUTOMATED_SEARCH | VARCHAR2 | (1) | Automated Candidate Nomination is done for the requirements on a project only if the Enable checkbox is selected. | |
SEARCH_MIN_AVAILABILITY | NUMBER | The minimum required availability of a resource to be returned in the search result | ||
SEARCH_ORG_HIER_ID | NUMBER | (15) | Organization Hierarchy for the search | |
SEARCH_STARTING_ORG_ID | NUMBER | (15) | Starting Organization for the search | |
SEARCH_COUNTRY_CODE | VARCHAR2 | (2) | Country for the search | |
MIN_CAND_SCORE_REQD_FOR_NOM | NUMBER | Minimum score required for a resource to be nominated as candidate on a requirement | ||
SEARCH_ORG_HIER_NAME | VARCHAR2 | (30) | Name of Organization Hierarchy for the search | |
SEARCH_STARTING_ORG_NAME | VARCHAR2 | (240) | Name of Starting Organization for the search | |
SEARCH_COUNTRY_NAME | VARCHAR2 | (80) | Name of Country for the search | |
PROJFUNC_CURRENCY_CODE | VARCHAR2 | (15) | Project functional currency. The default value is the value entered for the associated set of books. | |
PRIORITY_CODE | VARCHAR2 | (30) | ||
SPLIT_COST_FROM_WORKPLAN_FLAG | VARCHAR2 | (1) | ||
SPLIT_COST_FROM_BILL_FLAG | VARCHAR2 | (1) | ||
ADV_ACTION_SET_ID | NUMBER | (15) | ||
ADV_ACTION_SET_NAME | VARCHAR2 | (80) | ||
START_ADV_ACTION_SET_FLAG | VARCHAR2 | (1) | ||
TARGET_START_DATE | DATE | The user-specified start date of the project. | ||
TARGET_FINISH_DATE | DATE | The user-specified finish date of the project. | ||
BASELINE_START_DATE | DATE | The baseline start date of the project. | ||
BASELINE_FINISH_DATE | DATE | The baseline finish date of the project. | ||
DERIVED_START_DATE | DATE | The derived start date of the project. | ||
DERIVED_FINISH_DATE | DATE | The derived finish date of the project. | ||
REVALUATE_FUNDING_FLAG | VARCHAR2 | (1) | This column indicates whther the funding has to be revaluated or not. | |
INCLUDE_GAINS_LOSSES_FLAG | VARCHAR2 | (1) | This column indicates whether realized gains and losses shold be included in project revenue or not. | |
SCHEDULED_AS_OF_DATE | DATE | The scheduled as of date of the project. | ||
BASELINE_AS_OF_DATE | DATE | The baseline as of date of the project. | ||
SECURITY_LEVEL | NUMBER | Indicates whether a project is public or private 0 - Indicates project is private 100 - Indicates project is public | ||
LABOR_DISC_REASON_CODE | VARCHAR2 | (30) | Allow user to enter discount reason at project level for Labor | |
NON_LABOR_DISC_REASON_CODE | VARCHAR2 | (30) | Allow user to enter discount reason at project level for Non-Labor | |
ACTUAL_AS_OF_DATE | DATE | The publish date for the actual start and actual dates for the project | ||
SCHEDULED_DURATION | NUMBER | Duration between scheduled start and scheduled finish date using work ca lendar | ||
BASELINE_DURATION | NUMBER | Duration between baseline start and baseline finish date using work cale ndar | ||
ACTUAL_DURATION | NUMBER | Duration between actual start and actual finish date using work calendar | ||
SYS_PROGRAM_FLAG | VARCHAR2 | (1) | ||
ALLOW_MULTI_PROGRAM_ROLLUP | VARCHAR2 | (1) | ||
PROJ_REQ_RES_FORMAT_ID | NUMBER | |||
PROJ_ASGMT_RES_FORMAT_ID | NUMBER | |||
FUNDING_APPROVAL_STATUS_CODE | VARCHAR2 | (30) | Indicates the funding approval status code for project | |
FUNDING_APPROVAL_STATUS_NAME | VARCHAR2 | (80) | Indicates the funding approval status name for project | |
FUNDING_APPROVAL_SYSTEM_CODE | VARCHAR2 | (30) | Indicates the funding approval system status code for project |
Cut, paste (and edit) the following text to query this object:
SELECT PROJECT_ID
, NAME
, LONG_NAME
, SEGMENT1
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, PROJECT_TYPE
, PROJECT_TYPE_CLASS_CODE
, CARRYING_OUT_ORGANIZATION_ID
, CARRYING_OUT_ORGANIZATION_NAME
, PUBLIC_SECTOR_FLAG
, PUBLIC_SECTOR_MEANING
, PROJECT_STATUS_CODE
, PROJECT_STATUS_NAME
, PROJECT_SYSTEM_STATUS_CODE
, DESCRIPTION
, START_DATE
, COMPLETION_DATE
, CLOSED_DATE
, DISTRIBUTION_RULE
, LABOR_INVOICE_FORMAT_ID
, NON_LABOR_INVOICE_FORMAT_ID
, RETENTION_INVOICE_FORMAT_ID
, RETENTION_PERCENTAGE
, BILLING_OFFSET
, BILLING_CYCLE
, BILLING_CYCLE_ID
, LABOR_STD_BILL_RATE_SCHDL
, LABOR_BILL_RATE_ORG_ID
, LABOR_SCHEDULE_FIXED_DATE
, LABOR_SCHEDULE_DISCOUNT
, TEMPLATE_FLAG
, VERIFICATION_DATE
, CREATED_FROM_PROJECT_ID
, CREATED_FROM_PROJECT_NAME
, TEMPLATE_START_DATE_ACTIVE
, NON_LABOR_STD_BILL_RATE_SCHDL
, TEMPLATE_END_DATE_ACTIVE
, NON_LABOR_BILL_RATE_ORG_ID
, NON_LABOR_SCHEDULE_FIXED_DATE
, NON_LABOR_SCHEDULE_DISCOUNT
, LIMIT_TO_TXN_CONTROLS_FLAG
, PROJECT_LEVEL_FUNDING_FLAG
, INVOICE_COMMENT
, UNBILLED_RECEIVABLE_DR
, UNEARNED_REVENUE_CR
, REQUEST_ID
, PROGRAM_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_UPDATE_DATE
, SUMMARY_FLAG
, ENABLED_FLAG
, SEGMENT2
, SEGMENT3
, SEGMENT4
, SEGMENT5
, SEGMENT6
, SEGMENT7
, SEGMENT8
, SEGMENT9
, SEGMENT10
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, COST_IND_RATE_SCH_ID
, REV_IND_RATE_SCH_ID
, INV_IND_RATE_SCH_ID
, COST_IND_SCH_FIXED_DATE
, REV_IND_SCH_FIXED_DATE
, INV_IND_SCH_FIXED_DATE
, LABOR_SCH_TYPE
, NON_LABOR_SCH_TYPE
, OVR_COST_IND_RATE_SCH_ID
, OVR_REV_IND_RATE_SCH_ID
, OVR_INV_IND_RATE_SCH_ID
, ORG_ID
, PM_PRODUCT_CODE
, PM_PROJECT_REFERENCE
, ACTUAL_START_DATE
, ACTUAL_FINISH_DATE
, EARLY_START_DATE
, EARLY_FINISH_DATE
, LATE_START_DATE
, LATE_FINISH_DATE
, SCHEDULED_START_DATE
, SCHEDULED_FINISH_DATE
, ADW_NOTIFY_FLAG
, WF_STATUS_CODE
, PROJECT_CURRENCY_CODE
, ALLOW_CROSS_CHARGE_FLAG
, PROJECT_RATE_DATE
, PROJECT_RATE_TYPE
, OUTPUT_TAX_CODE
, RETENTION_TAX_CODE
, CC_PROCESS_LABOR_FLAG
, LABOR_TP_SCHEDULE_ID
, LABOR_TP_FIXED_DATE
, CC_PROCESS_NL_FLAG
, NL_TP_SCHEDULE_ID
, NL_TP_FIXED_DATE
, CC_TAX_TASK_ID
, BILL_JOB_GROUP_ID
, BILL_JOB_GROUP_NAME
, COST_JOB_GROUP_ID
, COST_JOB_GROUP_NAME
, ROLE_LIST_ID
, ROLE_LIST_NAME
, WORK_TYPE_ID
, WORK_TYPE_NAME
, CALENDAR_ID
, CALENDAR_NAME
, LOCATION_ID
, COUNTRY_CODE
, COUNTRY_NAME
, REGION
, CITY
, PROBABILITY_MEMBER_ID
, PROBABILITY_PERCENTAGE
, PROJECT_VALUE
, EXPECTED_APPROVAL_DATE
, CC_PRVDR_FLAG
, ADMINISTRATIVE_FLAG
, UNASSIGNED_TIME
, INITIAL_TEAM_TEMPLATE_ID
, INITIAL_TEAM_TEMPLATE_NAME
, RECORD_VERSION_NUMBER
, JOB_BILL_RATE_SCHEDULE_ID
, EMP_BILL_RATE_SCHEDULE_ID
, COMPETENCE_MATCH_WT
, AVAILABILITY_MATCH_WT
, JOB_LEVEL_MATCH_WT
, ENABLE_AUTOMATED_SEARCH
, SEARCH_MIN_AVAILABILITY
, SEARCH_ORG_HIER_ID
, SEARCH_STARTING_ORG_ID
, SEARCH_COUNTRY_CODE
, MIN_CAND_SCORE_REQD_FOR_NOM
, SEARCH_ORG_HIER_NAME
, SEARCH_STARTING_ORG_NAME
, SEARCH_COUNTRY_NAME
, PROJFUNC_CURRENCY_CODE
, PRIORITY_CODE
, SPLIT_COST_FROM_WORKPLAN_FLAG
, SPLIT_COST_FROM_BILL_FLAG
, ADV_ACTION_SET_ID
, ADV_ACTION_SET_NAME
, START_ADV_ACTION_SET_FLAG
, TARGET_START_DATE
, TARGET_FINISH_DATE
, BASELINE_START_DATE
, BASELINE_FINISH_DATE
, DERIVED_START_DATE
, DERIVED_FINISH_DATE
, REVALUATE_FUNDING_FLAG
, INCLUDE_GAINS_LOSSES_FLAG
, SCHEDULED_AS_OF_DATE
, BASELINE_AS_OF_DATE
, SECURITY_LEVEL
, LABOR_DISC_REASON_CODE
, NON_LABOR_DISC_REASON_CODE
, ACTUAL_AS_OF_DATE
, SCHEDULED_DURATION
, BASELINE_DURATION
, ACTUAL_DURATION
, SYS_PROGRAM_FLAG
, ALLOW_MULTI_PROGRAM_ROLLUP
, PROJ_REQ_RES_FORMAT_ID
, PROJ_ASGMT_RES_FORMAT_ID
, FUNDING_APPROVAL_STATUS_CODE
, FUNDING_APPROVAL_STATUS_NAME
, FUNDING_APPROVAL_SYSTEM_CODE
FROM APPS.PA_PROJECTS_PRM_V;
|
|
|