VIEW: APPS.ITG_SP_PO_PART_SUPPL_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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