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


TABLE: PA.PA_PROJECTS_ALL

Object Details
Object Name: PA_PROJECTS_ALL
Object Type: TABLE
Owner: PA
FND Design Data: TablePA.PA_PROJECTS_ALL
Subobject Name:
Status: VALID


PA_PROJECTS_ALL stores the highest units of work defined
in Oracle Projects at which funding can be
allocated and at which revenue, invoices, unbilled
receivables, and unearned revenue are generated and
maintained. At the project level, users can specify
the methods to be used for revenue accrual and
billing, and the invoice formats to be used for
invoicing.
A project is broken down into one or more tasks.
All projects can be funded by one or more agreements.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PA_PROJECTS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnPROJECT_ID
ColumnSEGMENT1
PA_PROJECTS_U2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnSEGMENT1
PA_PROJECTS_U3 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnNAME
PA_PROJECTS_U4 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnPM_PROJECT_REFERENCE
ColumnPM_PRODUCT_CODE
PA_PROJECTS_U5 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnLONG_NAME
PA_PROJECTS_F1 FUNCTION-BASED NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnUPPER("SEGMENT1"||' - '||"NAME")
PA_PROJECTS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnLABOR_BILL_RATE_ORG_ID
ColumnLABOR_STD_BILL_RATE_SCHDL
PA_PROJECTS_N10 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnNON_LAB_STD_BILL_RT_SCH_ID
PA_PROJECTS_N11 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPROJECT_TYPE
PA_PROJECTS_N12 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPROJECT_ID
ColumnPJT_ROLLUP_ENABLED_FLAG
PA_PROJECTS_N13 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPJT_ROLLUP_ENABLED_FLAG
PA_PROJECTS_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCARRYING_OUT_ORGANIZATION_ID
ColumnPROJECT_STATUS_CODE
ColumnCOMPLETION_DATE
ColumnSTART_DATE
PA_PROJECTS_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnNON_LABOR_BILL_RATE_ORG_ID
ColumnNON_LABOR_STD_BILL_RATE_SCHDL
PA_PROJECTS_N4 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPROJECT_STATUS_CODE
PA_PROJECTS_N5 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnADW_NOTIFY_FLAG
PA_PROJECTS_N6 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnTEMPLATE_FLAG
PA_PROJECTS_N7 FUNCTION-BASED NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnUPPER("NAME")
PA_PROJECTS_N8 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnJOB_BILL_RATE_SCHEDULE_ID
PA_PROJECTS_N9 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnEMP_BILL_RATE_SCHEDULE_ID
Columns
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
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
CARRYING_OUT_ORGANIZATION_ID NUMBER (15) Yes The identifier of the organization that is responsible for the project work
PUBLIC_SECTOR_FLAG VARCHAR2 (1) Yes Flag that indicates whether the project is in the public sector or the private sector
PROJECT_STATUS_CODE VARCHAR2 (30) Yes The status of the project.
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 project's 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 project's 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
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
NON_LABOR_STD_BILL_RATE_SCHDL VARCHAR2 (30)
The non-labor standard bill rate schedule that defaults to new tasks created for the project
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 at 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 context 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
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 template corresponding to the source project. This value would be null for templates
TEMPLATE_START_DATE_ACTIVE DATE

The Effective start date of the Template
TEMPLATE_END_DATE_ACTIVE DATE

Last effective date of the template
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 identifier 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.
BILLING_CYCLE_ID NUMBER (15)
The identifier of the billing cycle which applies to the project
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
OUTPUT_TAX_CODE VARCHAR2 (50)
Indicates whether tax rate defined for Projects will be used for Customer Invoices
RETENTION_TAX_CODE VARCHAR2 (50)
Indicates whether tax rate defined for retention will be used for Customer Invoices
PROJECT_CURRENCY_CODE VARCHAR2 (15) Yes Currency code of the project
ALLOW_CROSS_CHARGE_FLAG VARCHAR2 (1) Yes Flag to indicate whether cross charge 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
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. It 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 n on-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 isa 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 functionality.
COST_JOB_GROUP_ID NUMBER (15)
Determines which Job Group will be used for Costing functionality.
ROLE_LIST_ID NUMBER (15)
Role_List is a list of allowable roles that are displayed when the Key/Team members are assigned.
WORK_TYPE_ID NUMBER (15)
Work_Types are predefined types of work, for example, Vacation, Training, and Administration.
CALENDAR_ID NUMBER (15)
Define a calendar with calendar exceptions primarily public holidays.
LOCATION_ID NUMBER (15)
Define a Project work site location.
PROBABILITY_MEMBER_ID NUMBER (15)
Project probability represents the probability of a project becoming approved. It is used as a weighting average for reporting.
PROJECT_VALUE NUMBER

The OPPORTUNITY_VALUE converted to the project functional currency.
EXPECTED_APPROVAL_DATE DATE

The expected date of the project approval. This is used for information purposes only.
RECORD_VERSION_NUMBER NUMBER (15)
Storing Locking sequence number.
INITIAL_TEAM_TEMPLATE_ID NUMBER (15)
The Team template which you want to add to his new project.
JOB_BILL_RATE_SCHEDULE_ID NUMBER

Stores the Job based Bill Rate Schedule ID for the project
EMP_BILL_RATE_SCHEDULE_ID NUMBER

Stores the Employee based Bill Rate Schedule ID for the project
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
NON_LAB_STD_BILL_RT_SCH_ID NUMBER (15)
Non labor standard bill rate schedule ID.
INVPROC_CURRENCY_TYPE VARCHAR2 (30)
Invoice processing currency code
REVPROC_CURRENCY_CODE VARCHAR2 (15)
Revenue processing currency code. Project functional currency. Currently the project functional currency is the same as the revenue processing currency.
PROJECT_BIL_RATE_DATE_CODE VARCHAR2 (30)
Exchange rate date type for determining the date to use for conversion betweenfrom bill transaction currency/ funding currency to to project currency for customer billing.
PROJECT_BIL_RATE_TYPE VARCHAR2 (30)
Exchange rate type to use for conversion from bill transaction currency/ funding currency to project currency for customer billing.
PROJECT_BIL_RATE_DATE DATE

Exchange rate date to use for conversion from bill transaction currency/ funding currency to project currency if Fixed Date rate date type is used for customer billing.
PROJECT_BIL_EXCHANGE_RATE NUMBER

Exchange rate to use for conversion from bill transaction currency/ funding currency to project currency if User exchange rate type is used.
PROJFUNC_CURRENCY_CODE VARCHAR2 (15)
Project functional currency. The default value is the value entered for the associated ledger.
PROJFUNC_BIL_RATE_DATE_CODE VARCHAR2 (30)
Exchange rate date type for determining the date to use for conversion from bill transaction currency/ funding currency to project functional currency for customer billing.
PROJFUNC_BIL_RATE_TYPE VARCHAR2 (30)
Exchange rate type to use for conversion from bill transaction currency/ funding currency to project functional currency for customer billing.
PROJFUNC_BIL_RATE_DATE DATE

Exchange rate date to use for conversion from bill transaction currency/funding currency to project functional currency if Fixed Date rate date type is used for customer billing.
PROJFUNC_BIL_EXCHANGE_RATE NUMBER

Exchange rate to use for conversion from bill transaction currency/ funding currency to project functional if User exchange rate type is used.
FUNDING_RATE_DATE_CODE VARCHAR2 (30)
Exchange rate date type for determining the date to use for conversion from bill transaction currency to funding currency for customer billing.
FUNDING_RATE_TYPE VARCHAR2 (30)
Exchange rate type to use for conversion from bill transaction currency to funding currency for customer billing.
FUNDING_RATE_DATE DATE

Exchange rate date to use for conversion from bill transaction currency to funding currency if Fixed Date rate date type is used for customer billing.
FUNDING_EXCHANGE_RATE NUMBER

Exchange rate to use for conversion from bill transaction currency to project or functional currency if User exchange rate type is used.
BASELINE_FUNDING_FLAG VARCHAR2 (1)
Flag indicating whether the funding can be baselined without revenue budget.
PROJFUNC_COST_RATE_TYPE VARCHAR2 (30)
Default value for the project functional cost rate
PROJFUNC_COST_RATE_DATE DATE

Default value for the project functional cost rate date.
INV_BY_BILL_TRANS_CURR_FLAG VARCHAR2 (1)
Flag indicating if invoicing is by bill transaction currency for this project.
MULTI_CURRENCY_BILLING_FLAG VARCHAR2 (1)
Flag indicating if multi-currency billing is allowed for this project
SPLIT_COST_FROM_WORKPLAN_FLAG VARCHAR2 (1)
Not Used
SPLIT_COST_FROM_BILL_FLAG VARCHAR2 (1)
Not Used
ASSIGN_PRECEDES_TASK VARCHAR2 (1)
Flag to determine if assignment level attributes override task level attributes.
PRIORITY_CODE VARCHAR2 (30)
Indicates priority of the project.
RETN_BILLING_INV_FORMAT_ID NUMBER (15)
The identifier of Retention Billing Invoice Format.
RETN_ACCOUNTING_FLAG VARCHAR2 (1)
Indicates the retention accounting is enabled for the project
ADV_ACTION_SET_ID NUMBER (15)
Indicates the default advertisement action set of the project or the project template.
START_ADV_ACTION_SET_FLAG VARCHAR2 (1)
Specify whether the advertisement action set will be started immediately after a requirement is created.
REVALUATE_FUNDING_FLAG VARCHAR2 (1)
This column indicates whether the funding has to be revaluated or not. Valid values are Y or N
INCLUDE_GAINS_LOSSES_FLAG VARCHAR2 (1)
This column indicates whether gains and losses to be included in project revenue or not. Valid values are Y or N
TARGET_START_DATE DATE

The Target Start Date for the project.
TARGET_FINISH_DATE DATE

The Target Finish Date for the project.
BASELINE_START_DATE DATE

The baseline start date of the project.
BASELINE_FINISH_DATE DATE

The baseline finish date of the project.
SCHEDULED_AS_OF_DATE DATE

The publish date for the Scheduled Start and Finish dates for the project.
BASELINE_AS_OF_DATE DATE

The baseline date for the Baseline Start and Finish Dates for the project.
LABOR_DISC_REASON_CODE VARCHAR2 (30)
Reason code for labor discount
NON_LABOR_DISC_REASON_CODE VARCHAR2 (30)
Reason code for non labor discount
SECURITY_LEVEL NUMBER

Indicates whether a project is public or private:0 - Indicates project is private100 - Indicates project is public
ACTUAL_AS_OF_DATE DATE

The publish date for the project Actual Start and Actual Finish Dates.
SCHEDULED_DURATION NUMBER

Duration between the Scheduled Start and Finish Dates using the project work calendar.
BASELINE_DURATION NUMBER

Duration between the Baseline Start and Finish Dates using the project work calendar.
ACTUAL_DURATION NUMBER

Duration between the Actual Start and Finish Dates using the project work calendar.
LONG_NAME VARCHAR2 (240)
Project Long Name
BTC_COST_BASE_REV_CODE VARCHAR2 (90)
Bill transaction currency for cost based revenue
ASSET_ALLOCATION_METHOD VARCHAR2 (30)
Identifies the method used to allocate indirect and common costs across the assets assigned to a grouping level.
CAPITAL_EVENT_PROCESSING VARCHAR2 (30)
Capital Event Processing method. Used to determine when cost and assets are grouped for capitalization or retirement adjustment processing.
CINT_RATE_SCH_ID NUMBER (15)
Capital Interest Rate Schedule identifier.
CINT_ELIGIBLE_FLAG VARCHAR2 (1)
Flag used to determine whether the project is eligible for capitalized interest.
CINT_STOP_DATE DATE

Stop date for capital interest calculation.
SYS_PROGRAM_FLAG VARCHAR2 (1)
Flag to determine whether the project is a program or not.
STRUCTURE_SHARING_CODE VARCHAR2 (30)
Indicates how the financial and workplan structures are split or shared.
ENABLE_TOP_TASK_CUSTOMER_FLAG VARCHAR2 (1)
Indicates whether Customer at top task is enabled for Project or Not.
ENABLE_TOP_TASK_INV_MTH_FLAG VARCHAR2 (1)
Indicates whether Invoice Method at Top Task is enabled or not.
REVENUE_ACCRUAL_METHOD VARCHAR2 (30)
Indicates the Revenue Method for Project.
INVOICE_METHOD VARCHAR2 (30)
Indicates the Invoice Method for Project.
PROJFUNC_ATTR_FOR_AR_FLAG VARCHAR2 (1)
Use Project Functional Currency Conversion Attributes for Receivables Functional Currency.
PJI_SOURCE_FLAG VARCHAR2 (1)
Flag to determine whether project was implemented in old PSI model or new Project Performance model.
ALLOW_MULTI_PROGRAM_ROLLUP VARCHAR2 (1)
Option to allow user to rollup to multiple programs
PROJ_REQ_RES_FORMAT_ID NUMBER

Indicates the planning resource format for project requirement creation
PROJ_ASGMT_RES_FORMAT_ID NUMBER

Indicates the planning resource format for project assignment creation
FUNDING_APPROVAL_STATUS_CODE VARCHAR2 (30)
Funding Status Approval Code
REVTRANS_CURRENCY_TYPE VARCHAR2 (30)
Revenue Transaction Currency Type
DATE_EFF_FUNDS_CONSUMPTION VARCHAR2 (1)
Date effective funds consumption flag.
AR_REC_NOTIFY_FLAG VARCHAR2 (1) Yes Flag to decide if the PM should be notified when a receipt is applied.
AUTO_RELEASE_PWP_INV VARCHAR2 (1) Yes Flag to decide if the Pay When Paid hold on linked supplier invoices must be automatically released by the concurrent program.
BILL_LABOR_ACCRUAL VARCHAR2 (1)
Bill labor accrual
ADJ_ON_STD_INV VARCHAR2 (2)
Adjustments included on standard Invoice
CBS_VERSION_ID NUMBER (15)
CBS_ENABLE_FLAG VARCHAR2 (1)
PJT_ROLLUP_ENABLED_FLAG VARCHAR2 (1)
OLAP_GROUP NUMBER

OLAP_TASK_ID NUMBER

Query Text

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


SELECT PROJECT_ID
,      NAME
,      SEGMENT1
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      PROJECT_TYPE
,      CARRYING_OUT_ORGANIZATION_ID
,      PUBLIC_SECTOR_FLAG
,      PROJECT_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
,      LABOR_STD_BILL_RATE_SCHDL
,      LABOR_BILL_RATE_ORG_ID
,      LABOR_SCHEDULE_FIXED_DATE
,      LABOR_SCHEDULE_DISCOUNT
,      NON_LABOR_STD_BILL_RATE_SCHDL
,      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
,      TEMPLATE_FLAG
,      VERIFICATION_DATE
,      CREATED_FROM_PROJECT_ID
,      TEMPLATE_START_DATE_ACTIVE
,      TEMPLATE_END_DATE_ACTIVE
,      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
,      BILLING_CYCLE_ID
,      ADW_NOTIFY_FLAG
,      WF_STATUS_CODE
,      OUTPUT_TAX_CODE
,      RETENTION_TAX_CODE
,      PROJECT_CURRENCY_CODE
,      ALLOW_CROSS_CHARGE_FLAG
,      PROJECT_RATE_DATE
,      PROJECT_RATE_TYPE
,      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
,      COST_JOB_GROUP_ID
,      ROLE_LIST_ID
,      WORK_TYPE_ID
,      CALENDAR_ID
,      LOCATION_ID
,      PROBABILITY_MEMBER_ID
,      PROJECT_VALUE
,      EXPECTED_APPROVAL_DATE
,      RECORD_VERSION_NUMBER
,      INITIAL_TEAM_TEMPLATE_ID
,      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
,      NON_LAB_STD_BILL_RT_SCH_ID
,      INVPROC_CURRENCY_TYPE
,      REVPROC_CURRENCY_CODE
,      PROJECT_BIL_RATE_DATE_CODE
,      PROJECT_BIL_RATE_TYPE
,      PROJECT_BIL_RATE_DATE
,      PROJECT_BIL_EXCHANGE_RATE
,      PROJFUNC_CURRENCY_CODE
,      PROJFUNC_BIL_RATE_DATE_CODE
,      PROJFUNC_BIL_RATE_TYPE
,      PROJFUNC_BIL_RATE_DATE
,      PROJFUNC_BIL_EXCHANGE_RATE
,      FUNDING_RATE_DATE_CODE
,      FUNDING_RATE_TYPE
,      FUNDING_RATE_DATE
,      FUNDING_EXCHANGE_RATE
,      BASELINE_FUNDING_FLAG
,      PROJFUNC_COST_RATE_TYPE
,      PROJFUNC_COST_RATE_DATE
,      INV_BY_BILL_TRANS_CURR_FLAG
,      MULTI_CURRENCY_BILLING_FLAG
,      SPLIT_COST_FROM_WORKPLAN_FLAG
,      SPLIT_COST_FROM_BILL_FLAG
,      ASSIGN_PRECEDES_TASK
,      PRIORITY_CODE
,      RETN_BILLING_INV_FORMAT_ID
,      RETN_ACCOUNTING_FLAG
,      ADV_ACTION_SET_ID
,      START_ADV_ACTION_SET_FLAG
,      REVALUATE_FUNDING_FLAG
,      INCLUDE_GAINS_LOSSES_FLAG
,      TARGET_START_DATE
,      TARGET_FINISH_DATE
,      BASELINE_START_DATE
,      BASELINE_FINISH_DATE
,      SCHEDULED_AS_OF_DATE
,      BASELINE_AS_OF_DATE
,      LABOR_DISC_REASON_CODE
,      NON_LABOR_DISC_REASON_CODE
,      SECURITY_LEVEL
,      ACTUAL_AS_OF_DATE
,      SCHEDULED_DURATION
,      BASELINE_DURATION
,      ACTUAL_DURATION
,      LONG_NAME
,      BTC_COST_BASE_REV_CODE
,      ASSET_ALLOCATION_METHOD
,      CAPITAL_EVENT_PROCESSING
,      CINT_RATE_SCH_ID
,      CINT_ELIGIBLE_FLAG
,      CINT_STOP_DATE
,      SYS_PROGRAM_FLAG
,      STRUCTURE_SHARING_CODE
,      ENABLE_TOP_TASK_CUSTOMER_FLAG
,      ENABLE_TOP_TASK_INV_MTH_FLAG
,      REVENUE_ACCRUAL_METHOD
,      INVOICE_METHOD
,      PROJFUNC_ATTR_FOR_AR_FLAG
,      PJI_SOURCE_FLAG
,      ALLOW_MULTI_PROGRAM_ROLLUP
,      PROJ_REQ_RES_FORMAT_ID
,      PROJ_ASGMT_RES_FORMAT_ID
,      FUNDING_APPROVAL_STATUS_CODE
,      REVTRANS_CURRENCY_TYPE
,      DATE_EFF_FUNDS_CONSUMPTION
,      AR_REC_NOTIFY_FLAG
,      AUTO_RELEASE_PWP_INV
,      BILL_LABOR_ACCRUAL
,      ADJ_ON_STD_INV
,      CBS_VERSION_ID
,      CBS_ENABLE_FLAG
,      PJT_ROLLUP_ENABLED_FLAG
,      OLAP_GROUP
,      OLAP_TASK_ID
FROM PA.PA_PROJECTS_ALL;

Dependencies

[top of page]

PA.PA_PROJECTS_ALL does not reference any database object

PA.PA_PROJECTS_ALL is referenced by following:

SchemaPA
ViewPA_PROJECTS_ALL#