VIEW: APPS.AP_PO_VENDOR_SITES_EXTRACT_V

Source

View Text - Preformatted

SELECT POS.attribute1 POS_Attribute1 ,POS.attribute10 POS_Attribute10 ,POS.attribute11 POS_Attribute11 ,POS.attribute12 POS_Attribute12 ,POS.attribute13 POS_Attribute13 ,POS.attribute14 POS_Attribute14 ,POS.attribute15 POS_Attribute15 ,POS.attribute2 POS_Attribute2 ,POS.attribute3 POS_Attribute3 ,POS.attribute4 POS_Attribute4 ,POS.attribute5 POS_Attribute5 ,POS.attribute6 POS_Attribute6 ,POS.attribute7 POS_Attribute7 ,POS.attribute8 POS_Attribute8 ,POS.attribute9 POS_Attribute9 ,POS.attribute_category POS_Attribute_category ,POS.address_line1 POS_address_line1 ,POS.address_line2 POS_address_line2 ,POS.address_line3 POS_address_line3 ,POS.address_line4 POS_address_line4 ,POS.address_lines_alt POS_address_lines_alt ,POS.city POS_City ,POS.county POS_County ,POS.country POS_Country ,POS.vendor_site_code POS_Vendor_Site_Code ,POS.Zip POS_Zip ,POS.province POS_Province ,POS.State POS_State ,POS.Vendor_Site_id POS_Vendor_Site_Id ,POS.GLOBAL_ATTRIBUTE1 POS_Global_Attribute_1 ,POS.GLOBAL_ATTRIBUTE2 POS_Global_Attribute_2 ,POS.GLOBAL_ATTRIBUTE3 POS_Global_Attribute_3 ,POS.GLOBAL_ATTRIBUTE4 POS_Global_Attribute_4 ,POS.GLOBAL_ATTRIBUTE5 POS_Global_Attribute_5 ,POS.GLOBAL_ATTRIBUTE6 POS_Global_Attribute_6 ,POS.GLOBAL_ATTRIBUTE7 POS_Global_Attribute_7 ,POS.GLOBAL_ATTRIBUTE8 POS_Global_Attribute_8 ,POS.GLOBAL_ATTRIBUTE9 POS_Global_Attribute_9 ,POS.GLOBAL_ATTRIBUTE10 POS_Global_Attribute_10 ,POS.GLOBAL_ATTRIBUTE11 POS_Global_Attribute_11 ,POS.GLOBAL_ATTRIBUTE12 POS_Global_Attribute_12 ,POS.GLOBAL_ATTRIBUTE13 POS_Global_Attribute_13 ,POS.GLOBAL_ATTRIBUTE14 POS_Global_Attribute_14 ,POS.GLOBAL_ATTRIBUTE15 POS_Global_Attribute_15 ,POS.GLOBAL_ATTRIBUTE16 POS_Global_Attribute_16 ,POS.GLOBAL_ATTRIBUTE17 POS_Global_Attribute_17 ,POS.GLOBAL_ATTRIBUTE18 POS_Global_Attribute_18 ,POS.GLOBAL_ATTRIBUTE19 POS_Global_Attribute_19 ,POS.GLOBAL_ATTRIBUTE20 POS_Global_Attribute_20 ,POS.GLOBAL_ATTRIBUTE_CATEGORY POS_Global_Attribute_Category ,POS.future_dated_payment_ccid POS_FDP_CCID ,POS.PARTY_SITE_ID POS_PARTY_SITE_ID ,POS.ORG_ID POS_ORG_ID ,POS.vendor_id POS_VENDOR_ID FROM AP_SUPPLIER_SITES_ALL POS UNION SELECT HPS.attribute1 POS_Attribute1 ,HPS.attribute10 POS_Attribute10 ,HPS.attribute11 POS_Attribute11 ,HPS.attribute12 POS_Attribute12 ,HPS.attribute13 POS_Attribute13 ,HPS.attribute14 POS_Attribute14 ,HPS.attribute15 POS_Attribute15 ,HPS.attribute2 POS_Attribute2 ,HPS.attribute3 POS_Attribute3 ,HPS.attribute4 POS_Attribute4 ,HPS.attribute5 POS_Attribute5 ,HPS.attribute6 POS_Attribute6 ,HPS.attribute7 POS_Attribute7 ,HPS.attribute8 POS_Attribute8 ,HPS.attribute9 POS_Attribute9 ,HPS.attribute_category POS_Attribute_category ,HL.address1 POS_address_line1 ,HL.address2 POS_address_line2 ,HL.address3 POS_address_line3 ,HL.address4 POS_address_line4 ,HL.ADDRESS_LINES_PHONETIC POS_address_lines_alt ,HL.city POS_City ,HL.county POS_County ,HL.country POS_Country ,NULL POS_Vendor_Site_Code ,substr(HL.POSTAL_CODE, 1, 20) POS_Zip ,HL.province POS_Province ,HL.State POS_State ,NULL POS_Vendor_Site_Id ,HPS.GLOBAL_ATTRIBUTE1 POS_Global_Attribute_1 ,HPS.GLOBAL_ATTRIBUTE2 POS_Global_Attribute_2 ,HPS.GLOBAL_ATTRIBUTE3 POS_Global_Attribute_3 ,HPS.GLOBAL_ATTRIBUTE4 POS_Global_Attribute_4 ,HPS.GLOBAL_ATTRIBUTE5 POS_Global_Attribute_5 ,HPS.GLOBAL_ATTRIBUTE6 POS_Global_Attribute_6 ,HPS.GLOBAL_ATTRIBUTE7 POS_Global_Attribute_7 ,HPS.GLOBAL_ATTRIBUTE8 POS_Global_Attribute_8 ,HPS.GLOBAL_ATTRIBUTE9 POS_Global_Attribute_9 ,HPS.GLOBAL_ATTRIBUTE10 POS_Global_Attribute_10 ,HPS.GLOBAL_ATTRIBUTE11 POS_Global_Attribute_11 ,HPS.GLOBAL_ATTRIBUTE12 POS_Global_Attribute_12 ,HPS.GLOBAL_ATTRIBUTE13 POS_Global_Attribute_13 ,HPS.GLOBAL_ATTRIBUTE14 POS_Global_Attribute_14 ,HPS.GLOBAL_ATTRIBUTE15 POS_Global_Attribute_15 ,HPS.GLOBAL_ATTRIBUTE16 POS_Global_Attribute_16 ,HPS.GLOBAL_ATTRIBUTE17 POS_Global_Attribute_17 ,HPS.GLOBAL_ATTRIBUTE18 POS_Global_Attribute_18 ,HPS.GLOBAL_ATTRIBUTE19 POS_Global_Attribute_19 ,HPS.GLOBAL_ATTRIBUTE20 POS_Global_Attribute_20 ,HPS.GLOBAL_ATTRIBUTE_CATEGORY POS_Global_Attribute_Category ,NULL POS_FDP_CCID ,HPS.PARTY_SITE_ID POS_PARTY_SITE_ID ,NULL POS_ORG_ID ,NULL POS_VENDOR_ID FROM HZ_PARTY_SITES HPS, HZ_LOCATIONS HL WHERE HL.LOCATION_ID = HPS.LOCATION_ID AND NOT EXISTS (SELECT 'X' FROM AP_SUPPLIERS ASUP WHERE ASUP.PARTY_ID = HPS.PARTY_ID)

View Text - HTML Formatted

SELECT POS.ATTRIBUTE1 POS_ATTRIBUTE1
, POS.ATTRIBUTE10 POS_ATTRIBUTE10
, POS.ATTRIBUTE11 POS_ATTRIBUTE11
, POS.ATTRIBUTE12 POS_ATTRIBUTE12
, POS.ATTRIBUTE13 POS_ATTRIBUTE13
, POS.ATTRIBUTE14 POS_ATTRIBUTE14
, POS.ATTRIBUTE15 POS_ATTRIBUTE15
, POS.ATTRIBUTE2 POS_ATTRIBUTE2
, POS.ATTRIBUTE3 POS_ATTRIBUTE3
, POS.ATTRIBUTE4 POS_ATTRIBUTE4
, POS.ATTRIBUTE5 POS_ATTRIBUTE5
, POS.ATTRIBUTE6 POS_ATTRIBUTE6
, POS.ATTRIBUTE7 POS_ATTRIBUTE7
, POS.ATTRIBUTE8 POS_ATTRIBUTE8
, POS.ATTRIBUTE9 POS_ATTRIBUTE9
, POS.ATTRIBUTE_CATEGORY POS_ATTRIBUTE_CATEGORY
, POS.ADDRESS_LINE1 POS_ADDRESS_LINE1
, POS.ADDRESS_LINE2 POS_ADDRESS_LINE2
, POS.ADDRESS_LINE3 POS_ADDRESS_LINE3
, POS.ADDRESS_LINE4 POS_ADDRESS_LINE4
, POS.ADDRESS_LINES_ALT POS_ADDRESS_LINES_ALT
, POS.CITY POS_CITY
, POS.COUNTY POS_COUNTY
, POS.COUNTRY POS_COUNTRY
, POS.VENDOR_SITE_CODE POS_VENDOR_SITE_CODE
, POS.ZIP POS_ZIP
, POS.PROVINCE POS_PROVINCE
, POS.STATE POS_STATE
, POS.VENDOR_SITE_ID POS_VENDOR_SITE_ID
, POS.GLOBAL_ATTRIBUTE1 POS_GLOBAL_ATTRIBUTE_1
, POS.GLOBAL_ATTRIBUTE2 POS_GLOBAL_ATTRIBUTE_2
, POS.GLOBAL_ATTRIBUTE3 POS_GLOBAL_ATTRIBUTE_3
, POS.GLOBAL_ATTRIBUTE4 POS_GLOBAL_ATTRIBUTE_4
, POS.GLOBAL_ATTRIBUTE5 POS_GLOBAL_ATTRIBUTE_5
, POS.GLOBAL_ATTRIBUTE6 POS_GLOBAL_ATTRIBUTE_6
, POS.GLOBAL_ATTRIBUTE7 POS_GLOBAL_ATTRIBUTE_7
, POS.GLOBAL_ATTRIBUTE8 POS_GLOBAL_ATTRIBUTE_8
, POS.GLOBAL_ATTRIBUTE9 POS_GLOBAL_ATTRIBUTE_9
, POS.GLOBAL_ATTRIBUTE10 POS_GLOBAL_ATTRIBUTE_10
, POS.GLOBAL_ATTRIBUTE11 POS_GLOBAL_ATTRIBUTE_11
, POS.GLOBAL_ATTRIBUTE12 POS_GLOBAL_ATTRIBUTE_12
, POS.GLOBAL_ATTRIBUTE13 POS_GLOBAL_ATTRIBUTE_13
, POS.GLOBAL_ATTRIBUTE14 POS_GLOBAL_ATTRIBUTE_14
, POS.GLOBAL_ATTRIBUTE15 POS_GLOBAL_ATTRIBUTE_15
, POS.GLOBAL_ATTRIBUTE16 POS_GLOBAL_ATTRIBUTE_16
, POS.GLOBAL_ATTRIBUTE17 POS_GLOBAL_ATTRIBUTE_17
, POS.GLOBAL_ATTRIBUTE18 POS_GLOBAL_ATTRIBUTE_18
, POS.GLOBAL_ATTRIBUTE19 POS_GLOBAL_ATTRIBUTE_19
, POS.GLOBAL_ATTRIBUTE20 POS_GLOBAL_ATTRIBUTE_20
, POS.GLOBAL_ATTRIBUTE_CATEGORY POS_GLOBAL_ATTRIBUTE_CATEGORY
, POS.FUTURE_DATED_PAYMENT_CCID POS_FDP_CCID
, POS.PARTY_SITE_ID POS_PARTY_SITE_ID
, POS.ORG_ID POS_ORG_ID
, POS.VENDOR_ID POS_VENDOR_ID
FROM AP_SUPPLIER_SITES_ALL POS UNION SELECT HPS.ATTRIBUTE1 POS_ATTRIBUTE1
, HPS.ATTRIBUTE10 POS_ATTRIBUTE10
, HPS.ATTRIBUTE11 POS_ATTRIBUTE11
, HPS.ATTRIBUTE12 POS_ATTRIBUTE12
, HPS.ATTRIBUTE13 POS_ATTRIBUTE13
, HPS.ATTRIBUTE14 POS_ATTRIBUTE14
, HPS.ATTRIBUTE15 POS_ATTRIBUTE15
, HPS.ATTRIBUTE2 POS_ATTRIBUTE2
, HPS.ATTRIBUTE3 POS_ATTRIBUTE3
, HPS.ATTRIBUTE4 POS_ATTRIBUTE4
, HPS.ATTRIBUTE5 POS_ATTRIBUTE5
, HPS.ATTRIBUTE6 POS_ATTRIBUTE6
, HPS.ATTRIBUTE7 POS_ATTRIBUTE7
, HPS.ATTRIBUTE8 POS_ATTRIBUTE8
, HPS.ATTRIBUTE9 POS_ATTRIBUTE9
, HPS.ATTRIBUTE_CATEGORY POS_ATTRIBUTE_CATEGORY
, HL.ADDRESS1 POS_ADDRESS_LINE1
, HL.ADDRESS2 POS_ADDRESS_LINE2
, HL.ADDRESS3 POS_ADDRESS_LINE3
, HL.ADDRESS4 POS_ADDRESS_LINE4
, HL.ADDRESS_LINES_PHONETIC POS_ADDRESS_LINES_ALT
, HL.CITY POS_CITY
, HL.COUNTY POS_COUNTY
, HL.COUNTRY POS_COUNTRY
, NULL POS_VENDOR_SITE_CODE
, SUBSTR(HL.POSTAL_CODE
, 1
, 20) POS_ZIP
, HL.PROVINCE POS_PROVINCE
, HL.STATE POS_STATE
, NULL POS_VENDOR_SITE_ID
, HPS.GLOBAL_ATTRIBUTE1 POS_GLOBAL_ATTRIBUTE_1
, HPS.GLOBAL_ATTRIBUTE2 POS_GLOBAL_ATTRIBUTE_2
, HPS.GLOBAL_ATTRIBUTE3 POS_GLOBAL_ATTRIBUTE_3
, HPS.GLOBAL_ATTRIBUTE4 POS_GLOBAL_ATTRIBUTE_4
, HPS.GLOBAL_ATTRIBUTE5 POS_GLOBAL_ATTRIBUTE_5
, HPS.GLOBAL_ATTRIBUTE6 POS_GLOBAL_ATTRIBUTE_6
, HPS.GLOBAL_ATTRIBUTE7 POS_GLOBAL_ATTRIBUTE_7
, HPS.GLOBAL_ATTRIBUTE8 POS_GLOBAL_ATTRIBUTE_8
, HPS.GLOBAL_ATTRIBUTE9 POS_GLOBAL_ATTRIBUTE_9
, HPS.GLOBAL_ATTRIBUTE10 POS_GLOBAL_ATTRIBUTE_10
, HPS.GLOBAL_ATTRIBUTE11 POS_GLOBAL_ATTRIBUTE_11
, HPS.GLOBAL_ATTRIBUTE12 POS_GLOBAL_ATTRIBUTE_12
, HPS.GLOBAL_ATTRIBUTE13 POS_GLOBAL_ATTRIBUTE_13
, HPS.GLOBAL_ATTRIBUTE14 POS_GLOBAL_ATTRIBUTE_14
, HPS.GLOBAL_ATTRIBUTE15 POS_GLOBAL_ATTRIBUTE_15
, HPS.GLOBAL_ATTRIBUTE16 POS_GLOBAL_ATTRIBUTE_16
, HPS.GLOBAL_ATTRIBUTE17 POS_GLOBAL_ATTRIBUTE_17
, HPS.GLOBAL_ATTRIBUTE18 POS_GLOBAL_ATTRIBUTE_18
, HPS.GLOBAL_ATTRIBUTE19 POS_GLOBAL_ATTRIBUTE_19
, HPS.GLOBAL_ATTRIBUTE20 POS_GLOBAL_ATTRIBUTE_20
, HPS.GLOBAL_ATTRIBUTE_CATEGORY POS_GLOBAL_ATTRIBUTE_CATEGORY
, NULL POS_FDP_CCID
, HPS.PARTY_SITE_ID POS_PARTY_SITE_ID
, NULL POS_ORG_ID
, NULL POS_VENDOR_ID
FROM HZ_PARTY_SITES HPS
, HZ_LOCATIONS HL
WHERE HL.LOCATION_ID = HPS.LOCATION_ID
AND NOT EXISTS (SELECT 'X'
FROM AP_SUPPLIERS ASUP
WHERE ASUP.PARTY_ID = HPS.PARTY_ID)