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


VIEW: APPS.AR_LEDGER_H_V

Object Details
Object Name: AR_LEDGER_H_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewAR.AR_LEDGER_H_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
LDG_ACCOUNTED_PERIOD_TYPE VARCHAR2 (15) Yes
LDG_CHART_OF_ACCOUNTS_ID NUMBER (15) Yes
LDG_CUM_TRANS_CCID NUMBER (15)
LDG_CURRENCY_CODE VARCHAR2 (15) Yes
LDG_DAILY_TRANS_RATE_TYPE VARCHAR2 (30)
LDG_DESCRIPTION VARCHAR2 (240)
LDG_FUTURE_ENTER_PERIODS_LIMIT NUMBER (15) Yes
LDG_LATEST_ENCUMBRANCE_YEAR NUMBER (15)
LDG_LATEST_OPENED_PERIOD_NAME VARCHAR2 (15)
LDG_NAME VARCHAR2 (30) Yes
LDG_NET_INCOME_CCID NUMBER (15)
LDG_PERIOD_SET_NAME VARCHAR2 (15) Yes
LDG_RES_ENCUMB_CCID NUMBER (15)
LDG_RET_EARN_CCID NUMBER (15) Yes
LDG_LEDGER_ID NUMBER (15) Yes
LDG_SHORT_NAME VARCHAR2 (20) Yes
LEDGER_ID NUMBER (15) Yes
EVENT_ID NUMBER (15)
Query Text

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


SELECT LDG_ACCOUNTED_PERIOD_TYPE
,      LDG_CHART_OF_ACCOUNTS_ID
,      LDG_CUM_TRANS_CCID
,      LDG_CURRENCY_CODE
,      LDG_DAILY_TRANS_RATE_TYPE
,      LDG_DESCRIPTION
,      LDG_FUTURE_ENTER_PERIODS_LIMIT
,      LDG_LATEST_ENCUMBRANCE_YEAR
,      LDG_LATEST_OPENED_PERIOD_NAME
,      LDG_NAME
,      LDG_NET_INCOME_CCID
,      LDG_PERIOD_SET_NAME
,      LDG_RES_ENCUMB_CCID
,      LDG_RET_EARN_CCID
,      LDG_LEDGER_ID
,      LDG_SHORT_NAME
,      LEDGER_ID
,      EVENT_ID
FROM APPS.AR_LEDGER_H_V;

Dependencies

[top of page]

APPS.AR_LEDGER_H_V references the following:

SchemaAPPS
SynonymAR_XLA_LINES_EXTRACT
SynonymGL_LEDGERS

APPS.AR_LEDGER_H_V is not referenced by any database object