Skip to content

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

TABLE: POS.POS_ADDRESS_UPGRADE

Object Details
Object Name: POS_ADDRESS_UPGRADE
Object Type: TABLE
Owner: POS
FND Design Data: TablePOS.POS_ADDRESS_UPGRADE
Subobject Name:
Status: VALID


POS_ADDRESS_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_ADDRESS_UPGRADE_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnACTION
ColumnPOS_PARTY_SITE_ID
Columns
Name Datatype Length Mandatory Comments
ACTION VARCHAR2 (20) Yes Action code
POS_PARTY_SITE_ID NUMBER
Yes Party site ID for supplier address created by iSupplier before upgrade to release 12
POS_ADDRESS_REQUEST_ID NUMBER
Yes Address request ID
AP_PARTY_SITE_ID NUMBER

Party site ID for the vendor site created by Payables during upgrade to release 12
CREATED_BY NUMBER
Yes Standard Who Column
CREATION_DATE DATE

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)
Flag used in upgrade to indicate if the row has been processed.
Query Text

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


SELECT ACTION
,      POS_PARTY_SITE_ID
,      POS_ADDRESS_REQUEST_ID
,      AP_PARTY_SITE_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      PROCESSED
FROM POS.POS_ADDRESS_UPGRADE;

Dependencies

[top of page]

POS.POS_ADDRESS_UPGRADE does not reference any database object

POS.POS_ADDRESS_UPGRADE is referenced by following:

SchemaPOS
ViewPOS_ADDRESS_UPGRADE#