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


VIEW: APPS.GL_LOOKUPS

Object Details
Object Name: GL_LOOKUPS
Object Type: VIEW
Owner: APPS
FND Design Data: ViewSQLGL.GL_LOOKUPS
Subobject Name:
Status: VALID

View Type

MultiLingual view (a language resolved view of the data.)

[View Source]

Columns
Name Datatype Length Mandatory Comments
LOOKUP_TYPE VARCHAR2 (30) Yes
LOOKUP_CODE VARCHAR2 (30) Yes
MEANING VARCHAR2 (80) Yes
DESCRIPTION VARCHAR2 (240)
ENABLED_FLAG VARCHAR2 (1) Yes
START_DATE_ACTIVE DATE

END_DATE_ACTIVE DATE

Query Text

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


SELECT LOOKUP_TYPE
,      LOOKUP_CODE
,      MEANING
,      DESCRIPTION
,      ENABLED_FLAG
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
FROM APPS.GL_LOOKUPS;

Dependencies

[top of page]

APPS.GL_LOOKUPS references the following:

SchemaAPPS
SynonymFND_LOOKUP_VALUES
APPS.GL_LOOKUPS is referenced by following:

SchemaAPPS
ViewAP_ENC_GL_INV_V
Package BodyAP_FUNDS_CONTROL_PKG - show dependent code
ViewAR_POSTED_TRANSACTIONS_V
ViewCE_101_RECONCILED_V
ViewCE_101_TRANSACTIONS_V
PL/SQL PackageCN_ACC_PERIODS_PVT - show dependent code
Package BodyCN_ACC_PERIODS_PVT - show dependent code
ViewCN_PERIODS
ViewCN_PERIODS_ALL_V
ViewGLBV_ACTUAL_BALANCES
ViewGLBV_BUDGET_BALANCES
ViewGLBV_GL_AVERAGE_BALANCES
ViewGLBV_GL_PERIOD_EXCHANGE_RATES
ViewGLBV_GL_STANDARD_BALANCES
ViewGLFV_ACTUAL_BALANCES
ViewGLFV_BUDGET_BALANCES
ViewGLFV_GL_AVERAGE_BALANCES
ViewGLFV_GL_PERIOD_EXCHANGE_RATES
ViewGLFV_GL_STANDARD_BALANCES
Package BodyGLR03300_PKG - show dependent code
ViewGL_ALLOC_FORMULA_LINES_V
ViewGL_ALL_BUD_ORGS_VIEW
ViewGL_ALL_ENC_TYPES_VIEW
ViewGL_ALL_JE_SOURCE_NAME_VIEW
ViewGL_ALL_PERIOD_NAME_VIEW
Package BodyGL_AS_POST_UPG_CHK_PKG - show dependent code
ViewGL_AUTOMATIC_POSTING_OPTIONS_V
ViewGL_AUTO_ALLOC_BATCHES_V
ViewGL_AUTO_ALLOC_BATCH_HISTORY_V
Package BodyGL_AUTO_ALLOC_BATCH_PKG - show dependent code
ViewGL_AUTO_ALLOC_SET_HISTORY_V
ViewGL_BC_OPTION_DETAILS_V
ViewGL_BC_PACKETS_V
ViewGL_BUDGETS_V
ViewGL_BUDGET_ASSIGNMENT_RANGES_V
ViewGL_BUDGET_DEP_BALANCES_V
Package BodyGL_BUDGET_ENTITIES_PKG - show dependent code
ViewGL_BUDGET_JOURNALS_V
Package BodyGL_BUDGET_UTILS_PKG - show dependent code
Package BodyGL_BUDORG_BC_OPTIONS_PKG - show dependent code
ViewGL_BUDORG_BC_OPTIONS_V
Package BodyGL_BUD_ASSIGN_RANGE_PKG - show dependent code
ViewGL_CODE_COMBINATIONS_V
Package BodyGL_CONC_CONTROL_PKG - show dependent code
ViewGL_CONS_BUDGET_PERIODS_V
ViewGL_CONS_SEGMENT_MAP_V
ViewGL_CONS_SET_ASSIGNMENTS_V
ViewGL_CONS_SET_NAMES_V
Package BodyGL_ENCUMBRANCE_TYPES_PKG - show dependent code
ViewGL_ENTERED_CURRENCIES_V
Package BodyGL_FEEDER_INFO_PKG - show dependent code
Package BodyGL_GLXBOR_XMLP_PKG - show dependent code
Package BodyGL_GLXRLBOL_XMLP_PKG - show dependent code
Package BodyGL_HISTORICAL_RATES_PKG - show dependent code
ViewGL_HISTORICAL_RATES_USAGE_V
Package BodyGL_INFO - show dependent code
ViewGL_JE_BATCHES_V
ViewGL_JE_HEADERS_REVERSE_V
Package BodyGL_JE_LINES_PKG - show dependent code
ViewGL_LOOKUPS_AMOUNT_TYPES_V
ViewGL_LOOKUPS_AVG_AMOUNT_TYPES_V
ViewGL_LOOKUPS_BATCH_TYPE_V
ViewGL_LOOKUPS_BOUNDARIES_V
ViewGL_LOOKUPS_BUDGET_INQ1_V
ViewGL_LOOKUPS_BUDGET_INQ3_V
ViewGL_LOOKUPS_BUDGET_STATUSES_V
ViewGL_LOOKUPS_FACTORS_V
ViewGL_LOOKUPS_MJE_BATCH_STATUS_V
ViewGL_LOOKUPS_MJE_FUNDS_STATUS_V
ViewGL_LOOKUPS_PERIOD_STATUSES_V
ViewGL_LOOKUPS_RATE_TYPE_V
ViewGL_LOOKUPS_YES_NO_V
ViewGL_SRS_CLVAL_PERIOD_SET_V
ViewGL_SRS_GLRTB2_ABE_START_PERIOD
ViewGL_SRS_GLRTB2_START_PERIOD
ViewGL_SRS_LEDGER_BUD_ENCUM_NAME
ViewGL_SRS_RECON_CURRENCIES_V
ViewGL_STORAGE_PARAMETERS_QF_V
ViewGL_STORAGE_PARAMETERS_V
Package BodyGL_SUMMARY_BC_OPTIONS_PKG - show dependent code
ViewGL_TAX_CODES_V
Package BodyGL_WEB_PLSQL_CARTRIDGE - show dependent code
ViewIGC_CBC_ALL_BAL_V
ViewIGC_CBC_DETAIL_BAL_V
ViewIGC_CBC_DR_V
ViewIGC_CBC_JE_BATCHES_V
ViewIGC_CBC_JE_LINES_V
ViewIGC_CBC_SUMMARY_BAL_V
Package BodyIGC_UPGRADE_DATA_R12 - show dependent code
ViewIGI_BUD_CODE_COMBINATIONS_V
Package BodyIGI_ITR_FUNDS_CONTROL_PKG - show dependent code
Package BodyJG_INFO - show dependent code
Package BodyJG_JGZZGLJRB_XMLP_PKG - show dependent code
Package BodyJG_JGZZGLJRN_XMLP_PKG - show dependent code
ViewJG_ZZ_ENTERED_CURRENCIES_V
ViewJG_ZZ_SRS_LEDGER_BUD_ENCUM_V
ViewJG_ZZ_TA_RULE_SETS_V
Package BodyJL_JGZZGLTRB_XMLP_PKG - show dependent code
Package BodyJL_JLCLGCAL_XMLP_PKG - show dependent code
Package BodyPA_FCST_GLOBAL - show dependent code
ViewPA_FCST_PERIODS_TMP_V
Package BodyPA_GL_AUTOALLOC_PKG - show dependent code
ViewPA_GL_SET_OF_BOOKS_V
ViewPA_ORGFCST_PERIODS_TMP_V
Package BodyPA_RATE_PVT_PKG - show dependent code
Package BodyPA_REPORT_UTIL - show dependent code
ViewPA_REP_PERIODS_V
ViewPA_REP_PERIOD_DATES_V
Package BodyPN_REC_EXP_EXTR_FROM_GL_PKG - show dependent code
PL/SQL PackagePN_REC_EXP_EXTR_FROM_GL_PKG - show dependent code
Package BodyPO_ENCUMBRANCE_POSTPROCESSING - show dependent code
Package BodyPO_FUNDS_CHECKER - show dependent code
Package BodyPQH_COMMITMENT_POSTING - show dependent code
Package BodyPQH_GL_POSTING - show dependent code
Package BodyPSA_AP_BC_PVT - show dependent code
Package BodyPSA_BC_XML_REPORT_PUB - show dependent code
Package BodyPSA_FUNDS_CHECKER_PKG - show dependent code
ViewRG_DSS_REQUESTS_V
ViewRG_DSS_VARIABLES_V
ViewRG_DSS_VAR_DIMENSIONS_V
ViewRG_SRS_DSS_BUD_ENC_V
ViewRG_SRS_DSS_DOP_V
ViewRG_SRS_DSS_HIERARCHIES_V
ViewRG_SRS_DSS_TEMPLATE_V