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

VIEW: APPS.POBV_RFQ_SUPPLIER_LISTS

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

View Type

A Business Intelligence System view


This shows predefined groups of suppliers to whom buyers want to send requests for quotation. The list can be defined based on item, manufacturing category, geographic location, and so on.


[View Source]

Columns
Name Datatype Length Mandatory Comments
SUPPLIER_LIST_ID NUMBER
Yes
LIST_NAME VARCHAR2 (25) Yes
LIST_DESCRIPTION VARCHAR2 (240)

LIST_INACTIVE_DATE DATE


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_ID
,      LIST_NAME
,      LIST_DESCRIPTION
,      LIST_INACTIVE_DATE
,      CREATED_DATE
,      CREATED_BY
,      LAST_UPDATED_DATE
,      LAST_UPDATED_BY
FROM APPS.POBV_RFQ_SUPPLIER_LISTS;

Dependencies

[top of page]

APPS.POBV_RFQ_SUPPLIER_LISTS references the following:

SchemaAPPS
SynonymPO_VENDOR_LIST_HEADERS

APPS.POBV_RFQ_SUPPLIER_LISTS is not referenced by any database object