FND Design Data [Home] [Help]

View: PO_VENDORS_VIEW

Product: PO - Purchasing
Description: Suppliers view
Implementation/DBA Data: ViewAPPS.PO_VENDORS_VIEW
View Text

SELECT V.SET_OF_BOOKS_ID
, V.VENDOR_ID
, V.SEGMENT1||' '||V.SEGMENT2||' '||V.SEGMENT3|| ' '||V.SEGMENT4||' '||V.SEGMENT5
, V.VENDOR_NAME
, V.LAST_UPDATE_DATE
, V.LAST_UPDATED_BY
, V.SUMMARY_FLAG
, V.ENABLED_FLAG
, V.CUSTOMER_NUM
, V.ONE_TIME_FLAG
, V.START_DATE_ACTIVE
, V.END_DATE_ACTIVE
FROM PO_VENDORS V

Columns

Name
SET_OF_BOOKS_ID
VENDOR_ID
VENDOR_NUMBER
VENDOR_NAME
VENDOR_LAST_UPDATE_DATE
VENDOR_LAST_UPDATED_BY
SUMMARY_FLAG
ENABLED_FLAG
CUSTOMER_NUMBER
ONE_TIME_VENDOR_FLAG
VENDOR_START_DATE_ACTIVE
VENDOR_END_DATE_ACTIVE