[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | PSB_STANDARD_BUDGET_ITEM_LINES |
|---|---|
| Object Type: | TABLE |
| Owner: | PSB |
| FND Design Data: |  PSB.PSB_STANDARD_BUDGET_ITEM_LINES
|
| Subobject Name: | |
| Status: | VALID |
PSB_STANDARD_BUDGET_ITEM_LINES stores the default cost and the default
values for one or more of the segments of the accounting flexfield.
The cost and the segment value information is stored by set of books
for each standard item. The cost is specified in the functional
currency of the set of books.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| PSB_STD_BUDGET_ITEM_LINES_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 STANDARD_BUDGET_ITEM_ID
SET_OF_BOOKS_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| STANDARD_BUDGET_ITEM_ID | NUMBER | (15) | Yes | Standard budget item unique identifier for which the sorting information is defined |
| SET_OF_BOOKS_ID | NUMBER | (15) | Yes | General Ledger Set of Books identifier for which the default account distribution is defined |
| RATE | NUMBER | Rate to be used when estimating cost for this standard budget item. Default cost that can be modified in the worksheet. | ||
| CURRENCY | VARCHAR2 | (30) | Functional currency for the General Ledger Set of Books | |
| CONCATENATED_SEGMENTS | VARCHAR2 | (2000) | Concatenated accounting segment values entered. Used only for display purposes in the form. | |
| SEGMENT1 | VARCHAR2 | (25) | Accounting Flexfield segment column | |
| SEGMENT2 | VARCHAR2 | (25) | Accounting Flexfield segment column | |
| SEGMENT3 | VARCHAR2 | (25) | Accounting Flexfield segment column | |
| SEGMENT4 | VARCHAR2 | (25) | Accounting Flexfield segment column | |
| SEGMENT5 | VARCHAR2 | (25) | Accounting Flexfield segment column | |
| SEGMENT6 | VARCHAR2 | (25) | Accounting Flexfield segment column | |
| SEGMENT7 | VARCHAR2 | (25) | Accounting Flexfield segment column | |
| SEGMENT8 | VARCHAR2 | (25) | Accounting Flexfield segment column | |
| SEGMENT9 | VARCHAR2 | (25) | Accounting Flexfield segment column | |
| SEGMENT10 | VARCHAR2 | (25) | Accounting Flexfield segment column | |
| SEGMENT11 | VARCHAR2 | (25) | Accounting Flexfield segment column | |
| SEGMENT12 | VARCHAR2 | (25) | Accounting Flexfield segment column | |
| SEGMENT13 | VARCHAR2 | (25) | Accounting Flexfield segment column | |
| SEGMENT14 | VARCHAR2 | (25) | Accounting Flexfield segment column | |
| SEGMENT15 | VARCHAR2 | (25) | Accounting Flexfield segment column | |
| SEGMENT16 | VARCHAR2 | (25) | Accounting Flexfield segment column | |
| SEGMENT17 | VARCHAR2 | (25) | Accounting Flexfield segment column | |
| SEGMENT18 | VARCHAR2 | (25) | Accounting Flexfield segment column | |
| SEGMENT19 | VARCHAR2 | (25) | Accounting Flexfield segment column | |
| SEGMENT20 | VARCHAR2 | (25) | Accounting Flexfield segment column | |
| SEGMENT21 | VARCHAR2 | (25) | Accounting Flexfield segment column | |
| SEGMENT22 | VARCHAR2 | (25) | Accounting Flexfield segment column | |
| SEGMENT23 | VARCHAR2 | (25) | Accounting Flexfield segment column | |
| SEGMENT24 | VARCHAR2 | (25) | Accounting Flexfield segment column | |
| SEGMENT25 | VARCHAR2 | (25) | Accounting Flexfield segment column | |
| SEGMENT26 | VARCHAR2 | (25) | Accounting Flexfield segment column | |
| SEGMENT27 | VARCHAR2 | (25) | Accounting Flexfield segment column | |
| SEGMENT28 | VARCHAR2 | (25) | Accounting Flexfield segment column | |
| SEGMENT29 | VARCHAR2 | (25) | Accounting Flexfield segment column | |
| SEGMENT30 | VARCHAR2 | (25) | Accounting Flexfield segment column | |
| LAST_UPDATE_DATE | DATE | Standard Who column | ||
| LAST_UPDATED_BY | NUMBER | (15) | Standard Who column | |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
| CREATED_BY | NUMBER | (15) | Standard Who column | |
| CREATION_DATE | DATE | Standard Who column | ||
| ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
| ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
| ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
| ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
| ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
| ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
| ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
| ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
| ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
| ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
| CONTEXT | VARCHAR2 | (30) | Descriptive Flexfield context |
Cut, paste (and edit) the following text to query this object:
SELECT STANDARD_BUDGET_ITEM_ID
, SET_OF_BOOKS_ID
, RATE
, CURRENCY
, CONCATENATED_SEGMENTS
, SEGMENT1
, SEGMENT2
, SEGMENT3
, SEGMENT4
, SEGMENT5
, SEGMENT6
, SEGMENT7
, SEGMENT8
, SEGMENT9
, SEGMENT10
, SEGMENT11
, SEGMENT12
, SEGMENT13
, SEGMENT14
, SEGMENT15
, SEGMENT16
, SEGMENT17
, SEGMENT18
, SEGMENT19
, SEGMENT20
, SEGMENT21
, SEGMENT22
, SEGMENT23
, SEGMENT24
, SEGMENT25
, SEGMENT26
, SEGMENT27
, SEGMENT28
, SEGMENT29
, SEGMENT30
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, CONTEXT
FROM PSB.PSB_STANDARD_BUDGET_ITEM_LINES;
PSB.PSB_STANDARD_BUDGET_ITEM_LINES does not reference any database object
PSB.PSB_STANDARD_BUDGET_ITEM_LINES is referenced by following:
APPS
PSB_STANDARD_BUDGET_ITEM_LINES
|
|
|
|