eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.AMW_EXPORT_AUDIT_PROCEDURE_V

Object Details

Object Name:	AMW_EXPORT_AUDIT_PROCEDURE_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	AMW.AMW_EXPORT_AUDIT_PROCEDURE_V
Subobject Name:
Status:	VALID

View Type

MultiLingual view (a language resolved view of the data.)

[View Source]

Columns

Name	Datatype	Length
APAID	NUMBER
APID	NUMBER
APRID	NUMBER
APJID	NUMBER
OID	NUMBER
CID	NUMBER
TID	NUMBER
APNM	VARCHAR2	(240)
TNM	VARCHAR2	(80)
TDES	VARCHAR2	(250)
ONM	VARCHAR2	(240)
APS	VARCHAR2	(80)
APWD	VARCHAR2	(4000)
APEB	NUMBER
APEO	DATE
APEID	NUMBER
APENM	VARCHAR2	(240)
CNM	VARCHAR2	(240)
CDES	VARCHAR2	(4000)
DEF	VARCHAR2	(240)
OEF	VARCHAR2	(240)
CAR	VARCHAR2	(240)
COID	NUMBER
PNM	VARCHAR2	(80)
PSD	DATE
SID	NUMBER
SS	VARCHAR2	(80)
SWD	VARCHAR2	(4000)
SEB	NUMBER
SEO	DATE
SEID	NUMBER
SENM	VARCHAR2	(240)
SNM	VARCHAR2	(240)
SDES	VARCHAR2	(4000)
SNUM	VARCHAR2	(240)
DSUM	VARCHAR2	(1500)
DDES	VARCHAR2	(3000)
OSUM	VARCHAR2	(1500)
ODES	VARCHAR2	(3000)
CSUM	VARCHAR2	(1500)
CODES	VARCHAR2	(3000)
SAU	VARCHAR2	(2048)
KEYC	VARCHAR2	(3)
PRNM	VARCHAR2	(80)
RNM	VARCHAR2	(240)
COBJ	VARCHAR2	(240)
FAD	NUMBER

Query Text

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


SELECT APAID
,      APID
,      APRID
,      APJID
,      OID
,      CID
,      TID
,      APNM
,      TNM
,      TDES
,      ONM
,      APS
,      APWD
,      APEB
,      APEO
,      APEID
,      APENM
,      CNM
,      CDES
,      DEF
,      OEF
,      CAR
,      COID
,      PNM
,      PSD
,      SID
,      SS
,      SWD
,      SEB
,      SEO
,      SEID
,      SENM
,      SNM
,      SDES
,      SNUM
,      DSUM
,      DDES
,      OSUM
,      ODES
,      CSUM
,      CODES
,      SAU
,      KEYC
,      PRNM
,      RNM
,      COBJ
,      FAD
FROM APPS.AMW_EXPORT_AUDIT_PROCEDURE_V;

Dependencies

[top of page]

APPS.AMW_EXPORT_AUDIT_PROCEDURE_V references the following:

APPS: AMW_AP_ASSOCIATIONS; AMW_AP_EXECUTIONS; AMW_AP_STEPS_VL; AMW_AUDIT_PROCEDURES_B; AMW_AUDIT_PROCEDURES_VL; AMW_AUDIT_PROJECTS_V; AMW_AUDIT_TASKS_V; AMW_AUDIT_UNITS_V; AMW_CONTROLS_B; AMW_CONTROLS_TL; AMW_CONTROL_ASSOCIATIONS; AMW_CURRENT_APPRVD_REV_V; AMW_EMPLOYEES_CURRENT_V; AMW_LOOKUPS; AMW_OBJECTIVE_ASSOCIATIONS; AMW_OBJECT_OPINION_TYPES; AMW_OPINIONS; AMW_OPINION_COMPONTS_B; AMW_OPINION_DETAILS; AMW_OPINION_TYPES_B; AMW_OPINION_VALUES_VL; AMW_PROCESS_OBJECTIVES_VL; AMW_RISKS_ALL_VL; FND_ATTACHED_DOCUMENTS; FND_DOCUMENTS; FND_DOCUMENTS_TL; FND_GLOBAL - show dependent code; FND_OBJECTS; HR_API - show dependent code; PA_PROJECT_PARTIES_UTILS - show dependent code

APPS.AMW_EXPORT_AUDIT_PROCEDURE_V is not referenced by any database object