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

VIEW: APPS.JAI_CMN_RG_BALANCES_V

Object Details
Object Name: JAI_CMN_RG_BALANCES_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewJA.JAI_CMN_RG_BALANCES_V
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.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
ORG_UNIT_ID NUMBER (15) Yes
ORGANIZATION_ID NUMBER (15)
LOCATION_ID NUMBER (15)
PLA_BALANCE NUMBER

RG23A_BALANCE NUMBER

RG23C_BALANCE NUMBER

CREATION_DATE DATE

CREATED_BY NUMBER (15)
LAST_UPDATED_BY NUMBER (15)
LAST_UPDATE_LOGIN NUMBER (15)
LAST_UPDATE_DATE DATE

ORGANIZATION_NAME VARCHAR2 (240) Yes
LOCATION_CODE VARCHAR2 (60)
CURRENCY_CODE VARCHAR2 (15) Yes
BASIC_PLA_BALANCE NUMBER

ADDITIONAL_PLA_BALANCE NUMBER

OTHER_PLA_BALANCE NUMBER

Query Text

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


SELECT ROW_ID
,      ORG_UNIT_ID
,      ORGANIZATION_ID
,      LOCATION_ID
,      PLA_BALANCE
,      RG23A_BALANCE
,      RG23C_BALANCE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      LAST_UPDATE_DATE
,      ORGANIZATION_NAME
,      LOCATION_CODE
,      CURRENCY_CODE
,      BASIC_PLA_BALANCE
,      ADDITIONAL_PLA_BALANCE
,      OTHER_PLA_BALANCE
FROM APPS.JAI_CMN_RG_BALANCES_V;

Dependencies

[top of page]

APPS.JAI_CMN_RG_BALANCES_V references the following:

SchemaAPPS
SynonymFND_CURRENCIES
ViewGL_SETS_OF_BOOKS
PL/SQL PackageHR_GENERAL - show dependent code
ViewHR_LOCATIONS
PL/SQL PackageHR_SECURITY - show dependent code
SynonymJAI_CMN_INVENTORY_ORGS
SynonymJAI_CMN_RG_BALANCES
ViewORG_ORGANIZATION_DEFINITIONS
APPS.JAI_CMN_RG_BALANCES_V is referenced by following:

SchemaAPPS
Package BodyJAI_CMN_RG_TRANSFER_PKG - show dependent code