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

TABLE: POA.POA_DNB_SIC_CODE

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


This table stores the Standard Industry Classification Code information associated to a trading partner.


Storage Details
Tablespace: TablespaceAPPS_TS_SUMMARY
PCT Free: 5
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
POA_DNB_SIC_CODE_U1 NORMAL NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnTRADING_PARTNER_PK
Columns
Name Datatype Length Mandatory Comments
TRADING_PARTNER_PK VARCHAR2 (320)
Unique identifier Trading Partner
SIC_CODE VARCHAR2 (40)
Primary standard industry classification
SIC_DESCRIPTION VARCHAR2 (80)
Primary standard industry classification description
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
,      SIC_CODE
,      SIC_DESCRIPTION
,      DNB_UPDATE_DATE
,      LAST_UPDATE_DATE
,      CREATION_DATE
,      REQUEST_ID
,      OPERATION_CODE
,      ERROR_CODE
,      COLLECTION_STATUS
FROM POA.POA_DNB_SIC_CODE;

Dependencies

[top of page]

POA.POA_DNB_SIC_CODE does not reference any database object

POA.POA_DNB_SIC_CODE is referenced by following:

SchemaAPPS
SynonymPOA_DNB_SIC_CODE