DBA Data[Home] [Help]

VIEW: APPS.PO_VENDORS_VIEW

Source

View Text - Preformatted

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
View Text - HTML Formatted

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