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

VIEW: APPS.POFV_RFQ_SUPPLIER_LIST_ENTRIES

Object Details
Object Name: POFV_RFQ_SUPPLIER_LIST_ENTRIES
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPO.POFV_RFQ_SUPPLIER_LIST_ENTRIES
Subobject Name:
Status: VALID

View Type

A Business Intelligence System view


This shows supplier information placed on a request for quotation supplier list.


[View Source]

Columns
Name Datatype Length Mandatory Comments
SUPPLIER_LIST_ENTRY_ID NUMBER
Yes
SUPPLIER_LIST_ID NUMBER
Yes
_DF CHAR (32)

SUPPLIER_ID NUMBER


SUPPLIER_NAME VARCHAR2 (240)

SUPPLIER_SITE_ID NUMBER


SUPPLIER_SITE VARCHAR2 (15) Yes
SITE_OPERATING_UNIT_ID NUMBER


SITE_OPERATING_UNIT_NAME VARCHAR2 (240) Yes
SUPPLIER_CONTACT_ID NUMBER


SUPPLIER_CONTACT_NAME VARCHAR2 (32)

CREATED_DATE DATE


CREATED_BY NUMBER

Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATED_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
Query Text

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


SELECT SUPPLIER_LIST_ENTRY_ID
,      SUPPLIER_LIST_ID
,      _DF
,      SUPPLIER_ID
,      SUPPLIER_NAME
,      SUPPLIER_SITE_ID
,      SUPPLIER_SITE
,      SITE_OPERATING_UNIT_ID
,      SITE_OPERATING_UNIT_NAME
,      SUPPLIER_CONTACT_ID
,      SUPPLIER_CONTACT_NAME
,      CREATED_DATE
,      CREATED_BY
,      LAST_UPDATED_DATE
,      LAST_UPDATED_BY
FROM APPS.POFV_RFQ_SUPPLIER_LIST_ENTRIES;

Dependencies

[top of page]

APPS.POFV_RFQ_SUPPLIER_LIST_ENTRIES references the following:

SchemaAPPS
SynonymHR_ALL_ORGANIZATION_UNITS
ViewPO_VENDORS
ViewPO_VENDOR_CONTACTS
SynonymPO_VENDOR_LIST_ENTRIES
ViewPO_VENDOR_SITES_ALL

APPS.POFV_RFQ_SUPPLIER_LIST_ENTRIES is not referenced by any database object