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


TABLE: POS.POS_SUPPLIER_REGISTRATIONS

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


POS_SUPPLIER_REGISTRATIONS stores information about supplier registrations and supplier onboarding requests.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
POS_SUPPLIER_REG_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnSUPPLIER_REG_ID
POS_SUPPLIER_REG_U2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnSUPPLIER_NUMBER
POS_SUPPLIER_REG_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnTAXPAYER_ID
POS_SUPPLIER_REG_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnTAX_REGISTRATION_NUMBER
POS_SUPPLIER_REG_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnOU_ID
POS_SUPPLIER_REG_N4 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnVENDOR_PARTY_ID
POS_SUPPLIER_REG_N5 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnREG_KEY
Columns
Name Datatype Length Mandatory Comments
SUPPLIER_REG_ID NUMBER (15) Yes Supplier registration identifier
USER_REG_ID NUMBER (15)
Identifies the corresponding registration record in FND_REGISTRATIONS table for the first supplier user
SUPPLIER_NAME VARCHAR2 (240) Yes Supplier name
SUPPLIER_NUMBER VARCHAR2 (30)
Supplier number assigned to the supplier by the internal buyer during approval
TAXPAYER_ID VARCHAR2 (30)
Tax payer identifier of the supplier
TAX_REGISTRATION_NUMBER VARCHAR2 (50)
Tax registration number of the supplier
DUNS_NUMBER VARCHAR2 (30)
Data Universal Numbering System Number of the supplier
OU_ID NUMBER
Yes Identifies the operating unit with which the supplier is registered
ADDRESS_NICKNAME VARCHAR2 (15)
Supplier address name
ADDRESS_LINE1 VARCHAR2 (240)
Supplier address line 1
ADDRESS_LINE2 VARCHAR2 (240)
Supplier address line 2
ADDRESS_LINE3 VARCHAR2 (240)
Supplier address line 3
ADDRESS_LINE4 VARCHAR2 (240)
Supplier address line 4
CITY VARCHAR2 (25)
City of the supplier address
COUNTY VARCHAR2 (25)
County of the supplier address
STATE VARCHAR2 (150)
State of the supplier address
PROVINCE VARCHAR2 (150)
Province of the supplier address
COUNTRY VARCHAR2 (150)
Country code of the supplier address
POSTAL_CODE VARCHAR2 (20)
Postal code of the supplier address
NOTE_FROM_SUPPLIER VARCHAR2 (4000)
Notes from the supplier
NOTE_TO_SUPPLIER VARCHAR2 (4000)
Notes to the supplier from the internal buyer who approved or rejected the registration
PO_VENDOR_ID NUMBER

Vendor identifier created for the supplier when the registration is approved
VENDOR_PARTY_ID NUMBER (15)
Party identifier of the supplier when the registration is approved
CREATED_BY NUMBER (15) Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who column
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
REGISTRATION_TYPE VARCHAR2 (30)
Type of supplier registration or request
REGISTRATION_STATUS VARCHAR2 (30)
Status of supplier registration or request
REG_KEY VARCHAR2 (240)
Registration Key
TAX_REG_COUNTRY_CODE VARCHAR2 (2)
Tax Registration Country
TAX_REG_TYPE VARCHAR2 (30)
Tax Registration Type
Query Text

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


SELECT SUPPLIER_REG_ID
,      USER_REG_ID
,      SUPPLIER_NAME
,      SUPPLIER_NUMBER
,      TAXPAYER_ID
,      TAX_REGISTRATION_NUMBER
,      DUNS_NUMBER
,      OU_ID
,      ADDRESS_NICKNAME
,      ADDRESS_LINE1
,      ADDRESS_LINE2
,      ADDRESS_LINE3
,      ADDRESS_LINE4
,      CITY
,      COUNTY
,      STATE
,      PROVINCE
,      COUNTRY
,      POSTAL_CODE
,      NOTE_FROM_SUPPLIER
,      NOTE_TO_SUPPLIER
,      PO_VENDOR_ID
,      VENDOR_PARTY_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      REGISTRATION_TYPE
,      REGISTRATION_STATUS
,      REG_KEY
,      TAX_REG_COUNTRY_CODE
,      TAX_REG_TYPE
FROM POS.POS_SUPPLIER_REGISTRATIONS;

Dependencies

[top of page]

POS.POS_SUPPLIER_REGISTRATIONS does not reference any database object

POS.POS_SUPPLIER_REGISTRATIONS is referenced by following:

SchemaAPPS
SynonymPOS_SUPPLIER_REGISTRATIONS