[Home] [Help]
[Dependency Information]
| Object Name: | GL_LEDGER_LE_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: | SQLGL.GL_LEDGER_LE_V
|
| Subobject Name: | |
| Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
| 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 |
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;
APPS
GL_LEDGERS
GL_LEDGER_CONFIGURATIONS
GL_LEDGER_CONFIG_DETAILS
GL_LEDGER_RELATIONSHIPS
HR_LOCATIONS_ALL_TL
XLE_ENTITY_PROFILES
XLE_REGISTRATIONS
APPS
ARP_LEGAL_ENTITY_UTIL
- show dependent code
BOM_CSTRACCR_XMLP_PKG
- show dependent code
BOM_CSTRPACQ_XMLP_PKG
- show dependent code
BOM_CSTRPDSS_XMLP_PKG
- show dependent code
BOM_CSTRPICR_XMLP_PKG
- show dependent code
CE_BANK_PUB
- show dependent code
CE_BAT_API
- show dependent code
CSTPPPSC
- show dependent code
CST_MTL_RCV_TXN_V
CST_PAC_LEGAL_ENTITIES_V
CST_PERITEMCOSTCHANGERPT_PVT
- show dependent code
FUN_OPEN_INTERFACE_PKG
- show dependent code
FUN_RECON_RPT_PKG
- show dependent code
FUN_TRX_ENTRY_UTIL
- show dependent code
FUN_WEBADI_PKG
- show dependent code
FV_UTILITY
- show dependent code
GL_MC_INFO
- show dependent code
GMF_ALLOC_PROC
- show dependent code
IBY_DISBURSEMENT_COMP_PUB
- show dependent code
IBY_PAYINSTR_PUB
- show dependent code
INV_INVSTMVT_XMLP_PKG
- show dependent code
INV_MGD_MVT_FIN_MDTR
- show dependent code
INV_MGD_MVT_SETUP_MDTR
- show dependent code
INV_MGD_MVT_UTILS_PKG
- show dependent code
JAI_AP_UTILS_PKG
- show dependent code
JA_CN_POST_UTILITY_PKG
- show dependent code
JE_ES_WHTAX
- show dependent code
JE_ITWHYE_AP_PKG
- show dependent code
JE_ZZ_AUDIT_AP_PKG
- show dependent code
JG_RX_IR_PKG
- show dependent code
JG_ZZ_AUDIT_GL_PKG
- show dependent code
JG_ZZ_PTCE_DT_PKG
- show dependent code
JG_ZZ_RTCE_DT_PKG
- show dependent code
JG_ZZ_RTCE_DT_PKG
- show dependent code
JG_ZZ_VAT_SELECTION_PKG
- show dependent code
JL_BR_AP_VALIDATE_COLLECTION
- show dependent code
JL_BR_AR_LOG_VALIDATION
- show dependent code
JL_BR_SPED_DATA_EXTRACT_PKG
- show dependent code
JL_BR_WORKDAY_CALENDAR
- show dependent code
JL_JLBRRCAD_XMLP_PKG
- show dependent code
JL_ZZ_AP_LIBRARY_1_PKG
- show dependent code
XTR_AP_OPEN_APLD_TRX_V
XTR_AP_OPEN_TRX_V
XTR_AP_ORIG_TRX_V
XTR_AR_OPEN_APLD_TRX_V
XTR_AR_OPEN_TRX_V
XTR_AR_ORIG_TRX_V
XTR_BIS_CASHFLOWS_V
XTR_CASH_FCST
- show dependent code
XTR_FPS2_P
- show dependent code
XTR_HEDGE_PROCESS_P
- show dependent code
XTR_ONC_ELIGIBLE_DEALS_V
ZX_EXEMPTIONS_V
ZX_EXTRACT_PKG
- show dependent code
ZX_PTP_MIGRATE_PKG
- show dependent code
ZX_ZXAPJAJL_XMLP_PKG
- show dependent code
ZX_ZXARRECV_XMLP_PKG
- show dependent code
ZX_ZXXATB_XMLP_PKG
- show dependent code
|
|
|
|