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


VIEW: APPS.FND_APPLICATION_VL

Object Details
Object Name: FND_APPLICATION_VL
Object Type: VIEW
Owner: APPS
FND Design Data: ViewFND.FND_APPLICATION_VL
Subobject Name:
Status: VALID

View Type

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


FND_APPLICATION_VL is a view that joins the translated, language
specific values from FND_APPLICATION_TL with the non-displayed
data from FND_APPLICATION to form complete application
entities. Oracle Application Object Library uses this view
to display information in languages installed at your
site.


[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Row identifier
APPLICATION_ID NUMBER
Yes Application identifier
APPLICATION_SHORT_NAME VARCHAR2 (50) Yes Application short name
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
CREATED_BY NUMBER (15) Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
BASEPATH VARCHAR2 (20)
The variable that stores the directory path of the TOP directory for the application
APPLICATION_NAME VARCHAR2 (240) Yes Name of application
DESCRIPTION VARCHAR2 (240)
Description
PRODUCT_CODE VARCHAR2 (50)
Product Code
Query Text

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


SELECT ROW_ID
,      APPLICATION_ID
,      APPLICATION_SHORT_NAME
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      BASEPATH
,      APPLICATION_NAME
,      DESCRIPTION
,      PRODUCT_CODE
FROM APPS.FND_APPLICATION_VL;

Dependencies

[top of page]

APPS.FND_APPLICATION_VL references the following:

SchemaAPPS
SynonymFND_APPLICATION
SynonymFND_APPLICATION_TL
APPS.FND_APPLICATION_VL is referenced by following:

SchemaAPPLSYSPUB
SynonymFND_APPLICATION_VL
SchemaAPPS
ViewAK_AM_PARAMETER_REGISTRY_V
ViewAK_ATTRIBUTES_VL
ViewAK_CUSTOMIZATIONS_VL
ViewAK_CUSTOM_REGIONS_VL
ViewAK_CUSTOM_REGION_ITEMS_VL
Package BodyAK_DOWNLOAD_GRP - show dependent code
ViewAK_FLOWS_VL
ViewAK_FOREIGN_KEY_COLUMNS_V
ViewAK_OBJECTS_VL
ViewAK_OBJECT_ATTRIBUTES_VL
Package BodyAK_ON_OBJECTS_PVT - show dependent code
ViewAK_QUERY_OBJECTS_V
ViewAK_REGIONS_VL
ViewAK_UNIQUE_KEY_COLUMNS_V
ViewALR_INSTALLATIONS_VIEW
Package BodyAME_ADMIN_PKG - show dependent code
Package BodyAME_APPROVER_DEVIATION_PKG - show dependent code
Package BodyAME_APPROVER_TYPE_PKG - show dependent code
Package BodyAME_CALLING_APPS_API - show dependent code
Package BodyAME_CONFIG_VARS_API - show dependent code
Package BodyAME_RULE_USAGES_API - show dependent code
Package BodyAME_RULE_USAGES_API2 - show dependent code
Package BodyAMS_UTILITY_PVT - show dependent code
Package BodyAR_ARBRATBR_XMLP_PKG - show dependent code
Package BodyAR_ARBRRMBM_XMLP_PKG - show dependent code
ViewAR_CMGT_DATA_POINTS_VL
Package BodyAR_CREATE_ACCTING_SRS - show dependent code
Package BodyASO_UTILITY_PVT - show dependent code
Package BodyAS_FOUNDATION_PVT - show dependent code
Package BodyAS_UTILITY_PVT - show dependent code
Package BodyAZW_GROUP - show dependent code
Package BodyAZW_PROC - show dependent code
Package BodyAZW_REPORT - show dependent code
Package BodyAZW_UTIL - show dependent code
ViewAZ_GROUPS_V
ViewAZ_PRODUCT_PHASES_V
ViewBIS_FLEX_FIELDS_V
Package BodyBOM_CSTRPDSS_XMLP_PKG - show dependent code
Package BodyBOM_CSTRPMDD_XMLP_PKG - show dependent code
Package BodyBOM_CSTRPWDD_XMLP_PKG - show dependent code
Package BodyCLN_NP_PROCESSOR_PKG - show dependent code
ViewCSC_PLAN_ENABLE_SETUP_V
Package BodyCSI_TRANSACTIONS_PVT - show dependent code
ViewEGO_ITMATTR_APPL_USGS_V
Package BodyFND_CONC - show dependent code
Package BodyFND_CONCURRENT - show dependent code
ViewFND_DATA_GROUP_UNITS_V
Package BodyFND_DFLEX - show dependent code
Package BodyFND_DIAG_REQUEST_ANALYZER - show dependent code
ViewFND_EXECUTABLES_FORM_V
ViewFND_FLEX_CONC_PARAM_VSET_V
ViewFND_FLEX_CP_PARAM_VSET_V
ViewFND_FLEX_CROSS_VALIDATION_V
ViewFND_FLEX_DESCR_SEG_VSET_V
ViewFND_FLEX_DFF_SEG_VSET_V
Package BodyFND_FLEX_DIAGNOSE - show dependent code
ViewFND_FLEX_KEY_SEG_VSET_V
ViewFND_FLEX_KFF_SEG_VSET_V
Package BodyFND_FLEX_SERVER - show dependent code
ViewFND_FLEX_SHORTHAND_ALIAS_V
Package BodyFND_FLEX_UPGRADE_UTILITIES - show dependent code
Package BodyFND_GLOBAL - show dependent code
Package BodyFND_OAM_CPCHARTS_COL - show dependent code
Package BodyFND_OAM_EM - show dependent code
Package BodyFND_OAM_KBF_SUBS - show dependent code
Package BodyFND_PLSQL_CACHE - show dependent code
Package BodyFND_REQUEST - show dependent code
ViewFND_REQ_SET_RUN_FORM_V
ViewFND_REQ_SET_STAGES_FORM_V
Package BodyFND_SEC_BULK - show dependent code
Package BodyFUN_RULE_PUB - show dependent code
Package BodyFV_UTILITY - show dependent code
Package BodyHR_API_WF_EVENTS - show dependent code
ViewHR_DM_MIGRATIONS_V
ViewHR_DTR_APPLICATION_LIST_V
Package BodyHR_LOCATIONS_PKG - show dependent code
Package BodyHR_OWNER_DEFINITIONS_PKG - show dependent code
ViewHR_OWNER_DEFINITIONS_V
Package BodyHR_SECURITY_UTILS - show dependent code
Package BodyHXC_APPROVAL_REPORT_PKG - show dependent code
ViewIBC_CITEM_DOWNLOAD_V
Package BodyIBC_UTILITIES_PVT - show dependent code
Package BodyIBC_VALIDATE_PVT - show dependent code
Package BodyIBE_MSITE_RESP_MGR_PVT - show dependent code
Package BodyIBU_ORDER_CAPTURE - show dependent code
ViewIBY_EXT_FD_PPR_1_0_V
Package BodyICX_QUESTIONS_ADMIN - show dependent code
Package BodyICX_TAG - show dependent code
Package BodyIEX_STRATEGY_WF - show dependent code
Package BodyIEX_WRITEOFFOBJ_PUB - show dependent code
ViewIGI_EXP_AVAILABLE_TRX_V
ViewIGI_EXP_DUS_IN_TUS_V
ViewIGI_EXP_DUS_NOT_IN_TUS_V
ViewIGI_EXP_DUS_V
ViewIGI_EXP_DU_LINES_V
Package BodyIGI_SLS_SECURITY_PKG - show dependent code
ViewIGI_STP_PACKAGES_V
Package BodyINV_INVORGES_XMLP_PKG - show dependent code
Package BodyINV_INVRCWSR_XMLP_PKG - show dependent code
Package BodyINV_INVSTMVT_XMLP_PKG - show dependent code
Package BodyINV_LOT_SEL_ATTR - show dependent code
Package BodyINV_MWB_TREE - show dependent code
Package BodyINV_MWB_TREE1 - show dependent code
Package BodyJA_CN_FSG_XML_BANK_PKG - show dependent code
Package BodyJA_CN_FSG_XML_SUBMIT_PROG - show dependent code
Package BodyJE_JEFIASDR_XMLP_PKG - show dependent code
Package BodyJE_JENOGEIA_XMLP_PKG - show dependent code
Package BodyJE_JENOGEIM_XMLP_PKG - show dependent code
Package BodyJE_JENOGEIS_XMLP_PKG - show dependent code
Package BodyJTF_CTM_UTILITY_PVT - show dependent code
Package BodyJTF_DEBUG_PUB - show dependent code
Package BodyJTF_DIAGNOSTIC_COREAPI - show dependent code
ViewJTF_IH_ACTIVITIES_VL
ViewJTF_IH_ACTIVITIES_VL3
ViewJTF_IH_INTERACTIONS_ONLY_VL
ViewJTF_IH_INTERACTIONS_VL
ViewJTF_IH_INTERACTIONS_VL2
Package BodyJTF_MSITE_RESP_MGR_PVT - show dependent code
ViewJTF_OBJECTS_VL
ViewJTF_OBJECT_MAPPINGS_V
Package BodyJTF_PLSQL_API - show dependent code
Package BodyJTF_PREFAB_CACHE_PUB - show dependent code
PL/SQL PackageJTF_PREFAB_CACHE_PUB - show dependent code
ViewJTF_STATE_RULES_VL
Package BodyJTF_TASK_UTL - show dependent code
Package BodyMRP_CL_FUNCTION - show dependent code
Package BodyMRP_CL_REFRESH_SNAPSHOT - show dependent code
Package BodyMRP_MSC_EXP_WF - show dependent code
Package BodyMRP_REL_WF - show dependent code
Package BodyMSC_CL_CONT_COLL_FW - show dependent code
Package BodyMSC_CL_COPY_STG_TBL - show dependent code
Package BodyMSC_CL_PULL - show dependent code
Package BodyMSC_REL_PLAN_PUB - show dependent code
Package BodyMSC_REL_WF - show dependent code
Package BodyMSC_X_VMI_POREQ - show dependent code
ViewMSD_AUDIT_SQL_STATEMENTS_V
Package BodyMSD_DEM_COMMON_UTILITIES - show dependent code
Package BodyMSD_VALIDATE - show dependent code
Package BodyOE_SHIPPING_WF - show dependent code
ViewOKC_BUS_VARIABLES_SEARCH_V
Package BodyOKC_QCL_PVT - show dependent code
ViewOKC_RULE_DEFS_V
Package BodyOKC_UTIL - show dependent code
ViewOKE_TERMS_V
Package BodyOKL_CONTRACT_LINE_ITEM_PVT - show dependent code
Package BodyOKL_CONTRACT_STATUS_PVT - show dependent code
Package BodyOKL_CONVERT_INT_TYPE_WF - show dependent code
ViewOKL_CS_INTERACTIONS_PARTY_UV
Package BodyOKL_CS_WF - show dependent code
Package BodyOKL_CURE_RECON_PVT - show dependent code
Package BodyOKL_CURE_WF - show dependent code
Package BodyOKL_PAY_CURE_REFUNDS_PVT - show dependent code
Package BodyOKL_REPORT_GENERATOR_PVT - show dependent code
ViewORG_ACCESS_V
Package BodyPAY_CORE_XDO_UTILS - show dependent code
Package BodyPAY_MX_TRR_PKG - show dependent code
Package BodyPAY_PAYGTN_PKG - show dependent code
Package BodyPER_DATA_UPDATE_REPORT - show dependent code
Package BodyPER_RI_CONFIG_TECH_SUMMARY - show dependent code
Package BodyPER_RI_CONFIG_UTILITIES - show dependent code
ViewPER_SEC_PROFILE_ASSIGNMENTS_V
ViewPQH_COPY_ENTITY_CONTEXTS_V
Package BodyPSA_UTILS - show dependent code
ViewQPR_SR_OM_QUOTE_ADJS_V
ViewQPR_SR_OM_QUOTE_COST_V
ViewQPR_SR_OM_QUOTE_HEADERS_V
ViewQPR_SR_OM_QUOTE_LINES_V
ViewQPR_SR_QUOTE_ADJS_V
ViewQPR_SR_QUOTE_COST_V
ViewQPR_SR_QUOTE_HEADERS_V
ViewQPR_SR_QUOTE_LINES_V
ViewQPR_SR_QUOTE_LINE_NUM_V
Package BodyWMS_WMSCPTYR_XMLP_PKG - show dependent code
Package BodyWSH_FLEXFIELD_UTILS - show dependent code
Package BodyWSH_ITM_OVERRIDE - show dependent code
ViewWSH_ITM_SERVICE_PREFERENCES_V
ViewWSH_ITM_USER_SETUPS_V
Package BodyWSH_WSHRDIST_XMLP_PKG - show dependent code
Package BodyXLA_AAD_LOADER_UTIL_PVT - show dependent code
Package BodyXLA_AAD_UPLOAD_PVT - show dependent code
Package BodyXLA_ACCOUNTING_CACHE_PKG - show dependent code
Package BodyXLA_AE_CODE_COMBINATION_PKG - show dependent code
Package BodyXLA_AE_LINES_PKG - show dependent code
ViewXLA_APPLICATIONS_XVL
Package BodyXLA_CMP_COMMON_PKG - show dependent code
Package BodyXLA_CONDITIONS_PKG - show dependent code
Package BodyXLA_FLEX_UTIL - show dependent code
Package BodyXLA_JE_VALIDATION_PKG - show dependent code
ViewXLA_POST_ACCT_PROGS_F_V
Package BodyXLA_SECURITY_PKG - show dependent code
ViewXLA_SUBLEDGERS_FVL
Package BodyXLA_THIRD_PARTY_MERGE - show dependent code
Package BodyXLA_UPGRADE_PUB - show dependent code
Package BodyXLA_VALIDATIONS_PKG - show dependent code
Package BodyXLA_XLAALEXP_XMLP_PKG - show dependent code
ViewZX_SIM_RULES_V
ViewZX_TRANSACTIONS_V