[Home] [Help] [Dependency Information]
Object Name: | PA_BUDGET_TYPES |
---|---|
Object Type: | TABLE |
Owner: | PA |
FND Design Data: | PA.PA_BUDGET_TYPES |
Subobject Name: | |
Status: | VALID |
PA_BUDGET_TYPES stores the types of budgets that are used for
different business purposes. There are two predefined budget types
(approved cost and approved revenue). The implementation team can
also define the budget types that are required in their business
practice.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
PA_BUDGET_TYPES_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | BUDGET_TYPE_CODE |
PA_BUDGET_TYPES_U2 | NORMAL | UNIQUE | APPS_TS_TX_IDX | BUDGET_TYPE |
PA_BUDGET_TYPES_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | ADW_NOTIFY_FLAG |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
BUDGET_TYPE_CODE | VARCHAR2 | (30) | Yes | The unique identifier of budget type |
LAST_UPDATE_DATE | DATE | Yes | Standard Who Column | |
LAST_UPDATED_BY | NUMBER | Yes | Standard Who Column | |
CREATION_DATE | DATE | Yes | Standard Who Column | |
CREATED_BY | NUMBER | Yes | Standard Who Column | |
LAST_UPDATE_LOGIN | NUMBER | Yes | Standard Who Column | |
BUDGET_TYPE | VARCHAR2 | (30) | Yes | The short, user-friendly name of the budget type |
START_DATE_ACTIVE | DATE | Yes | First effective date of the budget type | |
BUDGET_AMOUNT_CODE | VARCHAR2 | (30) | Yes | Indicator if budget type is used for cost or revenue budget |
PREDEFINED_FLAG | VARCHAR2 | (1) | Yes | Flag that indicates if the budget type is predefined. |
ACCUMULATION_FLAG | VARCHAR2 | (1) | Yes | Flag that indicates if the budget type is to be summarized for project summary amount. Currently it is not used. All budget types are summarized. |
END_DATE_ACTIVE | DATE | Last effective date of the budget type | ||
DESCRIPTION | VARCHAR2 | (255) | The description of the budget type | |
ENABLE_WF_FLAG | VARCHAR2 | (1) | This column indicates if a budget approval workflow can be enabled for this budget 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 | |
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 | |
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. | |
PLAN_TYPE | VARCHAR2 | (30) | Stores the type of plan. | |
UPGRADE_BUDGET_TYPE_FLAG | VARCHAR2 | (1) | Indicates that the budget type is eligible for upgrade |
Cut, paste (and edit) the following text to query this object:
SELECT BUDGET_TYPE_CODE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, BUDGET_TYPE
, START_DATE_ACTIVE
, BUDGET_AMOUNT_CODE
, PREDEFINED_FLAG
, ACCUMULATION_FLAG
, END_DATE_ACTIVE
, DESCRIPTION
, ENABLE_WF_FLAG
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ADW_NOTIFY_FLAG
, PLAN_TYPE
, UPGRADE_BUDGET_TYPE_FLAG
FROM PA.PA_BUDGET_TYPES;
PA.PA_BUDGET_TYPES does not reference any database object
PA.PA_BUDGET_TYPES is referenced by following:
|
|
|