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

VIEW: APPS.AMW_CONSTRAINT_WAIVERS_VL

Object Details
Object Name: AMW_CONSTRAINT_WAIVERS_VL
Object Type: VIEW
Owner: APPS
FND Design Data: ViewAMW.AMW_CONSTRAINT_WAIVERS_VL
Subobject Name:
Status: VALID

View Type

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


AMW_CONSTRAINT_WAIVERS_VL is a view that joins the translated, language specific values from AMW_CONSTRAINT_WAIVERS_TL with the non-displayed data from AMW_CONSTRAINT_WAIVERS_B to form complete Constaint Waiver entities.


[View Source]

Columns
Name Datatype Length Mandatory Comments
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
CREATED_BY NUMBER (15) Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
CONSTRAINT_REV_ID NUMBER
Yes Constraint Revision Id
OBJECT_TYPE VARCHAR2 (30) Yes Stores the type of waiver. The possible values USER - User Waiver, RESP - Responsibility Wiaver.
PK1 NUMBER
Yes When OBJECT_TYPE = USER, PK1 = User Id. When OBJECT_TYPE = RESP, PK1= Responsibility Id
PK2 NUMBER

When OBJECT_TYPE=RESP, PK2 = Responsibility Application Id.
PK3 NUMBER

Not currently used
PK4 NUMBER

Not currently used
PK5 NUMBER

Not currently used
START_DATE DATE
Yes Constraint Start date
END_DATE DATE

Constraint End Date
CONSTRAINT_WAIVER_ID NUMBER
Yes Constraint waiver Identifier
OBJECT_VERSION_NUMBER NUMBER

This column is used for optimistic locking.
SECURITY_GROUP_ID NUMBER

Used in hosted environments
JUSTIFICATION VARCHAR2 (4000)
Constraint waiver Justification
Query Text

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


SELECT LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      CONSTRAINT_REV_ID
,      OBJECT_TYPE
,      PK1
,      PK2
,      PK3
,      PK4
,      PK5
,      START_DATE
,      END_DATE
,      CONSTRAINT_WAIVER_ID
,      OBJECT_VERSION_NUMBER
,      SECURITY_GROUP_ID
,      JUSTIFICATION
FROM APPS.AMW_CONSTRAINT_WAIVERS_VL;

Dependencies

[top of page]

APPS.AMW_CONSTRAINT_WAIVERS_VL references the following:

SchemaAPPS
SynonymAMW_CONSTRAINT_WAIVERS_B
SynonymAMW_CONSTRAINT_WAIVERS_TL
APPS.AMW_CONSTRAINT_WAIVERS_VL is referenced by following:

SchemaAPPS
Package BodyAMW_VIOLATION_PUB - show dependent code
Package BodyAMW_VIOLATION_PVT - show dependent code