[Home] [Help] [Dependency Information]
Object Name: | POFV_RFQ_SUPPLIER_LISTS |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PO.POFV_RFQ_SUPPLIER_LISTS |
Subobject Name: | |
Status: | VALID |
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.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SUPPLIER_LIST_ID | NUMBER | Yes | ||
LIST_NAME | VARCHAR2 | (25) | Yes | |
LIST_DESCRIPTION | VARCHAR2 | (240) | ||
LIST_INACTIVE_DATE | DATE | |||
_DF | CHAR | (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). |
Cut, paste (and edit) the following text to query this object:
SELECT SUPPLIER_LIST_ID
, LIST_NAME
, LIST_DESCRIPTION
, LIST_INACTIVE_DATE
, _DF
, CREATED_DATE
, CREATED_BY
, LAST_UPDATED_DATE
, LAST_UPDATED_BY
FROM APPS.POFV_RFQ_SUPPLIER_LISTS;
APPS.POFV_RFQ_SUPPLIER_LISTS is not referenced by any database object
|
|
|