[Home] [Help] [Dependency Information]
Object Name: | AMW_AUDIT_UNITS_V_ALL |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
This view returns information about Audit Units
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 |
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_ALL;
APPS.AMW_AUDIT_UNITS_V_ALL is not referenced by any database object
|
|
|