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

VIEW: APPS.PSB_WS_ACCOUNTS_V

Object Details
Object Name: PSB_WS_ACCOUNTS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPSB.PSB_WS_ACCOUNTS_V
Subobject Name:
Status: VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[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.
SERVICE_PACKAGE_ID NUMBER (20) Yes Service package unique identifier. The service package to which this line is assigned.
ACCOUNT_TYPE VARCHAR2 (10) Yes General Ledger Account type: A (Asset), L (Liability), O (Equity), R (Revenue), E (Expense).
CURRENCY_CODE VARCHAR2 (10) Yes Functional currency of the General Ledger Set of Books or Statistical. This indicates the currency of the YTD_AMOUNT.
BUDGET_GROUP_ID NUMBER
Yes Budget group unique identifier. The budget group to which this account belongs.
TEMPLATE_ID NUMBER

General Ledger template Unique Identifier. This column has a value for summary account lines.
Query Text

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


SELECT WORKSHEET_ID
,      CODE_COMBINATION_ID
,      SERVICE_PACKAGE_ID
,      ACCOUNT_TYPE
,      CURRENCY_CODE
,      BUDGET_GROUP_ID
,      TEMPLATE_ID
FROM APPS.PSB_WS_ACCOUNTS_V;

Dependencies

[top of page]

APPS.PSB_WS_ACCOUNTS_V references the following:

SchemaAPPS
SynonymPSB_WS_ACCOUNT_LINES
SynonymPSB_WS_LINES
PL/SQL PackagePSB_WS_MATRIX - show dependent code

APPS.PSB_WS_ACCOUNTS_V is not referenced by any database object