FND Design Data [Home] [Help]

View: AP_PO_VENDOR_SITES_EXTRACT_V

Product: AP - Payables
Description:
Implementation/DBA Data: ViewAPPS.AP_PO_VENDOR_SITES_EXTRACT_V
View Text

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)

Columns

Name
POS_ATTRIBUTE1
POS_ATTRIBUTE10
POS_ATTRIBUTE11
POS_ATTRIBUTE12
POS_ATTRIBUTE13
POS_ATTRIBUTE14
POS_ATTRIBUTE15
POS_ATTRIBUTE2
POS_ATTRIBUTE3
POS_ATTRIBUTE4
POS_ATTRIBUTE5
POS_ATTRIBUTE6
POS_ATTRIBUTE7
POS_ATTRIBUTE8
POS_ATTRIBUTE9
POS_ATTRIBUTE_CATEGORY
POS_ADDRESS_LINE1
POS_ADDRESS_LINE2
POS_ADDRESS_LINE3
POS_ADDRESS_LINE4
POS_ADDRESS_LINES_ALT
POS_CITY
POS_COUNTY
POS_COUNTRY
POS_VENDOR_SITE_CODE
POS_ZIP
POS_PROVINCE
POS_STATE
POS_VENDOR_SITE_ID
POS_GLOBAL_ATTRIBUTE_1
POS_GLOBAL_ATTRIBUTE_2
POS_GLOBAL_ATTRIBUTE_3
POS_GLOBAL_ATTRIBUTE_4
POS_GLOBAL_ATTRIBUTE_5
POS_GLOBAL_ATTRIBUTE_6
POS_GLOBAL_ATTRIBUTE_7
POS_GLOBAL_ATTRIBUTE_8
POS_GLOBAL_ATTRIBUTE_9
POS_GLOBAL_ATTRIBUTE_10
POS_GLOBAL_ATTRIBUTE_11
POS_GLOBAL_ATTRIBUTE_12
POS_GLOBAL_ATTRIBUTE_13
POS_GLOBAL_ATTRIBUTE_14
POS_GLOBAL_ATTRIBUTE_15
POS_GLOBAL_ATTRIBUTE_16
POS_GLOBAL_ATTRIBUTE_17
POS_GLOBAL_ATTRIBUTE_18
POS_GLOBAL_ATTRIBUTE_19
POS_GLOBAL_ATTRIBUTE_20
POS_GLOBAL_ATTRIBUTE_CATEGORY
POS_FDP_CCID
POS_PARTY_SITE_ID
POS_ORG_ID
POS_VENDOR_ID