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_OPINION_M_V

Object Details

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

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
OPINION_SET_ID	NUMBER		Yes	Opinion Set Identifier: Opinions can be grouped into sets.
OPINION_ID	NUMBER		Yes	Entity Identifier
OBJECT_OPINION_TYPE_ID	NUMBER		Yes	Identifies a unique entry from the table AMW_OBJECT_OPINION_TYPES.
OPINION_TYPE_CODE	VARCHAR2	(30)	Yes	The code associated with this opinion type
PK1_VALUE	NUMBER			Used in identifying the context hierarchy of the entity to which this opinion correponds.
PK2_VALUE	NUMBER			Used in identifying the context hierarchy of the entity to which this opinion correponds.
PK3_VALUE	NUMBER			Used in identifying the context hierarchy of the entity to which this opinion correponds.
PK4_VALUE	NUMBER			Used in identifying the context hierarchy of the entity to which this opinion correponds.
PK5_VALUE	NUMBER			Used in identifying the context hierarchy of the entity to which this opinion correponds.
PK6_VALUE	NUMBER			Used in identifying the context hierarchy of the entity to which this opinion correponds.
PK7_VALUE	NUMBER			Used in identifying the context hierarchy of the entity to which this opinion correponds.
PK8_VALUE	NUMBER			Used in identifying the context hierarchy of the entity to which this opinion correponds.
PARTY_ID	NUMBER			Identifies the party that has last modified this opinion.
OPINION_VALUE_ID	NUMBER		Yes	Entity Identifier
OPINION_VALUE_CODE	VARCHAR2	(30)	Yes	The code associated with this opinion value
AUTHORED_BY	NUMBER			Identifies the employee who has last modified this opinion.
AUTHORED_DATE	DATE			Dates the creation or the last modification of this opinion.
CREATED_BY	NUMBER	(15)	Yes	Standard Who Column
CREATION_DATE	DATE		Yes	Standard Who Column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who Column
LAST_UPDATE_DATE	DATE		Yes	Standard Who Column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who Column
SECURITY_GROUP_ID	NUMBER			Standard Column
OBJECT_VERSION_NUMBER	NUMBER			Standard Column
OPINION_COMPONENT_CODE	VARCHAR2	(30)	Yes	The code associated with this opinion component
CUST_ATTACHMENT_ID	NUMBER			Identifies an attachment associated with this opinion value.
ATTACHMENT_ID	NUMBER			Identifies an attachment associated with this opinion value code.
CUST_IMAGE_FILE_NAME	VARCHAR2	(240)		The name of the OA_MEDIA image file associated with this opinion value
IMAGE_FILE_NAME	VARCHAR2	(240)		The name of the OA_MEDIA image file associated with this opinion value code
OBJECT_NAME	VARCHAR2	(430)	Yes	the name of the change object to which the opinion correspons. e.g.PROCESS

Query Text

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


SELECT OPINION_SET_ID
,      OPINION_ID
,      OBJECT_OPINION_TYPE_ID
,      OPINION_TYPE_CODE
,      PK1_VALUE
,      PK2_VALUE
,      PK3_VALUE
,      PK4_VALUE
,      PK5_VALUE
,      PK6_VALUE
,      PK7_VALUE
,      PK8_VALUE
,      PARTY_ID
,      OPINION_VALUE_ID
,      OPINION_VALUE_CODE
,      AUTHORED_BY
,      AUTHORED_DATE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      SECURITY_GROUP_ID
,      OBJECT_VERSION_NUMBER
,      OPINION_COMPONENT_CODE
,      CUST_ATTACHMENT_ID
,      ATTACHMENT_ID
,      CUST_IMAGE_FILE_NAME
,      IMAGE_FILE_NAME
,      OBJECT_NAME
FROM APPS.AMW_OPINION_M_V;

Dependencies

[top of page]

APPS.AMW_OPINION_M_V references the following:

APPS: AMW_OBJECT_OPINION_TYPES; AMW_OPINIONS; AMW_OPINION_COMPONTS_B; AMW_OPINION_DETAILS; AMW_OPINION_TYPES_B; AMW_OPINION_VALUES_B; AMW_OPINION_VALUE_CODES; FND_OBJECTS

APPS.AMW_OPINION_M_V is referenced by following:

APPS: AMW_FINSTMT_CERT_BES_PKG - show dependent code; AMW_FINSTMT_CERT_MIG_PKG - show dependent code