[Home] [Help] [Dependency Information]
Object Name: | PAY_BALANCE_DIMENSIONS_VL |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PAY.PAY_BALANCE_DIMENSIONS_VL |
Subobject Name: | |
Status: | VALID |
MultiLingual view (a language resolved view of the data.)
Join of base and translation tables
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | Row ID Value | |
BALANCE_DIMENSION_ID | NUMBER | (9) | Yes | Balance dimension ID |
BUSINESS_GROUP_ID | NUMBER | (15) | Business group id | |
LEGISLATION_CODE | VARCHAR2 | (30) | Legislation code | |
ROUTE_ID | NUMBER | (15) | Yes | Route ID from ff_routes table |
DIMENSION_TYPE | VARCHAR2 | (1) | Yes | Dimension type |
DATABASE_ITEM_SUFFIX | VARCHAR2 | (80) | Yes | Dimension short name |
DIMENSION_NAME | VARCHAR2 | (80) | Yes | Dimension name |
DESCRIPTION | VARCHAR2 | (240) | Description | |
FEED_CHECKING_CODE | VARCHAR2 | (61) | Feed checking code | |
LEGISLATION_SUBGROUP | VARCHAR2 | (30) | Legislation sub group | |
PAYMENTS_FLAG | VARCHAR2 | (30) | Payments flag | |
EXPIRY_CHECKING_CODE | VARCHAR2 | (61) | Expiry checking code | |
EXPIRY_CHECKING_LEVEL | VARCHAR2 | (1) | Expiry checking level | |
FEED_CHECKING_TYPE | VARCHAR2 | (1) | Feed checking type | |
DIMENSION_LEVEL | VARCHAR2 | (30) | Dimension level | |
PERIOD_TYPE | VARCHAR2 | (30) | Period type | |
ASG_ACTION_BALANCE_DIM_ID | NUMBER | (9) | Assignment action balance dimension id | |
DATABASE_ITEM_FUNCTION | VARCHAR2 | (256) | Database item function | |
SAVE_RUN_BALANCE_ENABLED | VARCHAR2 | (30) | Save run balance flag | |
START_DATE_CODE | VARCHAR2 | (61) | Start date code |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, BALANCE_DIMENSION_ID
, BUSINESS_GROUP_ID
, LEGISLATION_CODE
, ROUTE_ID
, DIMENSION_TYPE
, DATABASE_ITEM_SUFFIX
, DIMENSION_NAME
, DESCRIPTION
, FEED_CHECKING_CODE
, LEGISLATION_SUBGROUP
, PAYMENTS_FLAG
, EXPIRY_CHECKING_CODE
, EXPIRY_CHECKING_LEVEL
, FEED_CHECKING_TYPE
, DIMENSION_LEVEL
, PERIOD_TYPE
, ASG_ACTION_BALANCE_DIM_ID
, DATABASE_ITEM_FUNCTION
, SAVE_RUN_BALANCE_ENABLED
, START_DATE_CODE
FROM APPS.PAY_BALANCE_DIMENSIONS_VL;
|
|
|