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


VIEW: APPS.JAI_RG_FUND_TRF_AEL_V

Object Details
Object Name: JAI_RG_FUND_TRF_AEL_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewJA.JAI_RG_FUND_TRF_AEL_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
EVENT_TYPE CHAR (16)
APPLICATION_ID NUMBER

SET_OF_BOOKS_ID NUMBER (15)
JE_BATCH_ID NUMBER (15)
TRX_CLASS VARCHAR2 (16)
TRX_CLASS_NAME CHAR (20)
TRX_HDR_TABLE VARCHAR2 (23)
JE_CATEGORY VARCHAR2 (25)
USER_JE_CATEGORY_NAME VARCHAR2 (25)
JE_SOURCE VARCHAR2 (25)
USER_JE_SOURCE_NAME VARCHAR2 (25)
JE_HEADER_ID NUMBER (15)
JE_LINE_NUM NUMBER (15)
ENTERED_CURRENCY VARCHAR2 (15)
ENTERED_DR NUMBER

ENTERED_CR NUMBER

ACCOUNTED_DR NUMBER

ACCOUNTED_CR NUMBER

ACCOUNT_ID NUMBER (15)
ACCOUNTING_DATE DATE

ACCOUNT_DESCRIPTION VARCHAR2 (240)
CURRENCY_CONVERSION_RATE NUMBER

CURRENCY_CONVERSION_TYPE VARCHAR2 (30)
CURRENCY_USER_CONVERSION_TYPE VARCHAR2 (30)
CURRENCY_CONVERSION_DATE DATE

SOURCE_TABLE CHAR (20)
GL_TRANSFER_STATUS CHAR (1)
OPERATING_UNIT VARCHAR2 (240)
TRX_HDR_ID NUMBER

FROM_ORGANIZATION VARCHAR2 (240)
FROM_LOCATION VARCHAR2 (60)
TO_ORGANIZATION VARCHAR2 (240)
TO_LOCATION VARCHAR2 (60)
TRANSFER_DATE DATE

REGISTER_TYPE VARCHAR2 (5)
TRANSFER_EXCISE_AMOUNT NUMBER

TRANSFER_CESS_AMOUNT NUMBER

TRANSFER_SH_CESS_AMOUNT NUMBER

FROM_ORGANIZATION_ID NUMBER

TRANSFER_ID NUMBER

Query Text

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


SELECT EVENT_TYPE
,      APPLICATION_ID
,      SET_OF_BOOKS_ID
,      JE_BATCH_ID
,      TRX_CLASS
,      TRX_CLASS_NAME
,      TRX_HDR_TABLE
,      JE_CATEGORY
,      USER_JE_CATEGORY_NAME
,      JE_SOURCE
,      USER_JE_SOURCE_NAME
,      JE_HEADER_ID
,      JE_LINE_NUM
,      ENTERED_CURRENCY
,      ENTERED_DR
,      ENTERED_CR
,      ACCOUNTED_DR
,      ACCOUNTED_CR
,      ACCOUNT_ID
,      ACCOUNTING_DATE
,      ACCOUNT_DESCRIPTION
,      CURRENCY_CONVERSION_RATE
,      CURRENCY_CONVERSION_TYPE
,      CURRENCY_USER_CONVERSION_TYPE
,      CURRENCY_CONVERSION_DATE
,      SOURCE_TABLE
,      GL_TRANSFER_STATUS
,      OPERATING_UNIT
,      TRX_HDR_ID
,      FROM_ORGANIZATION
,      FROM_LOCATION
,      TO_ORGANIZATION
,      TO_LOCATION
,      TRANSFER_DATE
,      REGISTER_TYPE
,      TRANSFER_EXCISE_AMOUNT
,      TRANSFER_CESS_AMOUNT
,      TRANSFER_SH_CESS_AMOUNT
,      FROM_ORGANIZATION_ID
,      TRANSFER_ID
FROM APPS.JAI_RG_FUND_TRF_AEL_V;

Dependencies

[top of page]

APPS.JAI_RG_FUND_TRF_AEL_V references the following:

SchemaAPPS
SynonymGL_DAILY_CONVERSION_TYPES
SynonymGL_IMPORT_REFERENCES
SynonymGL_JE_CATEGORIES
SynonymGL_JE_HEADERS
SynonymGL_JE_LINES
SynonymGL_JE_SOURCES
PL/SQL PackageHR_GENERAL - show dependent code
ViewHR_LOCATIONS
ViewHR_OPERATING_UNITS
PL/SQL PackageHR_SECURITY - show dependent code
SynonymJAI_CMN_INVENTORY_ORGS
SynonymJAI_CMN_RG_23AC_II_TRXS
SynonymJAI_CMN_RG_BALANCES
SynonymJAI_CMN_RG_PLA_TRXS
SynonymJAI_CMN_RG_TRANSFERS
ViewORG_ORGANIZATION_DEFINITIONS
APPS.JAI_RG_FUND_TRF_AEL_V is referenced by following:

SchemaAPPS
ViewJAI_RG_FUND_TRF_AEL_GL_V
ViewJAI_RG_FUND_TRF_AEL_SL_V