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

Object Details

Object Name:	POR_SUPPLIER_LOV_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	ICX.POR_SUPPLIER_LOV_V
Subobject Name:
Status:	VALID

View Type

A Web view designed to simplify access from Oracle Self-Service Web Applications.

The POR_SUPPLIER_LOV_V view returns a list of suppliers that allows the user to choose to be the supplier of the purchasing item.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
VENDOR_ID	NUMBER		Yes	Vendor Identifier
VENDOR_SITE_ID	NUMBER			Vendor Site Identifier
VENDOR_CONTACT_ID	NUMBER			Vendor Contact Identifier
VENDOR_NAME	VARCHAR2	(240)		Vendor Name
CONTACT	VARCHAR2	(32)		Supplier Contact
ADDRESS_LINE1	VARCHAR2	(240)		Address Line 1
ADDRESS_LINE2	VARCHAR2	(240)		Address Line 2
ADDRESS_LINE3	VARCHAR2	(240)		Address Line 3
CITY	VARCHAR2	(25)		City
STATE	VARCHAR2	(150)		State
ZIP	VARCHAR2	(20)		Zip
COUNTRY	VARCHAR2	(25)		Country
TELEPHONE	VARCHAR2	(51)		Telephone
VENDOR_SITE_CODE	VARCHAR2	(15)		Vendor Site Code

Query Text

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


SELECT VENDOR_ID
,      VENDOR_SITE_ID
,      VENDOR_CONTACT_ID
,      VENDOR_NAME
,      CONTACT
,      ADDRESS_LINE1
,      ADDRESS_LINE2
,      ADDRESS_LINE3
,      CITY
,      STATE
,      ZIP
,      COUNTRY
,      TELEPHONE
,      VENDOR_SITE_CODE
FROM APPS.POR_SUPPLIER_LOV_V;

Dependencies

[top of page]

APPS.POR_SUPPLIER_LOV_V references the following:

APPS: PO_VENDORS; PO_VENDOR_CONTACTS; PO_VENDOR_SITES

APPS.POR_SUPPLIER_LOV_V is not referenced by any database object