[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | PA_PROJECT_TYPES_ALL |
|---|---|
| Object Type: | TABLE |
| Owner: | PA |
| FND Design Data: |  PA.PA_PROJECT_TYPES_ALL
|
| Subobject Name: | |
| Status: | VALID |
PA_PROJECT_TYPES_ALL stores implementation-defined
classifications of projects that specify whether a
project burdens labor costs and whether the project is
contract, capital or indirect (based on PROJECT_TYPE_CLASS_CODE).
.
Project types are also used during project entry to specify default
information such as invoice formats, standard bill rate
schedules, and task service types.
.
.
| Tablespace: |  APPS_TS_SEED |
|---|---|
| PCT Free: | 3 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| PA_PROJECT_TYPES_U1 | NORMAL | UNIQUE |
APPS_TS_SEED
|
 PROJECT_TYPE
ORG_ID
|
| PA_PROJECT_TYPES_U2 | NORMAL | UNIQUE |
APPS_TS_SEED
|
PROJECT_TYPE_ID
|
| PA_PROJECT_TYPES_N1 | NORMAL | NONUNIQUE |
APPS_TS_SEED
|
ADW_NOTIFY_FLAG
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| PROJECT_TYPE | VARCHAR2 | (20) | Yes | Implementation-defined name that uniquely identifies the project type |
| 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 |
| DIRECT_FLAG | VARCHAR2 | (1) | Yes | Flag that indicates whether projects of this project type can accrue revenue and generate invoices. For contract project types this is set to Y. For others, this is set to N. |
| SERVICE_TYPE_CODE | VARCHAR2 | (30) | Yes | The service type that defaults the task service type of projects with this project type |
| BURDEN_COST_FLAG | VARCHAR2 | (1) | Yes | Flag that indicates whether costs are burdened for projects of this project type |
| START_DATE_ACTIVE | DATE | Yes | First effective date of the project type | |
| LABOR_INVOICE_FORMAT_ID | NUMBER | (15) | The identifier of the labor invoice format that defaults to contract projects with this project type | |
| NON_LABOR_INVOICE_FORMAT_ID | NUMBER | (15) | The identifier of the non-labor invoice format that defaults to contract projects with this project type | |
| LABOR_BILL_RATE_ORG_ID | NUMBER | (15) | The identifier of the organization that owns the labor standard bill rate schedule | |
| LABOR_STD_BILL_RATE_SCHDL | VARCHAR2 | (20) | The labor standard bill rate schedule that defaults to contract projects with this project type | |
| NON_LABOR_BILL_RATE_ORG_ID | NUMBER | (15) | The identifier of the organization that owns the non-labor standard bill rate schedule | |
| NON_LABOR_STD_BILL_RATE_SCHDL | VARCHAR2 | (30) | The non-labor standard bill rate schedule that defaults to contract projects with this project type | |
| END_DATE_ACTIVE | DATE | Last effective date of the project type | ||
| DESCRIPTION | VARCHAR2 | (250) | Description of the project type | |
| 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 | |
| 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 | |
| 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_SCH_OVERRIDE_FLAG | VARCHAR2 | (1) | Indicates if users can override the standard costing burden schedule that is defaulted from project type | |
| REV_BUDGET_ENTRY_METHOD_CODE | VARCHAR2 | (30) | Default entry method used for revenue budgets | |
| REV_BUDGET_RESOURCE_LIST_ID | NUMBER | Default resource list used for revenue budgets | ||
| ALLOW_REV_BUDGET_ENTRY_FLAG | VARCHAR2 | (1) | Indicates whether to allow entry of revenue budgets | |
| COST_BUDGET_ENTRY_METHOD_CODE | VARCHAR2 | (30) | Default entry method used for cost budgets | |
| COST_BUDGET_RESOURCE_LIST_ID | NUMBER | Default resource list used for cost budgets | ||
| ALLOW_COST_BUDGET_ENTRY_FLAG | VARCHAR2 | (1) | Indicates whether to allow entry of cost budgets | |
| DEFAULT_RESOURCE_LIST_ID | NUMBER | Yes | Default resource list for project summarization | |
| ALLOWABLE_FUNDING_LEVEL_CODE | VARCHAR2 | (30) | Option to control level of funding based on project type. Used in Enter Agreements and Funding | |
| PROJECT_TYPE_CLASS_CODE | VARCHAR2 | (30) | Indicates the class of project type | |
| INTERFACE_COMPLETE_ASSET_FLAG | VARCHAR2 | (1) | Specifies whether to interface asset lines even if the asset definition is not complete | |
| CIP_GROUPING_METHOD_CODE | VARCHAR2 | (30) | Specifies how to group costs for a capital project | |
| CAPITAL_COST_TYPE_CODE | VARCHAR2 | (1) | Specifies whether to capitalize raw or burdened costs for a capital project | |
| INTERFACE_ASSET_COST_CODE | VARCHAR2 | (1) | Specifies whether to interface capital costs to GL or FA. Currently always set to FA. | |
| ORG_ID | NUMBER | (15) | Operating unit identifier for multi-organization installations | |
| BURDEN_AMT_DISPLAY_METHOD | VARCHAR2 | (1) | Flag indicates to display Burden amount on same transaction or display it as a separate transaction | |
| BURDEN_ACCOUNT_FLAG | VARCHAR2 | (1) | Flag indicates whether to account burden amount on separate project and task | |
| BURDEN_SUM_DEST_PROJECT_ID | NUMBER | (15) | Task Id for storing burden amount, if displayed on separate task | |
| BURDEN_SUM_DEST_TASK_ID | NUMBER | (15) | If burden_account_flag=Y,Task_id, for creating summarized burden items on separate project/task | |
| ENABLE_BUDGET_WF_FLAG | VARCHAR2 | (1) | This column indicates if a budget approval workflow can be enabled for this project type. | |
| ENABLE_PROJECT_WF_FLAG | VARCHAR2 | (1) | This column indicates if a budget approval workflow can be enabled for this project type. | |
| BILLING_OFFSET | NUMBER | (15) | The default number of days after the project start date when the first invoice is created for the project. | |
| BILLING_CYCLE_ID | NUMBER | (15) | The default identifier of the billing cycle applicable to the projects. | |
| 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. | |
| DEF_START_PROJ_STATUS_CODE | VARCHAR2 | (30) | Yes | Indicates the default starting project status for this project type |
| VENDOR_INVOICE_GROUPING_CODE | VARCHAR2 | (1) | Yes | Flag that indicates group/ungroup supplier invoices and interface supplier invoices as NEW or MERGED mass additions |
| OVERRIDE_ASSET_ASSIGNMENT_FLAG | VARCHAR2 | (1) | Yes | Flag that indicates if the customer wants to override the asset assignment through the use of client extension |
| CC_PRVDR_FLAG | VARCHAR2 | (1) | Flag that indicates that the project type (of project type class of CONTRACT) is defined for provider projects that bill intercompany invoices. For such project types, this flag is set to Y. For all others, it is set to N. | |
| 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. | |
| ADMINISTRATIVE_FLAG | VARCHAR2 | (1) | This column indicates the Administrative type of projects. | |
| ROLE_LIST_ID | NUMBER | (15) | The identifier of the role list | |
| WORK_TYPE_ID | NUMBER | (15) | The identifier of the work type | |
| PROBABILITY_LIST_ID | NUMBER | (15) | The identifier of the probability list | |
| UNASSIGNED_TIME | VARCHAR2 | (1) | This column specifies the desired project type to which all unassigned time of a resource should be designated. | |
| JOB_BILL_RATE_SCHEDULE_ID | NUMBER | Stores the Job based Cost Rate Schedule ID for the project type | ||
| EMP_BILL_RATE_SCHEDULE_ID | NUMBER | Stores the Employee based Cost Rate Schedule ID for the project type | ||
| BUDGETARY_OVERRIDE_FLAG | VARCHAR2 | (1) | This column indicates whether budgetary options at project level can be overridden or not. | |
| NON_LAB_STD_BILL_RT_SCH_ID | NUMBER | (15) | Non labor standard bill rate schedule ID. | |
| BASELINE_FUNDING_FLAG | VARCHAR2 | (1) | Baseline funding without budget | |
| PROJECT_TYPE_ID | NUMBER | (15) | Yes | The identifier that uniquely defines the project type |
| ORG_PROJECT_FLAG | VARCHAR2 | (1) | The identifier of organization project. | |
| 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 | |
| RLZD_GAINS_EVENT_TYPE_ID | NUMBER | (15) | The event type that classifies the event for realized gains events | |
| RLZD_LOSSES_EVENT_TYPE_ID | NUMBER | (15) | The event type that classifies the event for realized losses events | |
| TOTAL_BURDEN_FLAG | VARCHAR2 | (1) | Flag that indicates whether C and D lines are to be created for projects of this project type | |
| 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_SCH_OVERRIDE_FLAG | VARCHAR2 | (1) | Flag to indicate whether the interest rate schedule defined for the project type can be overridden at the Project level. | |
| SPONSORED_FLAG | VARCHAR2 | (1) | Sponsored Flag | |
| DATE_EFF_FUNDS_CONSUMPTION | VARCHAR2 | (1) | Date effective funds consumption flag | |
| CWK_CLEARING_FLAG | VARCHAR2 | (1) | Contingent Worker Clearing 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. |
Cut, paste (and edit) the following text to query this object:
SELECT PROJECT_TYPE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, DIRECT_FLAG
, SERVICE_TYPE_CODE
, BURDEN_COST_FLAG
, START_DATE_ACTIVE
, LABOR_INVOICE_FORMAT_ID
, NON_LABOR_INVOICE_FORMAT_ID
, LABOR_BILL_RATE_ORG_ID
, LABOR_STD_BILL_RATE_SCHDL
, NON_LABOR_BILL_RATE_ORG_ID
, NON_LABOR_STD_BILL_RATE_SCHDL
, END_DATE_ACTIVE
, DESCRIPTION
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, LABOR_SCH_TYPE
, NON_LABOR_SCH_TYPE
, COST_IND_RATE_SCH_ID
, REV_IND_RATE_SCH_ID
, INV_IND_RATE_SCH_ID
, COST_SCH_OVERRIDE_FLAG
, REV_BUDGET_ENTRY_METHOD_CODE
, REV_BUDGET_RESOURCE_LIST_ID
, ALLOW_REV_BUDGET_ENTRY_FLAG
, COST_BUDGET_ENTRY_METHOD_CODE
, COST_BUDGET_RESOURCE_LIST_ID
, ALLOW_COST_BUDGET_ENTRY_FLAG
, DEFAULT_RESOURCE_LIST_ID
, ALLOWABLE_FUNDING_LEVEL_CODE
, PROJECT_TYPE_CLASS_CODE
, INTERFACE_COMPLETE_ASSET_FLAG
, CIP_GROUPING_METHOD_CODE
, CAPITAL_COST_TYPE_CODE
, INTERFACE_ASSET_COST_CODE
, ORG_ID
, BURDEN_AMT_DISPLAY_METHOD
, BURDEN_ACCOUNT_FLAG
, BURDEN_SUM_DEST_PROJECT_ID
, BURDEN_SUM_DEST_TASK_ID
, ENABLE_BUDGET_WF_FLAG
, ENABLE_PROJECT_WF_FLAG
, BILLING_OFFSET
, BILLING_CYCLE_ID
, ADW_NOTIFY_FLAG
, DEF_START_PROJ_STATUS_CODE
, VENDOR_INVOICE_GROUPING_CODE
, OVERRIDE_ASSET_ASSIGNMENT_FLAG
, CC_PRVDR_FLAG
, BILL_JOB_GROUP_ID
, COST_JOB_GROUP_ID
, ADMINISTRATIVE_FLAG
, ROLE_LIST_ID
, WORK_TYPE_ID
, PROBABILITY_LIST_ID
, UNASSIGNED_TIME
, JOB_BILL_RATE_SCHEDULE_ID
, EMP_BILL_RATE_SCHEDULE_ID
, BUDGETARY_OVERRIDE_FLAG
, NON_LAB_STD_BILL_RT_SCH_ID
, BASELINE_FUNDING_FLAG
, PROJECT_TYPE_ID
, ORG_PROJECT_FLAG
, REVALUATE_FUNDING_FLAG
, INCLUDE_GAINS_LOSSES_FLAG
, RLZD_GAINS_EVENT_TYPE_ID
, RLZD_LOSSES_EVENT_TYPE_ID
, TOTAL_BURDEN_FLAG
, ASSET_ALLOCATION_METHOD
, CAPITAL_EVENT_PROCESSING
, CINT_RATE_SCH_ID
, CINT_SCH_OVERRIDE_FLAG
, SPONSORED_FLAG
, DATE_EFF_FUNDS_CONSUMPTION
, CWK_CLEARING_FLAG
, AR_REC_NOTIFY_FLAG
, AUTO_RELEASE_PWP_INV
FROM PA.PA_PROJECT_TYPES_ALL;
PA.PA_PROJECT_TYPES_ALL does not reference any database object
PA.PA_PROJECT_TYPES_ALL is referenced by following:
PA
PA_PROJECT_TYPES_ALL#
|
|
|
|