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


VIEW: APPS.FND_RESPONSIBILITY_VL

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

View Type

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


FND_RESPONSIBILITY_VL is a view that joins the translated, language
specific values from FND_RESPONSIBILITY_TL with the non-displayed
data from FND_RESPONSIBILITY to form complete responsibility
entities. Oracle Application Object Library uses this view to
display information in languages installed at you site.


[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Row identifier
WEB_HOST_NAME VARCHAR2 (80)
IP address or alias of machine where the Webserver is running. Defaults to the last agent
WEB_AGENT_NAME VARCHAR2 (80)
Name of Oracle Web Agent. Defaults to the last agent
APPLICATION_ID NUMBER (15) Yes Application identifier
RESPONSIBILITY_ID NUMBER (15) Yes Responsibility identifier
RESPONSIBILITY_KEY VARCHAR2 (30) Yes Internal developer name for responsibility
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
DATA_GROUP_APPLICATION_ID NUMBER (15) Yes Data group application identifier
DATA_GROUP_ID NUMBER (15) Yes Data group identifier
MENU_ID NUMBER (15) Yes Menu identifier of the main menu for the responsibility
START_DATE DATE
Yes The date the responsibility becomes active
END_DATE DATE

The date the responsibility expires
GROUP_APPLICATION_ID NUMBER (15)
Application identifier from report security group
REQUEST_GROUP_ID NUMBER (15)
Identifier of report security group assigned to the responsibility
VERSION VARCHAR2 (1)
Not currently used
RESPONSIBILITY_NAME VARCHAR2 (100) Yes Name of responsibility
DESCRIPTION VARCHAR2 (240)
Description
Query Text

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


SELECT ROW_ID
,      WEB_HOST_NAME
,      WEB_AGENT_NAME
,      APPLICATION_ID
,      RESPONSIBILITY_ID
,      RESPONSIBILITY_KEY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      DATA_GROUP_APPLICATION_ID
,      DATA_GROUP_ID
,      MENU_ID
,      START_DATE
,      END_DATE
,      GROUP_APPLICATION_ID
,      REQUEST_GROUP_ID
,      VERSION
,      RESPONSIBILITY_NAME
,      DESCRIPTION
FROM APPS.FND_RESPONSIBILITY_VL;

Dependencies

[top of page]

APPS.FND_RESPONSIBILITY_VL references the following:

SchemaAPPS
SynonymFND_RESPONSIBILITY
SynonymFND_RESPONSIBILITY_TL
APPS.FND_RESPONSIBILITY_VL is referenced by following:

SchemaAPPS
Package BodyAHL_PRD_LOV_SERVICE_PVT - show dependent code
Package BodyAHL_PRD_NONROUTINE_PUB - show dependent code
Package BodyAHL_PRD_WO_PUB - show dependent code
Package BodyAHL_VWP_RULES_PVT - show dependent code
Package BodyAHL_WORKORDER_SEARCH_PUB - show dependent code
Package BodyAME_APPROVER_TYPE_PKG - show dependent code
Package BodyAME_MIGRATION_PKG - show dependent code
Package BodyAME_UTIL - show dependent code
Package BodyAMW_FINDINGS_PKG - show dependent code
Package BodyAMW_LOAD_SOD_DATA - show dependent code
Package BodyAMW_VIOLATION_PVT - show dependent code
Package BodyAP_UTILITIES_PKG - show dependent code
Package BodyARI_SELF_REGISTRATION_PKG - show dependent code
ViewASG_RESPONSIBILITY_VL
Package BodyBIS_FND_MENUS_PUB - show dependent code
PL/SQL PackageBIS_GRAPH_REGION_HTML_FORMS - show dependent code
ViewBIS_INDICATOR_RESPS_V
Package BodyBIS_MEASURE_SECURITY_PVT - show dependent code
Package BodyBIS_RESPONSIBILITY_PUB - show dependent code
Package BodyBIS_RESPONSIBILITY_PVT - show dependent code
Package BodyBIS_RL_PKG - show dependent code
Package BodyBIS_UTILITIES_PUB - show dependent code
Package BodyBOM_CSTGMSBK_XMLP_PKG - show dependent code
Package BodyBOM_CSTRPDSS_XMLP_PKG - show dependent code
Package BodyBOM_CSTRPMDD_XMLP_PKG - show dependent code
Package BodyBOM_CSTRPWDD_XMLP_PKG - show dependent code
ViewBOM_STD_OP_RESP_EXCL_V
Package BodyBSC_CAUSE_EFFECT_UI_WRAPPER - show dependent code
Package BodyBSC_LAUNCH_PAD_PUB - show dependent code
Package BodyBSC_LAUNCH_PAD_PVT - show dependent code
ViewBSC_RESPONSIBILITY_VL
Package BodyBSC_UPGRADES - show dependent code
ViewBSC_USER_RESPONSIBILITY_V
Package BodyCCT_RESOURCE_ASSIGNMENT - show dependent code
PL/SQL PackageCN_CALC_SUBMISSION_PUB - show dependent code
Package BodyCN_CALC_SUBMISSION_PUB - show dependent code
Package BodyCN_USER_ACCESS_PVT - show dependent code
Package BodyCSC_PROF_MODULE_GROUPS_PVT - show dependent code
ViewCSC_PROF_MODULE_GROUPS_V
Package BodyCS_INCIDENTLINKS_UTIL - show dependent code
Package BodyDPP_ITEMCOST_PVT - show dependent code
Package BodyDPP_NOTIFICATION_PVT - show dependent code
Package BodyDPP_PURCHASEPRICE_PVT - show dependent code
ViewEDW_SEC_DIM_ACCESS_V
Package BodyEDW_SEC_REF - show dependent code
ViewFA_RX_NOCR_REPORTS_V
ViewFA_RX_REPORTS_V
Package BodyFND_FLEX_DIAGNOSE - show dependent code
Package BodyFND_FUNCTION_SECURITY - show dependent code
Package BodyFND_GLOBAL - show dependent code
Package BodyFND_OAM_CPCHARTS_COL - show dependent code
Package BodyFND_PLSQL_CACHE - show dependent code
Package BodyFND_PROFILE - show dependent code
Package BodyFND_SEC_BULK - show dependent code
Package BodyFV_UTILITY - show dependent code
Package BodyGMD_API_PUB - show dependent code
Package BodyHR_INTEGRATION_UTILS - show dependent code
Package BodyHR_SEC3_UPDATE - show dependent code
Package BodyHR_SECURITY_UTILS - show dependent code
Package BodyHR_USER_ACCT_INTERNAL - show dependent code
ViewHXC_RESOURCE_RULES_PERSON_V
Package BodyIBC_AUDIT_LOG_GRP - show dependent code
Package BodyIBE_MSITE_RESP_MGR_PVT - show dependent code
Package BodyIBE_MSITE_RESP_PVT - show dependent code
Package BodyICX_LOGIN - show dependent code
Package BodyICX_PORTLET - show dependent code
Package BodyICX_SEC - show dependent code
Package BodyIEX_COLLECTORS_TO_RESOURCE - show dependent code
Package BodyIGP_VW_GEN_002_PKG - show dependent code
ViewIGSFV_PERSON_HOLDS
ViewIGS_DA_CNFG_V
Package BodyIGS_GE_REPORT - show dependent code
Package BodyIGS_PE_GEN_003 - show dependent code
ViewIGS_PE_PERS_ENCUMB_V
Package BodyIGS_PS_VALIDATE_LGCY_PKG - show dependent code
Package BodyINV_DIAG_GRP - show dependent code
Package BodyINV_INVORGES_XMLP_PKG - show dependent code
Package BodyINV_INVRCWSR_XMLP_PKG - show dependent code
Package BodyINV_INVSTMVT_XMLP_PKG - show dependent code
ViewISC_MSC_BIS_ORGANIZATIONS_V
Package BodyJTF_MENU_PUB - show dependent code
PL/SQL PackageJTF_MENU_PUB - show dependent code
Package BodyJTF_MSITE_RESP_MGR_PVT - show dependent code
Package BodyJTF_MSITE_RESP_PVT - show dependent code
Package BodyJTF_RS_IMPORT_USER_PUB - show dependent code
Package BodyJTF_UM_ENROLLMENT_CREDENTIALS - show dependent code
PL/SQL PackageJTF_UM_RESP_INFO_PVT - show dependent code
Package BodyJTF_UM_RESP_INFO_PVT - show dependent code
Package BodyJTF_UM_USERTYPE_CREDENTIALS - show dependent code
Package BodyJTF_UM_WF_APPROVAL - show dependent code
Package BodyMRP_MSC_EXP_WF - show dependent code
Package BodyMRP_PO_RESCHEDULE - show dependent code
Package BodyMRP_REL_WF - show dependent code
Package BodyMSCX_UI_UTILITIES - show dependent code
Package BodyMSC_GET_PROFILE - show dependent code
Package BodyMSC_PROFILE_PRE_PROCESS - show dependent code
Package BodyMSC_REL_WF - show dependent code
Package BodyMSC_SCE_LOADS_PKG - show dependent code
Package BodyMSC_SECRULE_PKG - show dependent code
Package BodyMSC_X_VMI_POREQ - show dependent code
ViewMSD_DP_USERS_V
Package BodyOE_PC_CONSTRAINTS_ADMIN_PUB - show dependent code
ViewOE_PC_RESPS_V
Package BodyOE_SHIPPING_WF - show dependent code
Package BodyOKC_SRA_PVT - show dependent code
Package BodyOKS_AUTO_REMINDER - show dependent code
Package BodyORACLEAPPS - show dependent code
Package BodyORACLECONFIGURE - show dependent code
Package BodyORACLEMYPAGE - show dependent code
Package BodyORACLENAVIGATE - show dependent code
Package BodyORACLEPLUGS - show dependent code
ViewORG_ACCESS_V
Package BodyOZF_CLAIM_ACCRUAL_PVT - show dependent code
ViewPA_USER_RESP_V
Package BodyPER_EIT_UTILITY_SS - show dependent code
Package BodyPER_PEOPLE_INFO_TYPES_SEC_PKG - show dependent code
PL/SQL PackagePER_RI_CONFIG_TECH_SUMMARY - show dependent code
PL/SQL PackagePER_RI_CONFIG_UTILITIES - show dependent code
Package BodyPER_RI_CONFIG_UTILITIES - show dependent code
ViewPER_SEC_PROFILE_ASSIGNMENTS_V
Package BodyPORCPTWF - show dependent code
ViewPQH_COPY_ENTITY_CONTEXTS_V
Package BodyPV_ATTRIBUTE_PVT - show dependent code
Package BodyPV_CONTACT_USER_BATCH_PUB - show dependent code
Package BodyWIP_PREFERENCES_PKG - show dependent code
Package BodyWMS_WMSCPTYR_XMLP_PKG - show dependent code
Package BodyXDO_DGF_RPT_PKG - show dependent code
Package BodyZPB_AW_WRITE_BACK - show dependent code
Package BodyZPB_WF - show dependent code
Package BodyZPB_WF_NTF - show dependent code