[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 |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
| 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 | |
| LAST_UPDATE_DATE | DATE | Yes | ||
| LAST_UPDATED_BY | NUMBER | (15) | Yes | |
| CREATION_DATE | DATE | Yes | ||
| CREATED_BY | NUMBER | (15) | Yes | |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Yes | |
| DIRECT_FLAG | VARCHAR2 | (1) | Yes | |
| SERVICE_TYPE_CODE | VARCHAR2 | (30) | Yes | |
| BURDEN_COST_FLAG | VARCHAR2 | (1) | Yes | |
| START_DATE_ACTIVE | DATE | Yes | ||
| LABOR_INVOICE_FORMAT_ID | NUMBER | (15) | ||
| NON_LABOR_INVOICE_FORMAT_ID | NUMBER | (15) | ||
| LABOR_BILL_RATE_ORG_ID | NUMBER | (15) | ||
| LABOR_STD_BILL_RATE_SCHDL | VARCHAR2 | (20) | ||
| NON_LABOR_BILL_RATE_ORG_ID | NUMBER | (15) | ||
| NON_LABOR_STD_BILL_RATE_SCHDL | VARCHAR2 | (30) | ||
| END_DATE_ACTIVE | DATE | |||
| DESCRIPTION | VARCHAR2 | (250) | ||
| 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) | ||
| LABOR_SCH_TYPE | VARCHAR2 | (1) | ||
| NON_LABOR_SCH_TYPE | VARCHAR2 | (1) | ||
| COST_IND_RATE_SCH_ID | NUMBER | (15) | ||
| REV_IND_RATE_SCH_ID | NUMBER | (15) | ||
| INV_IND_RATE_SCH_ID | NUMBER | (15) | ||
| COST_SCH_OVERRIDE_FLAG | VARCHAR2 | (1) | ||
| REV_BUDGET_ENTRY_METHOD_CODE | VARCHAR2 | (30) | ||
| REV_BUDGET_RESOURCE_LIST_ID | NUMBER | |||
| ALLOW_REV_BUDGET_ENTRY_FLAG | VARCHAR2 | (1) | ||
| COST_BUDGET_ENTRY_METHOD_CODE | VARCHAR2 | (30) | ||
| COST_BUDGET_RESOURCE_LIST_ID | NUMBER | |||
| ALLOW_COST_BUDGET_ENTRY_FLAG | VARCHAR2 | (1) | ||
| DEFAULT_RESOURCE_LIST_ID | NUMBER | Yes | ||
| ALLOWABLE_FUNDING_LEVEL_CODE | VARCHAR2 | (30) | ||
| PROJECT_TYPE_CLASS_CODE | VARCHAR2 | (30) | ||
| INTERFACE_COMPLETE_ASSET_FLAG | VARCHAR2 | (1) | ||
| CIP_GROUPING_METHOD_CODE | VARCHAR2 | (30) | ||
| CAPITAL_COST_TYPE_CODE | VARCHAR2 | (1) | ||
| INTERFACE_ASSET_COST_CODE | VARCHAR2 | (1) | ||
| ORG_ID | NUMBER | (15) | ||
| BURDEN_AMT_DISPLAY_METHOD | VARCHAR2 | (1) | This column indicates whether to display burdened_amount on same transaction or as a separate transaction | |
| BURDEN_ACCOUNT_FLAG | VARCHAR2 | (1) | This column indicates if burden amount is accounted on separate project and task | |
| BURDEN_SUM_DEST_PROJECT_ID | NUMBER | (15) | This column indicates destination project_id if burden amount is accounted on separate project and task | |
| BURDEN_SUM_DEST_TASK_ID | NUMBER | (15) | This column indicates destination task_id if burden amount is accounted on separate project and 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 project approval workflow can be enabled for this project type. | |
| BILLING_OFFSET | NUMBER | (15) | ||
| BILLING_CYCLE_ID | NUMBER | (15) | ||
| ADW_NOTIFY_FLAG | VARCHAR2 | (1) | ||
| DEF_START_PROJ_STATUS_CODE | VARCHAR2 | (30) | Yes | |
| VENDOR_INVOICE_GROUPING_CODE | VARCHAR2 | (1) | Yes | This column indicates group/ungroup supplier invoices and interface them as NEW or MERGED mass additions |
| OVERRIDE_ASSET_ASSIGNMENT_FLAG | VARCHAR2 | (1) | Yes | This column indicates if the customer wants to override the asset assignment through client extension before asset lines generation |
| CC_PRVDR_FLAG | VARCHAR2 | (1) | ||
| BILL_JOB_GROUP_ID | NUMBER | (15) | Determines which Job Group will be used for Billing functions for the project | |
| COST_JOB_GROUP_ID | NUMBER | (15) | Determines which Job Group will be used for Costing functions for the project | |
| ADMINISTRATIVE_FLAG | VARCHAR2 | (1) | This column indicates the Administrative type of projects | |
| ROLE_LIST_ID | NUMBER | (15) | This column is the identifier for the role list | |
| WORK_TYPE_ID | NUMBER | (15) | This column is the identifier for the work type | |
| PROBABILITY_LIST_ID | NUMBER | (15) | This column is the identifier for 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 bill rate schedule ID | ||
| EMP_BILL_RATE_SCHEDULE_ID | NUMBER | Stores the employee based bill rate schedule ID | ||
| BUDGETARY_OVERRIDE_FLAG | VARCHAR2 | (1) | Stores the Budgetary Override Flag | |
| NON_LAB_STD_BILL_RT_SCH_ID | NUMBER | (15) | ||
| BASELINE_FUNDING_FLAG | VARCHAR2 | (1) | ||
| PROJECT_TYPE_ID | NUMBER | (15) | Yes | The identifier that uniquely defines the project type |
| ORG_PROJECT_FLAG | VARCHAR2 | (1) | ||
| 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. | |
| RLZD_GAINS_EVENT_TYPE_ID | NUMBER | (15) | The identifier of the currency realized gain events used while processing funding revaluation. | |
| RLZD_LOSSES_EVENT_TYPE_ID | NUMBER | (15) | The identifier of the currency realized loss events used whiel processing funding revaluation. | |
| TOTAL_BURDEN_FLAG | VARCHAR2 | (1) | ||
| 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:
APPS
PA_ADW_PROJECT_TYPES_T1
PA_PROJECT_TYPES
PA_PROJECT_TYPES_ALL
|
|
|
|