View: ITG_SP_PO_PART_SUPPL_V

Product:	ITG - Internet Procurement Enterprise Connector
Description:	This view is used to generate the partner supplier segment in the Sync PO XML
Implementation/DBA Data:	APPS.ITG_SP_PO_PART_SUPPL_V

View Text

SELECT PHA.PO_HEADER_ID
, PHA.VENDOR_ID
, PHA.VENDOR_SITE_ID
, PHA.VENDOR_CONTACT_ID
, VEN.VENDOR_NAME
, DECODE(UPPER(VEN.ONE_TIME_FLAG)
, 'Y'
, 1
, 0) ONETIME
, VEN.SEGMENT1 PARTNRID
, 'SUPPLIER' PARTNRTYPE
, PHA.CURRENCY_CODE CURRENCY
, VEN.VENDOR_NAME_ALT VEN_DESCRIPTN
, TO_CHAR(VEN.VENDOR_ID) PARTNRIDX
, 0 TAXEXEMPT
, NVL(VEN.NUM_1099
, VEN.VAT_REGISTRATION_NUM) TAXID
, DECODE(VSA.COUNTRY
, 'US'
, 'Y'
, 'N') UA_SUP_USFLAG
, VSA.ADDRESS_LINE1
, VSA.ADDRESS_LINE2
, VSA.ADDRESS_LINE3
, VSA.ADDRESS_LINE4
, NULL ADDRTYPE
, VSA.CITY
, VSA.COUNTRY
, VSA.COUNTY
, VSA.VENDOR_SITE_CODE SITE_DESCRIPTN
, VSA.FAX_AREA_CODE || ' ' || VSA.FAX FAX
, VSA.ZIP POSTALCODE
, NVL(VSA.STATE
, VSA.PROVINCE) STATEPROVN
, VSA.AREA_CODE || ' ' || VSA.PHONE TELEPHONE
, NULL UA_VATCODE
, VSA.PURCHASING_SITE_FLAG UA_SITE_PURSITE
, VSA.PAY_SITE_FLAG UA_SITE_PAYSITE
, VSA.RFQ_ONLY_SITE_FLAG UA_SITE_RFQSITE
, VSA.PCARD_SITE_FLAG UA_SITE_PCSITE
, DECODE(VC.FIRST_NAME
, NULL
, NULL
, VC.FIRST_NAME ||' ') || DECODE(VC.MIDDLE_NAME
, NULL
, NULL
, VC.MIDDLE_NAME ||' ') || DECODE(VC.LAST_NAME
, NULL
, NULL
, VC.LAST_NAME ||' ') CONTACT_NAME
, VC.TITLE CONTACT_DESCRIPTN
, NULL CONTACT_EMAIL
, VSA.FAX_AREA_CODE || ' ' || VSA.FAX CONTACT_FAX
, VC.AREA_CODE || ' ' || VC.PHONE CONTACT_PHONE
FROM PO_HEADERS_ALL PHA
, PO_VENDORS VEN
, PO_VENDOR_CONTACTS VC
, PO_VENDOR_SITES_ALL VSA
WHERE VEN.VENDOR_ID (+) = PHA.VENDOR_ID
AND VC.VENDOR_CONTACT_ID (+) = PHA.VENDOR_CONTACT_ID
AND VSA.VENDOR_SITE_ID (+) = PHA.VENDOR_SITE_ID

Columns