View: PO_VENDOR_SITES_ALL

Product:	AP - Payables
Description:
Implementation/DBA Data:	APPS.PO_VENDOR_SITES_ALL

View Text

SELECT HL.ADDRESS_STYLE ADDRESS_STYLE
, PVS.LANGUAGE LANGUAGE
, HL.PROVINCE PROVINCE
, SUBSTR(HL.COUNTRY
, 1
, 25) COUNTRY
, PVS.AREA_CODE AREA_CODE
, PVS.PHONE PHONE
, PVS.CUSTOMER_NUM CUSTOMER_NUM
, PVS.SHIP_TO_LOCATION_ID SHIP_TO_LOCATION_ID
, PVS.BILL_TO_LOCATION_ID BILL_TO_LOCATION_ID
, PVS.SHIP_VIA_LOOKUP_CODE SHIP_VIA_LOOKUP_CODE
, PVS.FREIGHT_TERMS_LOOKUP_CODE FREIGHT_TERMS_LOOKUP_CODE
, PVS.FOB_LOOKUP_CODE FOB_LOOKUP_CODE
, DECODE(HPS.STATUS
, 'I'
, LEAST(NVL(HPS.END_DATE_ACTIVE
, SYSDATE-1)
, NVL(PVS.INACTIVE_DATE
, SYSDATE-1) )
, PVS.INACTIVE_DATE ) INACTIVE_DATE /* ADDED FOR BUG#9907167 */ /*
, PVS.INACTIVE_DATE INACTIVE_DATE COMMENTED FOR BUG#9907167 */
, PVS.FAX FAX
, PVS.FAX_AREA_CODE FAX_AREA_CODE
, PVS.TELEX TELEX
, PVS.TERMS_DATE_BASIS TERMS_DATE_BASIS
, PVS.DISTRIBUTION_SET_ID DISTRIBUTION_SET_ID
, PVS.ACCTS_PAY_CODE_COMBINATION_ID ACCTS_PAY_CODE_COMBINATION_ID
, PVS.PREPAY_CODE_COMBINATION_ID PREPAY_CODE_COMBINATION_ID
, PVS.PAY_GROUP_LOOKUP_CODE PAY_GROUP_LOOKUP_CODE
, PVS.PAYMENT_PRIORITY PAYMENT_PRIORITY
, PVS.TERMS_ID TERMS_ID
, PVS.INVOICE_AMOUNT_LIMIT INVOICE_AMOUNT_LIMIT
, PVS.PAY_DATE_BASIS_LOOKUP_CODE PAY_DATE_BASIS_LOOKUP_CODE
, PVS.ALWAYS_TAKE_DISC_FLAG ALWAYS_TAKE_DISC_FLAG
, PVS.INVOICE_CURRENCY_CODE INVOICE_CURRENCY_CODE
, PVS.PAYMENT_CURRENCY_CODE PAYMENT_CURRENCY_CODE
, HL.COUNTY COUNTY
, PVS.VENDOR_SITE_ID VENDOR_SITE_ID
, PVS.LAST_UPDATE_DATE LAST_UPDATE_DATE
, PVS.LAST_UPDATED_BY LAST_UPDATED_BY
, PVS.VENDOR_ID VENDOR_ID
, SUBSTR((CASE WHEN FND_GLOBAL.APPLICATION_SHORT_NAME = 'SQLAP' AND NVL(FND_GLOBAL.CONC_REQUEST_ID
, -1) = -1 AND HPS.PARTY_SITE_ID IS NULL THEN NVL((SELECT ALC.DISPLAYED_FIELD
FROM AP_LOOKUP_CODES ALC
WHERE ALC.LOOKUP_TYPE(+) = 'VENDOR_SITE_CODE'
AND ALC.LOOKUP_CODE(+) = PVS.VENDOR_SITE_CODE)
, PVS.VENDOR_SITE_CODE) ELSE PVS.VENDOR_SITE_CODE END)
, 1
, 15) VENDOR_SITE_CODE /* BUG 15966842 */
, PVS.VENDOR_SITE_CODE_ALT VENDOR_SITE_CODE_ALT
, PVS.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, PVS.CREATION_DATE CREATION_DATE
, PVS.CREATED_BY CREATED_BY
, PVS.PURCHASING_SITE_FLAG PURCHASING_SITE_FLAG
, PVS.RFQ_ONLY_SITE_FLAG RFQ_ONLY_SITE_FLAG
, PVS.PAY_SITE_FLAG PAY_SITE_FLAG
, PVS.ATTENTION_AR_FLAG ATTENTION_AR_FLAG
, HL.ADDRESS1 ADDRESS_LINE1
, HL.ADDRESS2 ADDRESS_LINE2
, HL.ADDRESS3 ADDRESS_LINE3
, HL. ADDRESS_LINES_PHONETIC ADDRESS_LINES_ALT
, HL.CITY CITY
, HL.STATE STATE
, SUBSTR(HL.POSTAL_CODE
, 1
, 20) ZIP
, PVS.HOLD_ALL_PAYMENTS_FLAG HOLD_ALL_PAYMENTS_FLAG
, PVS.HOLD_FUTURE_PAYMENTS_FLAG HOLD_FUTURE_PAYMENTS_FLAG
, PVS.HOLD_REASON HOLD_REASON
, PVS.HOLD_UNMATCHED_INVOICES_FLAG HOLD_UNMATCHED_INVOICES_FLAG
, PVS.TAX_REPORTING_SITE_FLAG TAX_REPORTING_SITE_FLAG
, PVS.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, PVS.ATTRIBUTE1 ATTRIBUTE1
, PVS.ATTRIBUTE2 ATTRIBUTE2
, PVS.ATTRIBUTE3 ATTRIBUTE3
, PVS.ATTRIBUTE4 ATTRIBUTE4
, PVS.ATTRIBUTE5 ATTRIBUTE5
, PVS.ATTRIBUTE6 ATTRIBUTE6
, PVS.ATTRIBUTE7 ATTRIBUTE7
, PVS.ATTRIBUTE8 ATTRIBUTE8
, PVS.ATTRIBUTE9 ATTRIBUTE9
, PVS.ATTRIBUTE10 ATTRIBUTE10
, PVS.ATTRIBUTE11 ATTRIBUTE11
, PVS.ATTRIBUTE12 ATTRIBUTE12
, PVS.ATTRIBUTE13 ATTRIBUTE13
, PVS.ATTRIBUTE14 ATTRIBUTE14
, PVS.ATTRIBUTE15 ATTRIBUTE15
, PVS.REQUEST_ID REQUEST_ID
, PVS.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PVS.PROGRAM_ID PROGRAM_ID
, PVS.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, PVS.VALIDATION_NUMBER VALIDATION_NUMBER
, PVS.EXCLUDE_FREIGHT_FROM_DISCOUNT EXCLUDE_FREIGHT_FROM_DISCOUNT
, PVS.BANK_CHARGE_BEARER BANK_CHARGE_BEARER
, PVS.ORG_ID ORG_ID
, PVS.CHECK_DIGITS CHECK_DIGITS
, HL.ADDRESS4 ADDRESS_LINE4
, PVS.ALLOW_AWT_FLAG ALLOW_AWT_FLAG
, PVS.AWT_GROUP_ID AWT_GROUP_ID
, PVS.PAY_AWT_GROUP_ID PAY_AWT_GROUP_ID
, PVS.DEFAULT_PAY_SITE_ID DEFAULT_PAY_SITE_ID
, PVS.PAY_ON_CODE PAY_ON_CODE
, PVS.PAY_ON_RECEIPT_SUMMARY_CODE PAY_ON_RECEIPT_SUMMARY_CODE
, PVS.GLOBAL_ATTRIBUTE_CATEGORY GLOBAL_ATTRIBUTE_CATEGORY
, PVS.GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE1
, PVS.GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE2
, PVS.GLOBAL_ATTRIBUTE3 GLOBAL_ATTRIBUTE3
, PVS.GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE4
, PVS.GLOBAL_ATTRIBUTE5 GLOBAL_ATTRIBUTE5
, PVS.GLOBAL_ATTRIBUTE6 GLOBAL_ATTRIBUTE6
, PVS.GLOBAL_ATTRIBUTE7 GLOBAL_ATTRIBUTE7
, PVS.GLOBAL_ATTRIBUTE8 GLOBAL_ATTRIBUTE8
, PVS.GLOBAL_ATTRIBUTE9 GLOBAL_ATTRIBUTE9
, PVS.GLOBAL_ATTRIBUTE10 GLOBAL_ATTRIBUTE10
, PVS.GLOBAL_ATTRIBUTE11 GLOBAL_ATTRIBUTE11
, PVS.GLOBAL_ATTRIBUTE12 GLOBAL_ATTRIBUTE12
, PVS.GLOBAL_ATTRIBUTE13 GLOBAL_ATTRIBUTE13
, PVS.GLOBAL_ATTRIBUTE14 GLOBAL_ATTRIBUTE14
, PVS.GLOBAL_ATTRIBUTE15 GLOBAL_ATTRIBUTE15
, PVS.GLOBAL_ATTRIBUTE16 GLOBAL_ATTRIBUTE16
, PVS.GLOBAL_ATTRIBUTE17 GLOBAL_ATTRIBUTE17
, PVS.GLOBAL_ATTRIBUTE18 GLOBAL_ATTRIBUTE18
, PVS.GLOBAL_ATTRIBUTE19 GLOBAL_ATTRIBUTE19
, PVS.GLOBAL_ATTRIBUTE20 GLOBAL_ATTRIBUTE20
, PVS.TP_HEADER_ID TP_HEADER_ID
, PVS.ECE_TP_LOCATION_CODE ECE_TP_LOCATION_CODE
, PVS.PCARD_SITE_FLAG PCARD_SITE_FLAG
, PVS.MATCH_OPTION MATCH_OPTION
, PVS.COUNTRY_OF_ORIGIN_CODE COUNTRY_OF_ORIGIN_CODE
, PVS.FUTURE_DATED_PAYMENT_CCID FUTURE_DATED_PAYMENT_CCID
, PVS.CREATE_DEBIT_MEMO_FLAG CREATE_DEBIT_MEMO_FLAG
, PVS.SUPPLIER_NOTIF_METHOD SUPPLIER_NOTIF_METHOD
, PVS.EMAIL_ADDRESS EMAIL_ADDRESS
, PVS.PRIMARY_PAY_SITE_FLAG PRIMARY_PAY_SITE_FLAG
, PVS.SHIPPING_CONTROL SHIPPING_CONTROL
, PVS.SELLING_COMPANY_IDENTIFIER SELLING_COMPANY_IDENTIFIER
, PVS.GAPLESS_INV_NUM_FLAG GAPLESS_INV_NUM_FLAG
, HPS.DUNS_NUMBER_C DUNS_NUMBER
, PVS.LOCATION_ID LOCATION_ID
, PVS.PARTY_SITE_ID PARTY_SITE_ID
, PVS.TOLERANCE_ID TOLERANCE_ID
, PVS.SERVICES_TOLERANCE_ID SERVICES_TOLERANCE_ID
, PVS.RETAINAGE_RATE RETAINAGE_RATE
, PVS.EDI_ID_NUMBER EDI_ID_NUMBER
, PVS.VAT_REGISTRATION_NUM VAT_REGISTRATION_NUM
, HL.LANGUAGE LANGUAGE_CODE --BUG 8211749 ADDED BACK BELOW 22 COLUMNS
, PVS.PAYMENT_METHOD_LOOKUP_CODE PAYMENT_METHOD_LOOKUP_CODE
, PVS.BANK_ACCOUNT_NAME BANK_ACCOUNT_NAME
, PVS.BANK_ACCOUNT_NUM BANK_ACCOUNT_NUM
, PVS.BANK_NUM BANK_NUM
, PVS.BANK_ACCOUNT_TYPE BANK_ACCOUNT_TYPE
, PVS.CURRENT_CATALOG_NUM CURRENT_CATALOG_NUM
, PVS.VAT_CODE VAT_CODE
, PVS.AP_TAX_ROUNDING_RULE AP_TAX_ROUNDING_RULE
, PVS.AUTO_TAX_CALC_FLAG AUTO_TAX_CALC_FLAG
, PVS.AUTO_TAX_CALC_OVERRIDE AUTO_TAX_CALC_OVERRIDE
, PVS.AMOUNT_INCLUDES_TAX_FLAG AMOUNT_INCLUDES_TAX_FLAG
, PVS.OFFSET_VAT_CODE OFFSET_VAT_CODE
, PVS.BANK_NUMBER BANK_NUMBER
, PVS.BANK_BRANCH_TYPE BANK_BRANCH_TYPE
, PVS.OFFSET_TAX_FLAG OFFSET_TAX_FLAG
, PVS.REMITTANCE_EMAIL REMITTANCE_EMAIL
, PVS.EDI_TRANSACTION_HANDLING EDI_TRANSACTION_HANDLING
, PVS.EDI_PAYMENT_METHOD EDI_PAYMENT_METHOD
, PVS.EDI_PAYMENT_FORMAT EDI_PAYMENT_FORMAT
, PVS.EDI_REMITTANCE_METHOD EDI_REMITTANCE_METHOD
, PVS.EDI_REMITTANCE_INSTRUCTION EDI_REMITTANCE_INSTRUCTION
, PVS.EXCLUSIVE_PAYMENT_FLAG EXCLUSIVE_PAYMENT_FLAG --BUG 9394198 ADDED BACK BELOW 8 COLUMNS
, PVS.CAGE_CODE CAGE_CODE
, PVS.LEGAL_BUSINESS_NAME LEGAL_BUSINESS_NAME
, PVS.DOING_BUS_AS_NAME DOING_BUS_AS_NAME
, PVS.DIVISION_NAME DIVISION_NAME
, PVS.SMALL_BUSINESS_CODE SMALL_BUSINESS_CODE
, PVS.CCR_COMMENTS CCR_COMMENTS
, PVS.DEBARMENT_START_DATE DEBARMENT_START_DATE
, PVS.DEBARMENT_END_DATE DEBARMENT_END_DATE
, HPS.STATUS STATUS
, HPS.END_DATE_ACTIVE END_DATE_ACTIVE FROM AP_SUPPLIER_SITES_ALL PVS
, HZ_PARTY_SITES HPS
, HZ_LOCATIONS HL WHERE PVS.LOCATION_ID = HL.LOCATION_ID(+)
AND PVS.PARTY_SITE_ID = HPS.PARTY_SITE_ID(+)