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: APPS.OZF_SD_TO_ROLE_V

Object Details

Object Name:	OZF_SD_TO_ROLE_V
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

View Type

A multi-org view which will retrive data for your current operating unit and ignore data in other operating units.

Contains the supplier information for Ship and debit request

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
REQUEST_HEADER_ID	NUMBER		Yes	Request header ID
SUPPLIER_NAME	VARCHAR2	(240)		Supplier name
SUPPLIER_EMAIL	VARCHAR2	(2000)		Supplier email
SUPPLIER_PHONE	VARCHAR2	(15)		Supplier phone
SUPPLIER_POSTAL_CODE	VARCHAR2	(60)		zip code
SUPPLIER_LOCATION	VARCHAR2	(15)	Yes	Location of the supplier
SUPPLIER_ADD1	VARCHAR2	(240)		Supplier Address1
SUPPLIER_ADD2	VARCHAR2	(240)		Supplier Address2
SUPPLIER_ADD3	VARCHAR2	(240)		Supplier Address3
SUPPLIER_CITY	VARCHAR2	(60)		Supplier city
SUPPLIER_COUNTRY	VARCHAR2	(60)		Country of the Supplier
SUPPLIER_CONTACT_NAME	VARCHAR2	(360)		Supplier contact name
SUPPLIER_CONTACT_EMAIL_ADD	VARCHAR2	(2000)		Supplier contact email
SUPPLIER_CONTACT_PHONE	VARCHAR2	(60)		Supplier contact phone
SUPPLIER_DUNS_NUMBER	NUMBER			DUNS Number of the supplier
SUPPLIER_CATEGORY_CODE	VARCHAR2	(30)		Category code of the supplier

Query Text

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


SELECT REQUEST_HEADER_ID
,      SUPPLIER_NAME
,      SUPPLIER_EMAIL
,      SUPPLIER_PHONE
,      SUPPLIER_POSTAL_CODE
,      SUPPLIER_LOCATION
,      SUPPLIER_ADD1
,      SUPPLIER_ADD2
,      SUPPLIER_ADD3
,      SUPPLIER_CITY
,      SUPPLIER_COUNTRY
,      SUPPLIER_CONTACT_NAME
,      SUPPLIER_CONTACT_EMAIL_ADD
,      SUPPLIER_CONTACT_PHONE
,      SUPPLIER_DUNS_NUMBER
,      SUPPLIER_CATEGORY_CODE
FROM APPS.OZF_SD_TO_ROLE_V;

Dependencies

[top of page]

APPS.OZF_SD_TO_ROLE_V references the following:

APPS: AP_SUPPLIERS; AP_SUPPLIER_CONTACTS; AP_SUPPLIER_SITES_ALL; HZ_PARTIES; OZF_SD_REQUEST_HEADERS_ALL_B

APPS.OZF_SD_TO_ROLE_V is not referenced by any database object