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_WS_COLUMNS_I

Object Details

Object Name:	PSB_WS_COLUMNS_I
Object Type:	TABLE
Owner:	PSB
FND Design Data:	PSB.PSB_WS_COLUMNS_I
Subobject Name:
Status:	VALID

PSB_WS_COLUMNS_I is an interface table used for export and import of
data to and from a spreadsheet. For a given export this table stores
the year displayed in each column.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PSB_WS_COLUMNS_I_U1	NORMAL	UNIQUE	APPS_TS_INTERFACE	EXPORT_ID EXPORT_WORKSHEET_TYPE COLUMN_NUMBER

Columns

Name	Datatype	Length	Mandatory	Comments
EXPORT_ID	NUMBER		Yes	Unique identifier assigned to every export of a worksheet to the spreadsheet interface
EXPORT_WORKSHEET_TYPE	VARCHAR2	(1)	Yes	Export worksheet type is A (Account) or P (Position)
COLUMN_NUMBER	NUMBER		Yes	This number corresponds to the AMOUNT column number on PSB_WS_LINE_BALANCES_I
BUDGET_YEAR_ID	NUMBER			Budget year unique identifier. The budget year for which the balance is stored in PSB_WS_ACCOUNT_LINES_I.
COLUMN_TYPE	VARCHAR2	(1)		Column type is T (Total), A (Amount) or P (Percentage)
BUDGET_YEAR_NAME	VARCHAR2	(15)		Budget year name. The budget year for which the balance is stored in PSB_WS_LINE_BALANCES_I.
BUDGET_PERIOD_ID	NUMBER			Budget period unique identifier. Budget period for which the balance is stored in PSB_WS_LINE_BALANCES_I.
BUDGET_PERIOD_NAME	VARCHAR2	(15)		Budget period name. Budget year for which the balance is stored in PSB_WS_LINE_BALANCES_I.
BALANCE_TYPE	VARCHAR2	(1)		Balance type is B (Budget), A (Actual) or E (Estimate). The balance type of the amount stored in PSB_WS_LINE_BALANCES_I.
DISPLAYED_BALANCE_TYPE	VARCHAR2	(15)		Balance type displayed value is Budget, Actual, Encumbrance or Estimate. Balance type of the amount stored in PSB_WS_LINE_BALANCES_I.
YEAR_CATEGORY_TYPE	VARCHAR2	(2)		Budget year type for which the balance is stored in PSB_WS_LINE_BALANCES_I.
DISPLAYED_YEAR_CATEGORY_TYPE	VARCHAR2	(15)		Name of budget year type for which the balance is stored in PSB_WS_LINE_BALANCES_I
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER		Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER			Standard Who column
CREATED_BY	NUMBER		Yes	Standard Who column
CREATED_DATE	DATE		Yes	Standard Who column

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT EXPORT_ID
,      EXPORT_WORKSHEET_TYPE
,      COLUMN_NUMBER
,      BUDGET_YEAR_ID
,      COLUMN_TYPE
,      BUDGET_YEAR_NAME
,      BUDGET_PERIOD_ID
,      BUDGET_PERIOD_NAME
,      BALANCE_TYPE
,      DISPLAYED_BALANCE_TYPE
,      YEAR_CATEGORY_TYPE
,      DISPLAYED_YEAR_CATEGORY_TYPE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATED_DATE
FROM PSB.PSB_WS_COLUMNS_I;

Dependencies

[top of page]

PSB.PSB_WS_COLUMNS_I does not reference any database object

PSB.PSB_WS_COLUMNS_I is referenced by following:

APPS: PSB_WS_COLUMNS_I