eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: PSB.PSB_WORKSHEETS_I

Object Details

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.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

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

Columns

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

Query Text

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;

Dependencies

[top of page]

PSB.PSB_WORKSHEETS_I does not reference any database object

PSB.PSB_WORKSHEETS_I is referenced by following:

APPS: PSB_WORKSHEETS_I