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: ViewAMW.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 Mandatory Comments
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:

SchemaAPPS
SynonymAMW_AP_ASSOCIATIONS
SynonymAMW_AP_EXECUTIONS
ViewAMW_AP_STEPS_VL
SynonymAMW_AUDIT_PROCEDURES_B
ViewAMW_AUDIT_PROCEDURES_VL
ViewAMW_AUDIT_PROJECTS_V
ViewAMW_AUDIT_TASKS_V
ViewAMW_AUDIT_UNITS_V
SynonymAMW_CONTROLS_B
SynonymAMW_CONTROLS_TL
SynonymAMW_CONTROL_ASSOCIATIONS
ViewAMW_CURRENT_APPRVD_REV_V
ViewAMW_EMPLOYEES_CURRENT_V
ViewAMW_LOOKUPS
SynonymAMW_OBJECTIVE_ASSOCIATIONS
SynonymAMW_OBJECT_OPINION_TYPES
SynonymAMW_OPINIONS
SynonymAMW_OPINION_COMPONTS_B
SynonymAMW_OPINION_DETAILS
SynonymAMW_OPINION_TYPES_B
ViewAMW_OPINION_VALUES_VL
ViewAMW_PROCESS_OBJECTIVES_VL
ViewAMW_RISKS_ALL_VL
SynonymFND_ATTACHED_DOCUMENTS
SynonymFND_DOCUMENTS
SynonymFND_DOCUMENTS_TL
PL/SQL PackageFND_GLOBAL - show dependent code
SynonymFND_OBJECTS
PL/SQL PackageHR_API - show dependent code
PL/SQL PackagePA_PROJECT_PARTIES_UTILS - show dependent code

APPS.AMW_EXPORT_AUDIT_PROCEDURE_V is not referenced by any database object