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


VIEW: APPS.ORG_ACCESS_VIEW

Object Details
Object Name: ORG_ACCESS_VIEW
Object Type: VIEW
Owner: APPS
FND Design Data: ViewINV.ORG_ACCESS_VIEW
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
ORGANIZATION_ID NUMBER (15) Yes Organization unique identifier
RESPONSIBILITY_ID NUMBER (15) Yes Application responsibility unique identifier
RESP_APPLICATION_ID NUMBER (15) Yes Application unique identifier
ORGANIZATION_CODE VARCHAR2 (3)
Organization code
ORGANIZATION_NAME VARCHAR2 (240) Yes Organization name
BUSINESS_GROUP_ID NUMBER (15) Yes Business group identifier
SET_OF_BOOKS_ID NUMBER (15) Yes Set of books identifier
CHART_OF_ACCOUNTS_ID NUMBER (15) Yes Chart of accounts identifier
INVENTORY_ENABLED_FLAG VARCHAR2 (150)
Flag to indicate if the org is enabled in Inventory
Query Text

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


SELECT ORGANIZATION_ID
,      RESPONSIBILITY_ID
,      RESP_APPLICATION_ID
,      ORGANIZATION_CODE
,      ORGANIZATION_NAME
,      BUSINESS_GROUP_ID
,      SET_OF_BOOKS_ID
,      CHART_OF_ACCOUNTS_ID
,      INVENTORY_ENABLED_FLAG
FROM APPS.ORG_ACCESS_VIEW;

Dependencies

[top of page]

APPS.ORG_ACCESS_VIEW references the following:

SchemaAPPS
SynonymFND_RESPONSIBILITY
ViewGL_SETS_OF_BOOKS
SynonymHR_ALL_ORGANIZATION_UNITS
SynonymHR_ALL_ORGANIZATION_UNITS_TL
PL/SQL PackageHR_GENERAL - show dependent code
SynonymHR_ORGANIZATION_INFORMATION
PL/SQL PackageHR_SECURITY - show dependent code
SynonymMTL_PARAMETERS
SynonymORG_ACCESS
APPS.ORG_ACCESS_VIEW is referenced by following:

SchemaAPPS
Package BodyAZW_PROC - show dependent code
Package BodyBOMPCMBM - show dependent code
Package BodyBOMPIINQ - show dependent code
Package BodyBOM_BOMRASSY_XMLP_PKG - show dependent code
Package BodyBOM_BOMRBOMS_XMLP_PKG - show dependent code
Package BodyBOM_BOMRWUIT_XMLP_PKG - show dependent code
Package BodyBOM_COPY_BILL - show dependent code
Package BodyBOM_DELETE_ENTITY - show dependent code
Package BodyBOM_IMPLODER_PUB - show dependent code
Package BodyEAM_COMMON_UTILITIES_PVT - show dependent code
Package BodyEAM_LINEAR_LOCATIONS_PUB - show dependent code
Package BodyEAM_WORKORDER_UTIL_PKG - show dependent code
Package BodyEGO_ITEM_ASSOCIATIONS_PUB - show dependent code
Package BodyEGO_ITEM_LC_IMP_PC_PUB - show dependent code
Package BodyENG_ENGRCNDR_XMLP_PKG - show dependent code
Package BodyGMD_API_GRP - show dependent code
Package BodyGMD_COMMON_VAL - show dependent code
Package BodyGMD_FORMULA_ANALYSIS - show dependent code
Package BodyGMD_FORMULA_IBOM - show dependent code
Package BodyGMD_ITEM_TECHNICAL_DATA_PUB - show dependent code
Package BodyGMD_RECIPE_FETCH_PUB - show dependent code
Package BodyGMD_RECIPE_VAL - show dependent code
Package BodyGMD_RESULTS_PUB - show dependent code
Package BodyGMD_SAMPLES_GRP - show dependent code
Package BodyGMD_SPEC_GRP - show dependent code
Package BodyGMO_DOCUMENT_NUMBERS_PVT - show dependent code
Package BodyGMO_UTILITIES - show dependent code
Package BodyINV_EGO_REVISION_VALIDATE - show dependent code
Package BodyINV_TRANSACTION_LOVS - show dependent code
ViewWMS_ACCESS_RULES_LOV_V