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]

VIEW: APPS.PSB_WS_LINE_YEAR_XL_V

Object Details

Object Name:	PSB_WS_LINE_YEAR_XL_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PSB.PSB_WS_LINE_YEAR_XL_V
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
WORKSHEET_ID	NUMBER	(20)	Yes	Worksheet unique identifier.
CODE_COMBINATION_ID	NUMBER	(20)	Yes	General Ledger code combination unique identifier.
ACCOUNT_TYPE	VARCHAR2	(10)	Yes	General Ledger Account type: A (Asset), L (Liability), O (Equity), R (Revenue), E (Expense).
SERVICE_PACKAGE_ID	NUMBER	(20)	Yes	Service Package unique identifier.
SERVICE_PACKAGE_NAME	VARCHAR2	(15)	Yes
PRIORITY	NUMBER			Priority assigned to the service package.
TEMPLATE_ID	NUMBER			General Ledger template Unique Identifier. This column has a value for summary account lines.
CURRENCY_CODE	VARCHAR2	(10)	Yes	Functional currency of the General Ledger Set of Books or Statistical. This indicates the currency of the YTD_AMOUNT.
COLUMN1	NUMBER
COLUMN2	NUMBER
COLUMN3	NUMBER
COLUMN4	NUMBER
COLUMN5	NUMBER
COLUMN6	NUMBER
COLUMN7	NUMBER
COLUMN8	NUMBER
COLUMN9	NUMBER
COLUMN10	NUMBER
COLUMN11	NUMBER
COLUMN12	NUMBER

Query Text

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


SELECT WORKSHEET_ID
,      CODE_COMBINATION_ID
,      ACCOUNT_TYPE
,      SERVICE_PACKAGE_ID
,      SERVICE_PACKAGE_NAME
,      PRIORITY
,      TEMPLATE_ID
,      CURRENCY_CODE
,      COLUMN1
,      COLUMN2
,      COLUMN3
,      COLUMN4
,      COLUMN5
,      COLUMN6
,      COLUMN7
,      COLUMN8
,      COLUMN9
,      COLUMN10
,      COLUMN11
,      COLUMN12
FROM APPS.PSB_WS_LINE_YEAR_XL_V;

Dependencies

[top of page]

APPS.PSB_WS_LINE_YEAR_XL_V references the following:

APPS: PSB_SERVICE_PACKAGES; PSB_WS_ACCOUNT_LINES; PSB_WS_LINES; PSB_WS_MATRIX - show dependent code

APPS.PSB_WS_LINE_YEAR_XL_V is referenced by following:

APPS: PSB_EXCEL_PVT - show dependent code