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

TABLE: POS.POS_OSN_REQUESTS

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


Table for storing inbound requests from Oracle Supplier Network


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
SYS_IL0000409615C00016$$ LOB UNIQUE TablespaceAPPS_TS_TX_DATA
Columns
Name Datatype Length Mandatory Comments
INTERNAL_ID NUMBER
Yes Internal Id
REQUEST_ID NUMBER
Yes Request Id
ISP_REGISTRATION_ID NUMBER

ISP Registration ID
REQUEST_TYPE VARCHAR2 (100)
Request Type
REQUEST_STATUS VARCHAR2 (100)
Request Status
OSN_EHUB_ID NUMBER

OSN Hub ID
OSN_TPNAME VARCHAR2 (240)
OSN Trading Partner Name
OSN_USERNAME VARCHAR2 (100)
OSN User Name
OSN_USER_FIRSTNAME VARCHAR2 (100)
First Name
OSN_USER_MIDDLENAME VARCHAR2 (100)
Middle name
OSN_USER_LASTNAME VARCHAR2 (100)
Last Name
OSN_EMAIL VARCHAR2 (240)
Email Address
OSN_USER_PHONE VARCHAR2 (100)
Phone
ISP_USERNAME VARCHAR2 (100)
iSP username
ISP_PASSWORD VARCHAR2 (100)
ISP Password
XML_MSG CLOB (4000)
XML document which is exchanged between iSP and OSN
RECEIVED_DATE DATE

Receipt Date of the XML message
LAST_UPDATED_DATE DATE

Last Update Date
Query Text

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


SELECT INTERNAL_ID
,      REQUEST_ID
,      ISP_REGISTRATION_ID
,      REQUEST_TYPE
,      REQUEST_STATUS
,      OSN_EHUB_ID
,      OSN_TPNAME
,      OSN_USERNAME
,      OSN_USER_FIRSTNAME
,      OSN_USER_MIDDLENAME
,      OSN_USER_LASTNAME
,      OSN_EMAIL
,      OSN_USER_PHONE
,      ISP_USERNAME
,      ISP_PASSWORD
,      XML_MSG
,      RECEIVED_DATE
,      LAST_UPDATED_DATE
FROM POS.POS_OSN_REQUESTS;

Dependencies

[top of page]

POS.POS_OSN_REQUESTS does not reference any database object

POS.POS_OSN_REQUESTS is referenced by following:

SchemaPOS
ViewPOS_OSN_REQUESTS#