[Home] [Help]
[Dependency Information]
VIEW: APPS.AMW_AUDIT_UNITS_V
Object Details
Object Name: | AMW_AUDIT_UNITS_V |
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | AMW.AMW_AUDIT_UNITS_V
|
---|
Subobject Name: | |
Status: | VALID |
View Type
A public view which may be useful for custom reporting or other data
requirements.
This view returns information about Audit Units
[View Source]
Columns
Name |
Datatype |
Length |
Mandatory |
Comments |
BUSINESS_GROUP_ID |
NUMBER |
(15) |
Yes |
Business Group Identifier |
ORGANIZATION_ID |
NUMBER |
(15) |
Yes |
Organization Identifier |
NAME |
VARCHAR2 |
(240) |
Yes |
Audit Unit Name |
DATE_FROM |
DATE |
|
Yes |
Audit Unit Date Effectivity Start Date |
DATE_TO |
DATE |
|
|
Audit Unit Date Effectivity End Date |
LOB_CODE |
VARCHAR2 |
(150) |
|
Line of Business Code |
LOB_DESCRIPTION |
VARCHAR2 |
(240) |
|
Line of Business Description |
COMPANY_CODE |
VARCHAR2 |
(150) |
|
Company Code |
COMPANY |
VARCHAR2 |
(240) |
|
Company Name |
SUBSIDIARY_VALUESET |
VARCHAR2 |
(150) |
|
Subsidiary Valueset Identifier |
LOB_VALUESET |
VARCHAR2 |
(150) |
|
Line of Business Valueset Identifier |
LOCATION_ID |
NUMBER |
(15) |
|
Audit Unit Location Identifier |
ORG_TYPE |
VARCHAR2 |
(80) |
|
Organization Classification Type |
Query Text
Cut, paste (and edit) the following text to query this object:
SELECT BUSINESS_GROUP_ID
, ORGANIZATION_ID
, NAME
, DATE_FROM
, DATE_TO
, LOB_CODE
, LOB_DESCRIPTION
, COMPANY_CODE
, COMPANY
, SUBSIDIARY_VALUESET
, LOB_VALUESET
, LOCATION_ID
, ORG_TYPE
FROM APPS.AMW_AUDIT_UNITS_V;
Dependencies
[top of page]
APPS.AMW_AUDIT_UNITS_V references the following:
-
APPS
-
FND_FLEX_VALUES_VL
-
FND_GLOBAL
- show dependent code
-
HR_ALL_ORGANIZATION_UNITS
-
HR_ALL_ORGANIZATION_UNITS_TL
-
HR_API
- show dependent code
-
HR_LOOKUPS
-
HR_ORGANIZATION_INFORMATION
APPS.AMW_AUDIT_UNITS_V is referenced by following:
-
APPS
-
AMW_CUSTOM_HIER_V
-
AMW_EXPORT_AUDIT_PROCEDURE_V
-
AMW_FINSTMT_CERT_BES_PKG
- show dependent code
-
AMW_FINSTMT_CERT_PVT
- show dependent code
-
AMW_LEGAL_HIER_V
-
AMW_LOAD_AUDIT_PROCEDURE_DATA
- show dependent code
-
AMW_MANAG_HIER_V
-
AMW_ORG_HIERARCHY_PKG
- show dependent code
-
AMW_ORG_HIERARCHY_PKG
- show dependent code
-
AMW_PARAMETERS_PVT_PKG
- show dependent code
-
AMW_PROCESS_CERT_SCOPE_PVT
- show dependent code
-
AMW_PROCESS_CERT_SUMMARY
- show dependent code
-
AMW_PROCESS_ORG_BASICINFO_V
-
AMW_PROJECT_EVENT_PVT
- show dependent code
-
AMW_SCOPE_PVT
- show dependent code
-
AMW_UTILITY_PVT
- show dependent code
-
AMW_WF_HIERARCHY_PKG
- show dependent code
-
RCI_ORG_AUDIT_V
-
RCI_ORG_CERT_ETL_PKG
- show dependent code
-
RCI_ORG_CERT_ETL_PKG
- show dependent code
-
RCI_ORG_DFCY_ETL_PKG
- show dependent code
-
RCI_PROC_DETAIL_ETL_PKG
- show dependent code
-
RCI_UNMTG_RISKS_ETL_PKG
- show dependent code