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


VIEW: APPS.FND_USER_VIEW

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

View Type

A public view which may be useful for custom reporting or other data
requirements.


This view is obsolete and should not be referenced by new code. It remains in the datamodel until all references to it can be removed.


[View Source]

Columns
Name Datatype Length Mandatory Comments
USER_ID NUMBER (15) Yes Application user identifier
USER_NAME VARCHAR2 (100) Yes Application username (what a user types in at the Oracle Applications sign-on screen)
ENCRYPTED_FOUNDATION_PASSWORD VARCHAR2 (100) Yes The Oracle Application Object Library encrypted password used to connect to database.
START_DATE DATE
Yes The date the password becomes active.
END_DATE DATE

The date the password expires.
Query Text

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


SELECT USER_ID
,      USER_NAME
,      ENCRYPTED_FOUNDATION_PASSWORD
,      START_DATE
,      END_DATE
FROM APPS.FND_USER_VIEW;

Dependencies

[top of page]

APPS.FND_USER_VIEW references the following:

SchemaAPPS
SynonymFND_USER
APPS.FND_USER_VIEW is referenced by following:

SchemaAPPS
ViewBEN_ACTL_PREM_D
ViewBEN_ACTY_RT_PYMT_SCHED_D
ViewBEN_BNFT_POOL_RLOVR_RQMT_D
ViewBEN_BNFT_PRVDR_POOL_D
ViewBEN_CBR_QUALD_BNF_RT_D
ViewBEN_CNTNG_PRTN_PRFL_RT_D
ViewBEN_COMPTNCY_RT_D
ViewBEN_CVRD_DPNT_CTFN_PRVDD_D
ViewBEN_ELIG_ANTHR_PL_PRTE_D
ViewBEN_ELIG_COMPTNCY_PRTE_D
ViewBEN_ELIG_CVRD_DPNT_D
ViewBEN_ELIG_DSBLD_PRTE_D
ViewBEN_ELIG_HLTH_CVG_PRTE_D
ViewBEN_ELIG_PERF_RTNG_PRTE_D
ViewBEN_ELIG_QUA_IN_GR_PRTE_D
ViewBEN_ELIG_TBCO_USE_PRTE_D
ViewBEN_ELIG_TTL_CVG_VOL_PRTE_D
ViewBEN_ELIG_TTL_PRTT_PRTE_D
ViewBEN_JOB_RT_D
ViewBEN_LEE_RSN_RL_D
ViewBEN_LVG_RSN_RT_D
ViewBEN_OIPLIP_D
ViewBEN_OPTD_MDCR_RT_D
ViewBEN_PERF_RTNG_RT_D
ViewBEN_PER_CM_D
ViewBEN_PER_CM_PRVDD_D
ViewBEN_PER_CM_TRGR_D
ViewBEN_PER_INFO_CHG_CS_LER_D
ViewBEN_PL_BNF_CTFN_D
ViewBEN_PL_BNF_CTFN_PRVDD_D
ViewBEN_PL_REGY_PRP_D
ViewBEN_PL_R_OIPL_PREM_BY_MO_D
ViewBEN_PL_TYP_OPT_TYP_D
ViewBEN_POPL_ORG_ROLE_D
ViewBEN_PREM_CSTG_BY_SGMT_D
ViewBEN_PRMRY_CARE_PRVDR_D
ViewBEN_PRTT_PREM_BY_MO_D
ViewBEN_PRTT_PREM_D
ViewBEN_PTD_LMT_D
ViewBEN_QUAL_TITL_RT_D
ViewBEN_QUA_IN_GR_RT_D
ViewBEN_RLTD_PER_CHG_CS_LER_D
ViewBEN_TTL_CVG_VOL_RT_D
ViewHXT_SHIFTS_D
ViewHXT_SUM_HOURS_WORKED_D
ViewHXT_SUM_HOURS_WORKED_FMV
ViewHXT_TIMECARDS_D
Package BodyOKC_ARTWF_PVT - show dependent code
Package BodyOKC_CGP_PVT - show dependent code
Package BodyOKC_CHANGE_CONTRACT_PVT - show dependent code
Package BodyOKC_CPS_PVT - show dependent code
Package BodyOKC_CRT_PVT - show dependent code
ViewPER_ASSIGNMENT_BUDGET_VALUES_D
Package BodyPER_SEU_BUS - show dependent code
ViewPQP_ASSIGNMENT_ATTRIBUTES_D
ViewQA_RESULTS_FULL_V
ViewQA_RESULTS_QWB_V
ViewQA_RESULTS_V
Package BodyQA_SOLUTION_DISPOSITION_PKG - show dependent code
Package BodyQLTTRAWB - show dependent code
Package BodyQP_DEALS_UTIL - show dependent code
Package BodyWIP_JOB_DTLS_VALIDATIONS - show dependent code
Package BodyZX_TEST_API - show dependent code