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

TABLE: WSH.WSH_ITM_PARTIES

Object Details
Object Name: WSH_ITM_PARTIES
Object Type: TABLE
Owner: WSH
FND Design Data: TableWSH.WSH_ITM_PARTIES
Subobject Name:
Status: VALID


Stores information of the parties, which have to be scanned. Submitting a request to ITM Adapter involves creating a row in WSH_ITM_REQUEST_CONTROL. All the parties, which have to be scanned as part of this request have to be populated in WSH_ITM_PARTIES with the corresponding request_control_id.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
WSH_ITM_PARTIES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnPARTY_ID
WSH_ITM_PARTIES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnREQUEST_CONTROL_ID
Columns
Name Datatype Length Mandatory Comments
PARTY_ID NUMBER
Yes Primary Key
REQUEST_CONTROL_ID NUMBER
Yes Foreign Key to WSH_ITM_REQUEST_CONTROL.REQUEST_CONTROL_ID
ORIGINAL_SYSTEM_REFERENCE NUMBER

Reference Header Id from the Integrating Application. Ex: OM Can populate Order_header_id here.
ORIGINAL_SYSTEM_LINE_REFERENCE NUMBER

Reference Line Id from the Integrating Application. Ex: OM Can populate Order_line_id here.
SOURCE_ORG_ID NUMBER

If party_type is 'SHIP_FROM' then source_org_id is ship_from_org_id.
PARTY_TYPE VARCHAR2 (30)
Type - like SHIP_FROM, SHIP_TO etc. The party type is just an informatory field, which doesn't have any functional significance for the vendor. Adapter can send any thing, which is populated by application. So application can maintain any c
PARTY_NAME VARCHAR2 (360) Yes Name
PARTY_ADDRESS1 VARCHAR2 (2000)
Address Line
PARTY_ADDRESS2 VARCHAR2 (2000)
Address Line
PARTY_ADDRESS3 VARCHAR2 (2000)
Address Line
PARTY_ADDRESS4 VARCHAR2 (2000)
Address Line
PARTY_ADDRESS5 VARCHAR2 (2000)
Address Line
PARTY_CITY VARCHAR2 (240)
City
PARTY_STATE VARCHAR2 (240)
State
PARTY_COUNTRY_CODE VARCHAR2 (60)
Country Code is mandatory for Embargo screening
PARTY_COUNTRY_NAME VARCHAR2 (240)
Country Name
POSTAL_CODE VARCHAR2 (240)
Postal Code
CONTACT_NAME VARCHAR2 (240)
Contact Name
PHONE VARCHAR2 (240)
Phone
EMAIL VARCHAR2 (240)
Email address
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
CUST_SITE_USE_ID NUMBER

Customer Site Use ID
ACCOUNT_NAME VARCHAR2 (240)
Account Name
ACCOUNT_NUMBER VARCHAR2 (30)
Account Number
TAX_REFERENCE VARCHAR2 (50)
Tax Reference
PARTY_SITE_NUMBER VARCHAR2 (30)
Party Site Number
ALTERNATE_NAME VARCHAR2 (320)
Alternative Name
OPERATING_UNIT NUMBER

Operating unit
ADDRTYPE VARCHAR2 (1)
Indicates if this site is the primary site for this customer account. Y for the primary customer account site. N for other customer account sites.
PARTNER_CODE VARCHAR2 (240)
Partner code
Query Text

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


SELECT PARTY_ID
,      REQUEST_CONTROL_ID
,      ORIGINAL_SYSTEM_REFERENCE
,      ORIGINAL_SYSTEM_LINE_REFERENCE
,      SOURCE_ORG_ID
,      PARTY_TYPE
,      PARTY_NAME
,      PARTY_ADDRESS1
,      PARTY_ADDRESS2
,      PARTY_ADDRESS3
,      PARTY_ADDRESS4
,      PARTY_ADDRESS5
,      PARTY_CITY
,      PARTY_STATE
,      PARTY_COUNTRY_CODE
,      PARTY_COUNTRY_NAME
,      POSTAL_CODE
,      CONTACT_NAME
,      PHONE
,      EMAIL
,      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
,      CUST_SITE_USE_ID
,      ACCOUNT_NAME
,      ACCOUNT_NUMBER
,      TAX_REFERENCE
,      PARTY_SITE_NUMBER
,      ALTERNATE_NAME
,      OPERATING_UNIT
,      ADDRTYPE
,      PARTNER_CODE
FROM WSH.WSH_ITM_PARTIES;

Dependencies

[top of page]

WSH.WSH_ITM_PARTIES does not reference any database object

WSH.WSH_ITM_PARTIES is referenced by following:

SchemaAPPS
SynonymWSH_ITM_PARTIES