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.JTF_RS_SUPPLIERS_VL

Object Details

Object Name:	JTF_RS_SUPPLIERS_VL
Object Type:	VIEW
Owner:	APPS
FND Design Data:	JTF.JTF_RS_SUPPLIERS_VL
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

The details of supplier contacts that can be imported as resource or are already present as resource

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
SUPPLIER_ID	NUMBER		Yes	Unique Supplier Identifier (PK)
SUPPLIER_NUMBER	VARCHAR2	(30)	Yes	Suplier Number
SUPPLIER_NAME	VARCHAR2	(240)		Supplier Name
SUPPLIER_SITE_ID	NUMBER		Yes	Supplier site Identifier
SUPPLIER_SITE_CODE	VARCHAR2	(15)	Yes	Supplier Site Code
ORG_ID	NUMBER			Organization identifier
ADDRESS_LINE1	VARCHAR2	(240)		Line1 of the Address of Supplier Site
ADDRESS_LINE2	VARCHAR2	(240)		Line2 of the Address of Supplier Site
ADDRESS_LINE3	VARCHAR2	(240)		Line3 of the Address of Supplier Site
CITY	VARCHAR2	(25)		City of Supplier Site
ZIP_CODE	VARCHAR2	(20)		Zip Code of Supplier Site
STATE	VARCHAR2	(150)		State of Supplier Site
PROVINCE	VARCHAR2	(150)		Province of Supplier Site
COUNTY	VARCHAR2	(150)		County of Supplier Site
COUNTRY	VARCHAR2	(25)		Country of Supplier Site
SUPPLIER_CONTACT_ID	NUMBER			Supplier Contact Identifier
FIRST_NAME	VARCHAR2	(15)		First Name of the Supplier Contact
LAST_NAME	VARCHAR2	(15)		Last Name of Supplier Contact
AREA_CODE	VARCHAR2	(10)		Area Code of the Supplier Contact
PHONE	VARCHAR2	(40)		Phone of Supplier Contact
EMAIL	VARCHAR2	(0)		E-mail of Supplier Contact
FAX	VARCHAR2	(0)		Fax of Supplier Contact
ORG_NAME	VARCHAR2	(240)	Yes	Organization to which Supplier is attached

Query Text

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


SELECT SUPPLIER_ID
,      SUPPLIER_NUMBER
,      SUPPLIER_NAME
,      SUPPLIER_SITE_ID
,      SUPPLIER_SITE_CODE
,      ORG_ID
,      ADDRESS_LINE1
,      ADDRESS_LINE2
,      ADDRESS_LINE3
,      CITY
,      ZIP_CODE
,      STATE
,      PROVINCE
,      COUNTY
,      COUNTRY
,      SUPPLIER_CONTACT_ID
,      FIRST_NAME
,      LAST_NAME
,      AREA_CODE
,      PHONE
,      EMAIL
,      FAX
,      ORG_NAME
FROM APPS.JTF_RS_SUPPLIERS_VL;

Dependencies

[top of page]

APPS.JTF_RS_SUPPLIERS_VL references the following:

APPS: HR_OPERATING_UNITS; PO_VENDORS; PO_VENDOR_CONTACTS; PO_VENDOR_SITES_ALL

APPS.JTF_RS_SUPPLIERS_VL is not referenced by any database object