[Home] [Help] [Dependency Information]
Object Name: | PSB_WS_ACCOUNTS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PSB.PSB_WS_ACCOUNTS_V |
Subobject Name: | |
Status: | VALID |
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.
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. |
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;
APPS.PSB_WS_ACCOUNTS_V is not referenced by any database object
|
|
|