VIEW: APPS.ITG_REQ_VENDORS_V

Source

View Text - Preformatted

SELECT la.requisition_line_id, ve.vendor_name nu_vendor_name, DECODE(ve.one_time_flag, 'Y', '1', '0') supplier_one_time, ve.segment1 supplier_partnrid, ve.invoice_currency_code supplier_currency, ve.vendor_name_alt supplier_descriptn, TO_CHAR(ve.vendor_id) supplier_partnridx, NVL(ve.num_1099, ve.vat_registration_num) supplier_taxid, NULL supplier_ua_banknam, NULL supplier_ua_bankact FROM po_vendors ve, po_requisition_lines_all la WHERE ve.vendor_name = la.suggested_vendor_name

View Text - HTML Formatted

SELECT LA.REQUISITION_LINE_ID
, VE.VENDOR_NAME NU_VENDOR_NAME
, DECODE(VE.ONE_TIME_FLAG
, 'Y'
, '1'
, '0') SUPPLIER_ONE_TIME
, VE.SEGMENT1 SUPPLIER_PARTNRID
, VE.INVOICE_CURRENCY_CODE SUPPLIER_CURRENCY
, VE.VENDOR_NAME_ALT SUPPLIER_DESCRIPTN
, TO_CHAR(VE.VENDOR_ID) SUPPLIER_PARTNRIDX
, NVL(VE.NUM_1099
, VE.VAT_REGISTRATION_NUM) SUPPLIER_TAXID
, NULL SUPPLIER_UA_BANKNAM
, NULL SUPPLIER_UA_BANKACT
FROM PO_VENDORS VE
, PO_REQUISITION_LINES_ALL LA
WHERE VE.VENDOR_NAME = LA.SUGGESTED_VENDOR_NAME