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

TABLE: POA.POA_DNB_TRD_PRTNR

Object Details
Object Name: POA_DNB_TRD_PRTNR
Object Type: TABLE
Owner: POA
FND Design Data: TablePOA.POA_DNB_TRD_PRTNR
Subobject Name:
Status: VALID


This table stores the pairing of trading partner locations to the corresponding DUNS information.


Storage Details
Tablespace: TablespaceAPPS_TS_SUMMARY
PCT Free: 5
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
POA_DNB_TRD_PRTNR_U1 NORMAL NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnTRADING_PARTNER_PK
Columns
Name Datatype Length Mandatory Comments
TRADING_PARTNER_PK VARCHAR2 (320)
Unique identifier Trading Partner
TRADING_PARTNER_NAME VARCHAR2 (480)
Trading Partner Name
DUNS VARCHAR2 (40)
DUNS Number
SIC_CODE VARCHAR2 (80)
Primary standard industry classification
DNB_UPDATE_DATE DATE

Last update date of D&B data
LAST_UPDATE_DATE DATE

Standard Who Column
CREATION_DATE DATE

Standard Who Column
REQUEST_ID NUMBER

Identifier used by collection program
OPERATION_CODE VARCHAR2 (30)
Code used by the collection program to determine whether to insert/update/delete this record
ERROR_CODE VARCHAR2 (2000)
Code used to store error messages
COLLECTION_STATUS VARCHAR2 (30)
Collection status code for the record.
Query Text

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


SELECT TRADING_PARTNER_PK
,      TRADING_PARTNER_NAME
,      DUNS
,      SIC_CODE
,      DNB_UPDATE_DATE
,      LAST_UPDATE_DATE
,      CREATION_DATE
,      REQUEST_ID
,      OPERATION_CODE
,      ERROR_CODE
,      COLLECTION_STATUS
FROM POA.POA_DNB_TRD_PRTNR;

Dependencies

[top of page]

POA.POA_DNB_TRD_PRTNR does not reference any database object

POA.POA_DNB_TRD_PRTNR is referenced by following:

SchemaAPPS
SynonymPOA_DNB_TRD_PRTNR