eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: POS.POS_SUPPLIER_REGISTRATIONS#

Object Details

Object Name:	POS_SUPPLIER_REGISTRATIONS#
Object Type:	VIEW
Owner:	POS
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
SUPPLIER_REG_ID	NUMBER	(15)	Yes
USER_REG_ID	NUMBER	(15)
SUPPLIER_NAME	VARCHAR2	(240)	Yes
SUPPLIER_NUMBER	VARCHAR2	(30)
TAXPAYER_ID	VARCHAR2	(30)
TAX_REGISTRATION_NUMBER	VARCHAR2	(50)
DUNS_NUMBER	VARCHAR2	(30)
OU_ID	NUMBER		Yes
ADDRESS_NICKNAME	VARCHAR2	(15)
ADDRESS_LINE1	VARCHAR2	(240)
ADDRESS_LINE2	VARCHAR2	(240)
ADDRESS_LINE3	VARCHAR2	(240)
ADDRESS_LINE4	VARCHAR2	(240)
CITY	VARCHAR2	(25)
COUNTY	VARCHAR2	(25)
STATE	VARCHAR2	(150)
PROVINCE	VARCHAR2	(150)
COUNTRY	VARCHAR2	(150)
POSTAL_CODE	VARCHAR2	(20)
NOTE_FROM_SUPPLIER	VARCHAR2	(4000)
NOTE_TO_SUPPLIER	VARCHAR2	(4000)
PO_VENDOR_ID	NUMBER
VENDOR_PARTY_ID	NUMBER	(15)
CREATED_BY	NUMBER	(15)	Yes
CREATION_DATE	DATE		Yes
LAST_UPDATED_BY	NUMBER	(15)	Yes
LAST_UPDATE_DATE	DATE		Yes
LAST_UPDATE_LOGIN	NUMBER	(15)
REGISTRATION_TYPE	VARCHAR2	(30)
REGISTRATION_STATUS	VARCHAR2	(30)
REG_KEY	VARCHAR2	(240)
TAX_REG_COUNTRY_CODE	VARCHAR2	(2)
TAX_REG_TYPE	VARCHAR2	(30)
SUPPLIER_NAME_ALT	VARCHAR2	(320)
SUPPLIER_TYPE	VARCHAR2	(30)
STANDARD_INDUSTRY_CLASS	VARCHAR2	(25)
NI_NUMBER	VARCHAR2	(30)
SM_NOTE_TO_SUPPLIER	VARCHAR2	(4000)
SM_NOTE_TO_BUYER	VARCHAR2	(4000)
SM_BUYER_INTERNAL_NOTES	VARCHAR2	(4000)
REGISTRATION_PURPOSE	VARCHAR2	(30)

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
,      SUPPLIER_NAME_ALT
,      SUPPLIER_TYPE
,      STANDARD_INDUSTRY_CLASS
,      NI_NUMBER
,      SM_NOTE_TO_SUPPLIER
,      SM_NOTE_TO_BUYER
,      SM_BUYER_INTERNAL_NOTES
,      REGISTRATION_PURPOSE
FROM POS.POS_SUPPLIER_REGISTRATIONS#;

Dependencies

[top of page]

POS.POS_SUPPLIER_REGISTRATIONS# references the following:

POS: POS_SUPPLIER_REGISTRATIONS

POS.POS_SUPPLIER_REGISTRATIONS# is referenced by following:

APPS: POS_SUPPLIER_REGISTRATIONS