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: TableWSH.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: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
WSH_ITM_DENIED_PARTIES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnRESPONSE_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:

SchemaAPPS
SynonymWSH_ITM_DENIED_PARTIES