[Home] [Help]
View: 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 |