[Home] [Help]
[Dependency Information]
| Object Name: | ORG_ACCESS_VIEW |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: | INV.ORG_ACCESS_VIEW
|
| Subobject Name: | |
| Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
| 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 |
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;
APPS
FND_RESPONSIBILITY
GL_SETS_OF_BOOKS
HR_ALL_ORGANIZATION_UNITS
HR_ALL_ORGANIZATION_UNITS_TL
HR_GENERAL
- show dependent code
HR_ORGANIZATION_INFORMATION
HR_SECURITY
- show dependent code
MTL_PARAMETERS
ORG_ACCESS
APPS
AZW_PROC
- show dependent code
BOMPCMBM
- show dependent code
BOMPIINQ
- show dependent code
BOM_BOMRASSY_XMLP_PKG
- show dependent code
BOM_BOMRBOMS_XMLP_PKG
- show dependent code
BOM_BOMRWUIT_XMLP_PKG
- show dependent code
BOM_COPY_BILL
- show dependent code
BOM_DELETE_ENTITY
- show dependent code
BOM_IMPLODER_PUB
- show dependent code
EAM_COMMON_UTILITIES_PVT
- show dependent code
EAM_LINEAR_LOCATIONS_PUB
- show dependent code
EAM_WORKORDER_UTIL_PKG
- show dependent code
EGO_ITEM_ASSOCIATIONS_PUB
- show dependent code
EGO_ITEM_LC_IMP_PC_PUB
- show dependent code
ENG_ENGRCNDR_XMLP_PKG
- show dependent code
GMD_API_GRP
- show dependent code
GMD_COMMON_VAL
- show dependent code
GMD_FORMULA_ANALYSIS
- show dependent code
GMD_FORMULA_IBOM
- show dependent code
GMD_ITEM_TECHNICAL_DATA_PUB
- show dependent code
GMD_RECIPE_FETCH_PUB
- show dependent code
GMD_RECIPE_VAL
- show dependent code
GMD_RESULTS_PUB
- show dependent code
GMD_SAMPLES_GRP
- show dependent code
GMD_SPEC_GRP
- show dependent code
GMO_DOCUMENT_NUMBERS_PVT
- show dependent code
GMO_UTILITIES
- show dependent code
INV_EGO_REVISION_VALIDATE
- show dependent code
INV_TRANSACTION_LOVS
- show dependent code
WMS_ACCESS_RULES_LOV_V
|
|
|
|