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

VIEW: APPS.POBV_RFQ_SUPPLIERS

Object Details
Object Name: POBV_RFQ_SUPPLIERS
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPO.POBV_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)

SUPPLIER_ID NUMBER


SUPPLIER_SITE_ID NUMBER


SUPPLIER_CONTACT_ID NUMBER


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
,      SUPPLIER_ID
,      SUPPLIER_SITE_ID
,      SUPPLIER_CONTACT_ID
,      CREATED_DATE
,      CREATED_BY
,      LAST_UPDATED_DATE
,      LAST_UPDATED_BY
FROM APPS.POBV_RFQ_SUPPLIERS;

Dependencies

[top of page]

APPS.POBV_RFQ_SUPPLIERS references the following:

SchemaAPPS
SynonymHR_ALL_ORGANIZATION_UNITS
SynonymPO_HEADERS_ALL
SynonymPO_RFQ_VENDORS

APPS.POBV_RFQ_SUPPLIERS is not referenced by any database object