[Home] [Help] [Dependency Information]
Object Name: | PAY_BALANCES_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PAY.PAY_BALANCES_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 |
---|---|---|---|---|
ASSIGNMENT_ACTION_ID | NUMBER | (15) | Assignment action id value of PAY_ASSIGNMENT_ACTIONS table | |
BALANCE_NAME_AND_SUFFIX | VARCHAR2 | (160) | Balance name with its corresponding dimension suffix name | |
DEFINED_BALANCE_ID | NUMBER | (9) | Yes | Balance with its corresponding dimension |
BALANCE_TYPE_ID | NUMBER | (9) | Yes | Balance Type ID |
BALANCE_DIMENSION_ID | NUMBER | (9) | Yes | Balance dimension ID |
LATEST_BALANCE_EXIST | VARCHAR2 | (4000) | Latest Balance Exists Flag | |
C_BALANCE_UOM | VARCHAR2 | (30) | Yes | Balance Unit of Measure |
D_BALANCE_UOM | VARCHAR2 | (4000) | Unit of Measure for UNITS lookup | |
D_CURRENCY_CODE | VARCHAR2 | (15) | Currency code for the given balance | |
BUSINESS_GROUP_ID | NUMBER | Business group id | ||
LEGISLATION_CODE | VARCHAR2 | (30) | Legislation code | |
EFFECTIVE_START_DATE | DATE | Effective Start Date | ||
EFFECTIVE_END_DATE | DATE | Effective End Date |
Cut, paste (and edit) the following text to query this object:
SELECT ASSIGNMENT_ACTION_ID
, BALANCE_NAME_AND_SUFFIX
, DEFINED_BALANCE_ID
, BALANCE_TYPE_ID
, BALANCE_DIMENSION_ID
, LATEST_BALANCE_EXIST
, C_BALANCE_UOM
, D_BALANCE_UOM
, D_CURRENCY_CODE
, BUSINESS_GROUP_ID
, LEGISLATION_CODE
, EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE
FROM APPS.PAY_BALANCES_V;
|
|
|