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

TABLE: POS.POS_CONTACT_UPGRADE

Object Details
Object Name: POS_CONTACT_UPGRADE
Object Type: TABLE
Owner: POS
Subobject Name:
Status: VALID


POS_CONTACT_UPGRADE is a table used in upgrade from earlier release to Release 12.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
POS_CONTACT_UPGRADE_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnACTION
ColumnAP_CONTACT_PARTY_ID
Columns
Name Datatype Length Mandatory Comments
ACTION VARCHAR2 (20) Yes Action code
POS_CONTACT_PARTY_ID NUMBER
Yes Contact party ID created by iSupplier before releease 12
POS_CONTACT_REQUEST_ID NUMBER
Yes Contact request ID
AP_CONTACT_PARTY_ID NUMBER

Party id created by Payables during upgrade to release 12
MAPPING_ID NUMBER
Yes Mapping ID for the supplier in POS_SUPPLIER_MAPPINGS table
CREATED_BY NUMBER
Yes Standard Who Column
CREATION_DATE DATE
Yes Standard Who Column
LAST_UPDATED_BY NUMBER
Yes Standard Who Column
LAST_UPDATE_DATE DATE
Yes Standard Who Column
LAST_UPDATE_LOGIN NUMBER

Standard Who Column
PROCESSED VARCHAR2 (1)
Indicated if the record has been processed during upgrade
Query Text

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


SELECT ACTION
,      POS_CONTACT_PARTY_ID
,      POS_CONTACT_REQUEST_ID
,      AP_CONTACT_PARTY_ID
,      MAPPING_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      PROCESSED
FROM POS.POS_CONTACT_UPGRADE;

Dependencies

[top of page]

POS.POS_CONTACT_UPGRADE does not reference any database object

POS.POS_CONTACT_UPGRADE is referenced by following:

SchemaAPPS
SynonymPOS_CONTACT_UPGRADE