[Home] [Help] [Dependency Information]
Object Name: | PSB_WS_POSITION_ACCOUNTS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PSB.PSB_WS_POSITION_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. |
ELEMENT_SET_ID | NUMBER | (20) | ||
POSITION_LINE_ID | NUMBER | |||
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. |
STAGE_SET_ID | NUMBER | Yes | ||
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. | ||
SALARY_ACCOUNT_LINE | VARCHAR2 | (1) |
Cut, paste (and edit) the following text to query this object:
SELECT WORKSHEET_ID
, ELEMENT_SET_ID
, POSITION_LINE_ID
, CODE_COMBINATION_ID
, SERVICE_PACKAGE_ID
, ACCOUNT_TYPE
, CURRENCY_CODE
, STAGE_SET_ID
, BUDGET_GROUP_ID
, TEMPLATE_ID
, SALARY_ACCOUNT_LINE
FROM APPS.PSB_WS_POSITION_ACCOUNTS_V;
|
|
|