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


VIEW: APPS.GL_LEDGER_LE_V

Object Details
Object Name: GL_LEDGER_LE_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewSQLGL.GL_LEDGER_LE_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
LEDGER_ID NUMBER (15) Yes
LEDGER_NAME VARCHAR2 (30) Yes
LEDGER_SHORT_NAME VARCHAR2 (20) Yes
LEGAL_ENTITY_ID NUMBER (15)
LEGAL_ENTITY_NAME VARCHAR2 (240)
LOCATION_ID NUMBER (15)
LOCATION_CODE VARCHAR2 (60)
LOCATION_DESCRIPTION VARCHAR2 (240)
LEDGER_CATEGORY_CODE VARCHAR2 (30) Yes
CURRENCY_CODE VARCHAR2 (15) Yes
CHART_OF_ACCOUNTS_ID NUMBER (15) Yes
PERIOD_SET_NAME VARCHAR2 (15) Yes
ACCOUNTED_PERIOD_TYPE VARCHAR2 (15) Yes
SLA_ACCOUNTING_METHOD_CODE VARCHAR2 (30)
SLA_ACCOUNTING_METHOD_TYPE VARCHAR2 (1)
BAL_SEG_VALUE_OPTION_CODE VARCHAR2 (1) Yes
BAL_SEG_COLUMN_NAME VARCHAR2 (25) Yes
BAL_SEG_VALUE_SET_ID NUMBER (10) Yes
ACCTG_ENVIRONMENT_CODE VARCHAR2 (30) Yes
CONFIGURATION_ID NUMBER (15) Yes
PRIMARY_LEDGER_ID NUMBER (15) Yes
RELATIONSHIP_ENABLED_FLAG VARCHAR2 (1) Yes
Query Text

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


SELECT LEDGER_ID
,      LEDGER_NAME
,      LEDGER_SHORT_NAME
,      LEGAL_ENTITY_ID
,      LEGAL_ENTITY_NAME
,      LOCATION_ID
,      LOCATION_CODE
,      LOCATION_DESCRIPTION
,      LEDGER_CATEGORY_CODE
,      CURRENCY_CODE
,      CHART_OF_ACCOUNTS_ID
,      PERIOD_SET_NAME
,      ACCOUNTED_PERIOD_TYPE
,      SLA_ACCOUNTING_METHOD_CODE
,      SLA_ACCOUNTING_METHOD_TYPE
,      BAL_SEG_VALUE_OPTION_CODE
,      BAL_SEG_COLUMN_NAME
,      BAL_SEG_VALUE_SET_ID
,      ACCTG_ENVIRONMENT_CODE
,      CONFIGURATION_ID
,      PRIMARY_LEDGER_ID
,      RELATIONSHIP_ENABLED_FLAG
FROM APPS.GL_LEDGER_LE_V;

Dependencies

[top of page]

APPS.GL_LEDGER_LE_V references the following:

SchemaAPPS
SynonymGL_LEDGERS
SynonymGL_LEDGER_CONFIGURATIONS
SynonymGL_LEDGER_CONFIG_DETAILS
SynonymGL_LEDGER_RELATIONSHIPS
SynonymHR_LOCATIONS_ALL_TL
SynonymXLE_ENTITY_PROFILES
SynonymXLE_REGISTRATIONS
APPS.GL_LEDGER_LE_V is referenced by following:

SchemaAPPS
Package BodyARP_LEGAL_ENTITY_UTIL - show dependent code
Package BodyBOM_CSTRACCR_XMLP_PKG - show dependent code
Package BodyBOM_CSTRPACQ_XMLP_PKG - show dependent code
Package BodyBOM_CSTRPDSS_XMLP_PKG - show dependent code
Package BodyBOM_CSTRPICR_XMLP_PKG - show dependent code
Package BodyCE_BANK_PUB - show dependent code
Package BodyCE_BAT_API - show dependent code
Package BodyCSTPPPSC - show dependent code
ViewCST_MTL_RCV_TXN_V
ViewCST_PAC_LEGAL_ENTITIES_V
Package BodyCST_PERITEMCOSTCHANGERPT_PVT - show dependent code
Package BodyFUN_OPEN_INTERFACE_PKG - show dependent code
Package BodyFUN_RECON_RPT_PKG - show dependent code
Package BodyFUN_TRX_ENTRY_UTIL - show dependent code
Package BodyFUN_WEBADI_PKG - show dependent code
Package BodyFV_UTILITY - show dependent code
Package BodyGL_MC_INFO - show dependent code
Package BodyGMF_ALLOC_PROC - show dependent code
Package BodyIBY_DISBURSEMENT_COMP_PUB - show dependent code
PL/SQL PackageIBY_PAYINSTR_PUB - show dependent code
Package BodyINV_INVSTMVT_XMLP_PKG - show dependent code
Package BodyINV_MGD_MVT_FIN_MDTR - show dependent code
Package BodyINV_MGD_MVT_SETUP_MDTR - show dependent code
Package BodyINV_MGD_MVT_UTILS_PKG - show dependent code
Package BodyJAI_AP_UTILS_PKG - show dependent code
Package BodyJA_CN_POST_UTILITY_PKG - show dependent code
Package BodyJE_ES_WHTAX - show dependent code
Package BodyJE_ITWHYE_AP_PKG - show dependent code
Package BodyJE_ZZ_AUDIT_AP_PKG - show dependent code
Package BodyJG_RX_IR_PKG - show dependent code
Package BodyJG_ZZ_AUDIT_GL_PKG - show dependent code
Package BodyJG_ZZ_PTCE_DT_PKG - show dependent code
Package BodyJG_ZZ_RTCE_DT_PKG - show dependent code
PL/SQL PackageJG_ZZ_RTCE_DT_PKG - show dependent code
Package BodyJG_ZZ_VAT_SELECTION_PKG - show dependent code
Package BodyJL_BR_AP_VALIDATE_COLLECTION - show dependent code
Package BodyJL_BR_AR_LOG_VALIDATION - show dependent code
Package BodyJL_BR_SPED_DATA_EXTRACT_PKG - show dependent code
Package BodyJL_BR_WORKDAY_CALENDAR - show dependent code
Package BodyJL_JLBRRCAD_XMLP_PKG - show dependent code
Package BodyJL_ZZ_AP_LIBRARY_1_PKG - show dependent code
ViewXTR_AP_OPEN_APLD_TRX_V
ViewXTR_AP_OPEN_TRX_V
ViewXTR_AP_ORIG_TRX_V
ViewXTR_AR_OPEN_APLD_TRX_V
ViewXTR_AR_OPEN_TRX_V
ViewXTR_AR_ORIG_TRX_V
ViewXTR_BIS_CASHFLOWS_V
Package BodyXTR_CASH_FCST - show dependent code
Package BodyXTR_FPS2_P - show dependent code
Package BodyXTR_HEDGE_PROCESS_P - show dependent code
ViewXTR_ONC_ELIGIBLE_DEALS_V
ViewZX_EXEMPTIONS_V
Package BodyZX_EXTRACT_PKG - show dependent code
Package BodyZX_PTP_MIGRATE_PKG - show dependent code
Package BodyZX_ZXAPJAJL_XMLP_PKG - show dependent code
Package BodyZX_ZXARRECV_XMLP_PKG - show dependent code
Package BodyZX_ZXXATB_XMLP_PKG - show dependent code