[Home] [Help] [Dependency Information]
Object Name: | PSB_WORKSHEETS_I |
---|---|
Object Type: | TABLE |
Owner: | PSB |
FND Design Data: | PSB.PSB_WORKSHEETS_I |
Subobject Name: | |
Status: | VALID |
PSB_WORKSHEETS_I is the interface table for worksheets. It is used to
export and import data to and from spreadsheets. Each instance of the
export of a worksheet is assigned a unique identifier.
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
PSB_WORKSHEETS_I_U1 | NORMAL | UNIQUE | APPS_TS_INTERFACE | EXPORT_ID |
PSB_WORKSHEETS_I_U2 | NORMAL | UNIQUE | APPS_TS_INTERFACE | EXPORT_NAME |
PSB_WORKSHEETS_I_N1 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE | WORKSHEET_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
EXPORT_ID | NUMBER | Yes | Unique identifier assigned to every export of a worksheet to the spreadsheet interface | |
EXPORT_NAME | VARCHAR2 | (80) | Yes | Name assigned to the export |
ACCOUNT_EXPORT_STATUS | VARCHAR2 | (10) | Status of the worksheet export process for the account sheet | |
POSITION_EXPORT_STATUS | VARCHAR2 | (10) | Status of the worksheet export process for the position sheet | |
WORKSHEET_ID | NUMBER | Yes | Worksheet unique identifier for which the export is performed | |
STAGE_ID | NUMBER | Worksheet current stage when the export process is performed | ||
SELECTED_STAGE_ID | NUMBER | Worksheet stage selected for export | ||
SELECTED_TEMPLATE_ID | NUMBER | Worksheet template selected for export | ||
CURRENCY_FLAG | VARCHAR2 | (1) | Currency type is S for statistical currency or C for functional currency. | |
BUDGET_BY_POSITION | VARCHAR2 | (1) | Indicates if position costs should be computed for each individual position in this worksheet | |
EXPORT_WORKSHEET_TYPE | VARCHAR2 | (1) | Type of worksheet exported is A for account, P for position, or B for both account and position. | |
ALLOW_ACCOUNT_IMPORT | VARCHAR2 | (1) | Indicates if account import is allowed. Valid values are Y or N. | |
ALLOW_POSITION_IMPORT | VARCHAR2 | (1) | Indicates if position import is allowed. Valid values are Y or N. | |
LAST_UPDATED_BY | NUMBER | Yes | Standard Who column | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | Standard Who column | ||
CREATED_BY | NUMBER | Yes | Standard Who column | |
CREATION_DATE | DATE | Yes | Standard Who column |
Cut, paste (and edit) the following text to query this object:
SELECT EXPORT_ID
, EXPORT_NAME
, ACCOUNT_EXPORT_STATUS
, POSITION_EXPORT_STATUS
, WORKSHEET_ID
, STAGE_ID
, SELECTED_STAGE_ID
, SELECTED_TEMPLATE_ID
, CURRENCY_FLAG
, BUDGET_BY_POSITION
, EXPORT_WORKSHEET_TYPE
, ALLOW_ACCOUNT_IMPORT
, ALLOW_POSITION_IMPORT
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
FROM PSB.PSB_WORKSHEETS_I;
PSB.PSB_WORKSHEETS_I does not reference any database object
PSB.PSB_WORKSHEETS_I is referenced by following:
|
|
|