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

VIEW: APPS.AMW_AUDIT_UNITS_V_ALL

Object Details
Object Name: AMW_AUDIT_UNITS_V_ALL
Object Type: VIEW
Owner: APPS
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_ALL;

Dependencies

[top of page]

APPS.AMW_AUDIT_UNITS_V_ALL references the following:

SchemaAPPS
ViewFND_FLEX_VALUES_VL
PL/SQL PackageFND_GLOBAL - show dependent code
SynonymHR_ALL_ORGANIZATION_UNITS
SynonymHR_ALL_ORGANIZATION_UNITS_TL
PL/SQL PackageHR_API - show dependent code
ViewHR_LOOKUPS
SynonymHR_ORGANIZATION_INFORMATION

APPS.AMW_AUDIT_UNITS_V_ALL is not referenced by any database object