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


VIEW: APPS.PER_BF_BALANCE_TYPES_V

Object Details
Object Name: PER_BF_BALANCE_TYPES_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPER.PER_BF_BALANCE_TYPES_V
Subobject Name:
Status: VALID

View Type

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.

[View Source]

Columns
Name Datatype Length Mandatory Comments
INTERNAL_BALANCE_NAME VARCHAR2 (30) Yes
DISPLAYED_BALANCE_NAME VARCHAR2 (30) Yes
UNITS VARCHAR2 (4000)
UNITS_CODE VARCHAR2 (30)
CURRENCY_CODE VARCHAR2 (15)
ELEMENT_REPORTING_NAME VARCHAR2 (80)
ELEMENT_NAME VARCHAR2 (80)
INPUT_VALUE_NAME VARCHAR2 (80)
BALANCE_CATEGORY VARCHAR2 (4000)
BALANCE_CATEGORY_CODE VARCHAR2 (30)
BALANCE_DATE_FROM DATE

BALANCE_DATE_TO DATE

INPUT_VALUE_ID NUMBER (9)
ELEMENT_TYPE_ID NUMBER (9)
BALANCE_TYPE_ID NUMBER (15) Yes
BUSINESS_GROUP_ID NUMBER (15) Yes
OBJECT_VERSION_NUMBER NUMBER (9) Yes
Query Text

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


SELECT INTERNAL_BALANCE_NAME
,      DISPLAYED_BALANCE_NAME
,      UNITS
,      UNITS_CODE
,      CURRENCY_CODE
,      ELEMENT_REPORTING_NAME
,      ELEMENT_NAME
,      INPUT_VALUE_NAME
,      BALANCE_CATEGORY
,      BALANCE_CATEGORY_CODE
,      BALANCE_DATE_FROM
,      BALANCE_DATE_TO
,      INPUT_VALUE_ID
,      ELEMENT_TYPE_ID
,      BALANCE_TYPE_ID
,      BUSINESS_GROUP_ID
,      OBJECT_VERSION_NUMBER
FROM APPS.PER_BF_BALANCE_TYPES_V;

Dependencies

[top of page]

APPS.PER_BF_BALANCE_TYPES_V references the following:

SchemaAPPS
PL/SQL PackageHR_GENERAL - show dependent code
ViewPER_BF_BALANCE_ELEMENTS_V
SynonymPER_BF_BALANCE_TYPES
ViewPER_BUSINESS_GROUPS

APPS.PER_BF_BALANCE_TYPES_V is not referenced by any database object