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

VIEW: APPS.POFV_RFQ_SUPPLIERS

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

View Type

A Business Intelligence System view


This shows suppliers assigned to requests for quotation. Each request for quotation can have more than one supplier.


[View Source]

Columns
Name Datatype Length Mandatory Comments
RFQ_ID NUMBER
Yes
RFQ_DOCUMENT_NUMBER VARCHAR2 (20) Yes
OPERATING_UNIT_ID NUMBER


OPERATING_UNIT_NAME VARCHAR2 (240) Yes
SEQUENCE_NUMBER NUMBER
Yes
LAST_PRINTED_DATE DATE


PRINT_COUNT NUMBER


_LA:REPRINT_FOR_SUPPLIER CHAR (56)

_DF CHAR (24)

SUPPLIER_ID NUMBER


SUPPLIER_NAME VARCHAR2 (240)

SUPPLIER_SITE_ID NUMBER


SUPPLIER_SITE VARCHAR2 (15)

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 RFQ_ID
,      RFQ_DOCUMENT_NUMBER
,      OPERATING_UNIT_ID
,      OPERATING_UNIT_NAME
,      SEQUENCE_NUMBER
,      LAST_PRINTED_DATE
,      PRINT_COUNT
,      _LA:REPRINT_FOR_SUPPLIER
,      _DF
,      SUPPLIER_ID
,      SUPPLIER_NAME
,      SUPPLIER_SITE_ID
,      SUPPLIER_SITE
,      SUPPLIER_CONTACT_ID
,      SUPPLIER_CONTACT_NAME
,      CREATED_DATE
,      CREATED_BY
,      LAST_UPDATED_DATE
,      LAST_UPDATED_BY
FROM APPS.POFV_RFQ_SUPPLIERS;

Dependencies

[top of page]

APPS.POFV_RFQ_SUPPLIERS references the following:

SchemaAPPS
PL/SQL PackageFND_GLOBAL - show dependent code
SynonymHR_ALL_ORGANIZATION_UNITS
SynonymPO_HEADERS_ALL
SynonymPO_RFQ_VENDORS
ViewPO_VENDORS
ViewPO_VENDOR_CONTACTS
ViewPO_VENDOR_SITES_ALL

APPS.POFV_RFQ_SUPPLIERS is not referenced by any database object