View: ITG_REQ_VENDORS_V

Product:	ITG - Internet Procurement Enterprise Connector
Description:	This view is used to generate XML segment containing requistion supplier information
Implementation/DBA Data:	APPS.ITG_REQ_VENDORS_V

View Text

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

Columns