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]

TABLE: WSH.WSH_ITM_DENIED_PARTIES

Object Details

Object Name:	WSH_ITM_DENIED_PARTIES
Object Type:	TABLE
Owner:	WSH
FND Design Data:	WSH.WSH_ITM_DENIED_PARTIES
Subobject Name:
Status:	VALID

In WSH_ITM_RESPONSE_LINES we store the scanning results of all the parties in a request. If a Denied Party match is found for any of the parties the corresponding details of the match are stored in this table.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
WSH_ITM_DENIED_PARTIES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RESPONSE_LINE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
RESPONSE_LINE_ID	NUMBER		Yes	Foreign Key to WSH_ITM_RESPONSE_LINES.RESPONSE_LINE_ID
MATCH_TYPE	VARCHAR2	(100)		Denied Party Match Type (Ex: DEN(Denials List), SDN(Special Designated))
MATCH_DESC	VARCHAR2	(2000)		Description of the match
MATCH_WORDS	VARCHAR2	(300)		The words due to which this denied_party match is found
NOTE1	VARCHAR2	(300)		Any notes about the party
NOTE2	VARCHAR2	(300)		Any notes about the party
NOTE3	VARCHAR2	(240)		Any notes about the party
DOCUMENT_VOLUME	VARCHAR2	(30)		The volume of the restricted party list document in which this match is present.
DOCUMENT_PAGE	VARCHAR2	(30)		The page number of the restricted party list document in which this match is present.
DOCUMENT_DATE	VARCHAR2	(150)		The date of the restricted party list document in which this match is present.
EFFECTIVE_DATE	VARCHAR2	(150)		From this date onwards the restriction is applied.
EXPIRATION_DATE	VARCHAR2	(150)		The date after which the party is not restricted.
NAME	VARCHAR2	(360)		Name of the party.
ADDRESS1	VARCHAR2	(2000)		Address of the party.
ADDRESS2	VARCHAR2	(2000)		Address of the party.
ADDRESS3	VARCHAR2	(2000)		Address of the party.
ADDRESS4	VARCHAR2	(2000)		Address of the party.
ADDRESS5	VARCHAR2	(2000)		Address of the party.
CITY	VARCHAR2	(240)		City of the party
STATE_OR_PROVINCE	VARCHAR2	(240)		State or Province of the Party
COUNTRY_CODE	VARCHAR2	(60)		Country Code of the Party
COUNTRY_NAME	VARCHAR2	(240)		Country Name of the Party
POSTAL_CODE	VARCHAR2	(240)		Postal Code of the Party
CONTACT_NAME	VARCHAR2	(240)		Contact Name of the Party
EMAIL	VARCHAR2	(240)		Email of the Party
PHONE	VARCHAR2	(240)		Phone number.
FAX	VARCHAR2	(240)		Fax
WEB	VARCHAR2	(240)		Web URL
ATTRIBUTE1_NAME	VARCHAR2	(240)		Additional Info field
ATTRIBUTE2_NAME	VARCHAR2	(240)		Additional Info field
ATTRIBUTE3_NAME	VARCHAR2	(240)		Additional Info field
ATTRIBUTE4_NAME	VARCHAR2	(240)		Additional Info field
ATTRIBUTE5_NAME	VARCHAR2	(240)		Additional Info field
ATTRIBUTE6_NAME	VARCHAR2	(240)		Additional Info field
ATTRIBUTE7_NAME	VARCHAR2	(240)		Additional Info field
ATTRIBUTE8_NAME	VARCHAR2	(240)		Additional Info field
ATTRIBUTE9_NAME	VARCHAR2	(240)		Additional Info field
ATTRIBUTE10_NAME	VARCHAR2	(240)		Additional Info field
ATTRIBUTE11_NAME	VARCHAR2	(240)		Additional Info field
ATTRIBUTE12_NAME	VARCHAR2	(240)		Additional Info field
ATTRIBUTE13_NAME	VARCHAR2	(240)		Additional Info field
ATTRIBUTE14_NAME	VARCHAR2	(240)		Additional Info field
ATTRIBUTE15_NAME	VARCHAR2	(240)		Additional Info field
ATTRIBUTE1_VALUE	VARCHAR2	(240)		Additional Info field
ATTRIBUTE2_VALUE	VARCHAR2	(240)		Additional Info field
ATTRIBUTE3_VALUE	VARCHAR2	(240)		Additional Info field
ATTRIBUTE4_VALUE	VARCHAR2	(240)		Additional Info field
ATTRIBUTE5_VALUE	VARCHAR2	(240)		Additional Info field
ATTRIBUTE6_VALUE	VARCHAR2	(240)		Additional Info field
ATTRIBUTE7_VALUE	VARCHAR2	(240)		Additional Info field
ATTRIBUTE8_VALUE	VARCHAR2	(240)		Additional Info field
ATTRIBUTE9_VALUE	VARCHAR2	(240)		Additional Info field
ATTRIBUTE10_VALUE	VARCHAR2	(240)		Additional Info field
ATTRIBUTE11_VALUE	VARCHAR2	(240)		Additional Info field
ATTRIBUTE12_VALUE	VARCHAR2	(240)		Additional Info field
ATTRIBUTE13_VALUE	VARCHAR2	(240)		Additional Info field
ATTRIBUTE14_VALUE	VARCHAR2	(240)		Additional Info field
ATTRIBUTE15_VALUE	VARCHAR2	(240)		Additional Info field
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

Query Text

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


SELECT RESPONSE_LINE_ID
,      MATCH_TYPE
,      MATCH_DESC
,      MATCH_WORDS
,      NOTE1
,      NOTE2
,      NOTE3
,      DOCUMENT_VOLUME
,      DOCUMENT_PAGE
,      DOCUMENT_DATE
,      EFFECTIVE_DATE
,      EXPIRATION_DATE
,      NAME
,      ADDRESS1
,      ADDRESS2
,      ADDRESS3
,      ADDRESS4
,      ADDRESS5
,      CITY
,      STATE_OR_PROVINCE
,      COUNTRY_CODE
,      COUNTRY_NAME
,      POSTAL_CODE
,      CONTACT_NAME
,      EMAIL
,      PHONE
,      FAX
,      WEB
,      ATTRIBUTE1_NAME
,      ATTRIBUTE2_NAME
,      ATTRIBUTE3_NAME
,      ATTRIBUTE4_NAME
,      ATTRIBUTE5_NAME
,      ATTRIBUTE6_NAME
,      ATTRIBUTE7_NAME
,      ATTRIBUTE8_NAME
,      ATTRIBUTE9_NAME
,      ATTRIBUTE10_NAME
,      ATTRIBUTE11_NAME
,      ATTRIBUTE12_NAME
,      ATTRIBUTE13_NAME
,      ATTRIBUTE14_NAME
,      ATTRIBUTE15_NAME
,      ATTRIBUTE1_VALUE
,      ATTRIBUTE2_VALUE
,      ATTRIBUTE3_VALUE
,      ATTRIBUTE4_VALUE
,      ATTRIBUTE5_VALUE
,      ATTRIBUTE6_VALUE
,      ATTRIBUTE7_VALUE
,      ATTRIBUTE8_VALUE
,      ATTRIBUTE9_VALUE
,      ATTRIBUTE10_VALUE
,      ATTRIBUTE11_VALUE
,      ATTRIBUTE12_VALUE
,      ATTRIBUTE13_VALUE
,      ATTRIBUTE14_VALUE
,      ATTRIBUTE15_VALUE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
FROM WSH.WSH_ITM_DENIED_PARTIES;

Dependencies

[top of page]

WSH.WSH_ITM_DENIED_PARTIES does not reference any database object

WSH.WSH_ITM_DENIED_PARTIES is referenced by following:

APPS: WSH_ITM_DENIED_PARTIES