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

TABLE: HR.HR_S_BALANCE_DIMENSIONS

Object Details
Object Name: HR_S_BALANCE_DIMENSIONS
Object Type: TABLE
Owner: HR
FND Design Data: TablePER.HR_S_BALANCE_DIMENSIONS
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
BALANCE_DIMENSION_ID NUMBER (9)
BUSINESS_GROUP_ID NUMBER (15)
LEGISLATION_CODE VARCHAR2 (30)
ROUTE_ID NUMBER (15)
DATABASE_ITEM_SUFFIX VARCHAR2 (80)
DIMENSION_NAME VARCHAR2 (80)
DIMENSION_TYPE VARCHAR2 (1)
DESCRIPTION VARCHAR2 (240)
FEED_CHECKING_CODE VARCHAR2 (61)
FEED_CHECKING_TYPE VARCHAR2 (1)
LEGISLATION_SUBGROUP VARCHAR2 (30)
PAYMENTS_FLAG VARCHAR2 (30)
EXPIRY_CHECKING_CODE VARCHAR2 (61)
EXPIRY_CHECKING_LEVEL VARCHAR2 (1)
DIMENSION_LEVEL VARCHAR2 (30)
PERIOD_TYPE VARCHAR2 (30)
ASG_ACTION_BALANCE_DIM_ID NUMBER (9)
SAVE_RUN_BALANCE_ENABLED VARCHAR2 (30)
START_DATE_CODE VARCHAR2 (61)
DATABASE_ITEM_FUNCTION VARCHAR2 (30)
Query Text

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


SELECT BALANCE_DIMENSION_ID
,      BUSINESS_GROUP_ID
,      LEGISLATION_CODE
,      ROUTE_ID
,      DATABASE_ITEM_SUFFIX
,      DIMENSION_NAME
,      DIMENSION_TYPE
,      DESCRIPTION
,      FEED_CHECKING_CODE
,      FEED_CHECKING_TYPE
,      LEGISLATION_SUBGROUP
,      PAYMENTS_FLAG
,      EXPIRY_CHECKING_CODE
,      EXPIRY_CHECKING_LEVEL
,      DIMENSION_LEVEL
,      PERIOD_TYPE
,      ASG_ACTION_BALANCE_DIM_ID
,      SAVE_RUN_BALANCE_ENABLED
,      START_DATE_CODE
,      DATABASE_ITEM_FUNCTION
FROM HR.HR_S_BALANCE_DIMENSIONS;

Dependencies

[top of page]

HR.HR_S_BALANCE_DIMENSIONS does not reference any database object

HR.HR_S_BALANCE_DIMENSIONS is referenced by following:

SchemaAPPS
SynonymHR_S_BALANCE_DIMENSIONS
SchemaPUBLIC
SynonymHR_S_BALANCE_DIMENSIONS