AP_POZ_SITE_ADDR_ASSIGNMENT

Details

Schema: FUSION
Object owner: AP
Object type: VIEW

Columns

Name
ADDRESS_LINE1 ADDRESS_LINE2 ADDRESS_LINE3 ADDRESS_LINE4 ADDRESS_STYLE ADDRESS_LINES_ALT CITY STATE COUNTY COUNTRY ZIP PROVINCE LANGUAGE DUNS_NUMBER VENDOR_SITE_SPK_ID VENDOR_SITE_ID EFFECTIVE_END_DATE EFFECTIVE_START_DATE EFFECTIVE_SEQUENCE OBJECT_VERSION_NUMBER VENDOR_ID PRC_BU_ID LOCATION_ID PARTY_SITE_ID INACTIVE_SITE_DATE VENDOR_SITE_CODE PURCHASING_SITE_FLAG RFQ_ONLY_SITE_FLAG PAY_SITE_FLAG AWT_GROUP_ID SERVICES_TOLERANCE_ID TOLERANCE_ID TERMS_ID EXCLUDE_FREIGHT_FROM_DISCOUNT ALLOW_AWT_FLAG PAY_ON_CODE DEFAULT_PAY_SITE_ID PAY_ON_RECEIPT_SUMMARY_CODE PCARD_SITE_FLAG MATCH_OPTION COUNTRY_OF_ORIGIN_CODE CREATE_DEBIT_MEMO_FLAG SUPPLIER_NOTIF_METHOD EMAIL_ADDRESS PRIMARY_PAY_SITE_FLAG SHIPPING_CONTROL SELLING_COMPANY_IDENTIFIER GAPLESS_INV_NUM_FLAG RETAINAGE_RATE AUTO_CALCULATE_INTEREST_FLAG HOLD_BY HOLD_DATE HOLD_FLAG PURCHASING_HOLD_REASON VENDOR_SITE_CODE_ALT ATTENTION_AR_FLAG AREA_CODE PHONE CUSTOMER_NUM FREIGHT_TERMS_LOOKUP_CODE FOB_LOOKUP_CODE FAX FAX_AREA_CODE TERMS_DATE_BASIS PAY_GROUP_LOOKUP_CODE PAYMENT_PRIORITY INVOICE_AMOUNT_LIMIT PAY_DATE_BASIS_LOOKUP_CODE ALWAYS_TAKE_DISC_FLAG INVOICE_CURRENCY_CODE PAYMENT_CURRENCY_CODE HOLD_ALL_PAYMENTS_FLAG HOLD_FUTURE_PAYMENTS_FLAG HOLD_REASON HOLD_UNMATCHED_INVOICES_FLAG TAX_REPORTING_SITE_FLAG LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN CREATION_DATE CREATED_BY REQUEST_ID PROGRAM_APPLICATION_ID PROGRAM_ID PROGRAM_UPDATE_DATE ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE3 GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE5 GLOBAL_ATTRIBUTE6 GLOBAL_ATTRIBUTE7 GLOBAL_ATTRIBUTE8 GLOBAL_ATTRIBUTE9 GLOBAL_ATTRIBUTE10 GLOBAL_ATTRIBUTE11 GLOBAL_ATTRIBUTE12 GLOBAL_ATTRIBUTE13 GLOBAL_ATTRIBUTE14 GLOBAL_ATTRIBUTE15 GLOBAL_ATTRIBUTE16 GLOBAL_ATTRIBUTE17 GLOBAL_ATTRIBUTE18 GLOBAL_ATTRIBUTE19 GLOBAL_ATTRIBUTE20 GLOBAL_ATTRIBUTE_CATEGORY ALLOW_SUBSTITUTE_RECEIPTS_FLAG ALLOW_UNORDERED_RECEIPTS_FLAG DAYS_EARLY_RECEIPT_ALLOWED DAYS_LATE_RECEIPT_ALLOWED ENFORCE_SHIP_TO_LOCATION_CODE INSPECTION_REQUIRED_FLAG QTY_RCV_EXCEPTION_CODE RECEIPT_DAYS_EXCEPTION_CODE QTY_RCV_TOLERANCE RECEIPT_REQUIRED_FLAG RECEIVING_ROUTING_ID ACCTS_PAY_CODE_COMBINATION_ID BILL_TO_LOCATION_ID DISTRIBUTION_SET_ID FUTURE_DATED_PAYMENT_CCID PREPAY_CODE_COMBINATION_ID SHIP_TO_LOCATION_ID BU_ID BUDGET_DATE_BASIS INACTIVE_ASSIGNMENT_DATE

Name

ADDRESS_LINE1

ADDRESS_LINE2

ADDRESS_LINE3

ADDRESS_LINE4

ADDRESS_STYLE

ADDRESS_LINES_ALT

CITY

STATE

COUNTY

COUNTRY

ZIP

PROVINCE

LANGUAGE

DUNS_NUMBER

VENDOR_SITE_SPK_ID

VENDOR_SITE_ID

EFFECTIVE_END_DATE

EFFECTIVE_START_DATE

EFFECTIVE_SEQUENCE

OBJECT_VERSION_NUMBER

VENDOR_ID

PRC_BU_ID

LOCATION_ID

PARTY_SITE_ID

INACTIVE_SITE_DATE

VENDOR_SITE_CODE

PURCHASING_SITE_FLAG

RFQ_ONLY_SITE_FLAG

PAY_SITE_FLAG

AWT_GROUP_ID

SERVICES_TOLERANCE_ID

TOLERANCE_ID

TERMS_ID

EXCLUDE_FREIGHT_FROM_DISCOUNT

ALLOW_AWT_FLAG

PAY_ON_CODE

DEFAULT_PAY_SITE_ID

PAY_ON_RECEIPT_SUMMARY_CODE

PCARD_SITE_FLAG

MATCH_OPTION

COUNTRY_OF_ORIGIN_CODE

CREATE_DEBIT_MEMO_FLAG

SUPPLIER_NOTIF_METHOD

EMAIL_ADDRESS

PRIMARY_PAY_SITE_FLAG

SHIPPING_CONTROL

SELLING_COMPANY_IDENTIFIER

GAPLESS_INV_NUM_FLAG

RETAINAGE_RATE

AUTO_CALCULATE_INTEREST_FLAG

HOLD_BY

HOLD_DATE

HOLD_FLAG

PURCHASING_HOLD_REASON

VENDOR_SITE_CODE_ALT

ATTENTION_AR_FLAG

AREA_CODE

PHONE

CUSTOMER_NUM

FREIGHT_TERMS_LOOKUP_CODE

FOB_LOOKUP_CODE

FAX

FAX_AREA_CODE

TERMS_DATE_BASIS

PAY_GROUP_LOOKUP_CODE

PAYMENT_PRIORITY

INVOICE_AMOUNT_LIMIT

PAY_DATE_BASIS_LOOKUP_CODE

ALWAYS_TAKE_DISC_FLAG

INVOICE_CURRENCY_CODE

PAYMENT_CURRENCY_CODE

HOLD_ALL_PAYMENTS_FLAG

HOLD_FUTURE_PAYMENTS_FLAG

HOLD_REASON

HOLD_UNMATCHED_INVOICES_FLAG

TAX_REPORTING_SITE_FLAG

LAST_UPDATE_DATE

LAST_UPDATED_BY

LAST_UPDATE_LOGIN

CREATION_DATE

CREATED_BY

REQUEST_ID

PROGRAM_APPLICATION_ID

PROGRAM_ID

PROGRAM_UPDATE_DATE

ATTRIBUTE_CATEGORY

ATTRIBUTE1

ATTRIBUTE2

ATTRIBUTE3

ATTRIBUTE4

ATTRIBUTE5

ATTRIBUTE6

ATTRIBUTE7

ATTRIBUTE8

ATTRIBUTE9

ATTRIBUTE10

ATTRIBUTE11

ATTRIBUTE12

ATTRIBUTE13

ATTRIBUTE14

ATTRIBUTE15

GLOBAL_ATTRIBUTE1

GLOBAL_ATTRIBUTE2

GLOBAL_ATTRIBUTE3

GLOBAL_ATTRIBUTE4

GLOBAL_ATTRIBUTE5

GLOBAL_ATTRIBUTE6

GLOBAL_ATTRIBUTE7

GLOBAL_ATTRIBUTE8

GLOBAL_ATTRIBUTE9

GLOBAL_ATTRIBUTE10

GLOBAL_ATTRIBUTE11

GLOBAL_ATTRIBUTE12

GLOBAL_ATTRIBUTE13

GLOBAL_ATTRIBUTE14

GLOBAL_ATTRIBUTE15

GLOBAL_ATTRIBUTE16

GLOBAL_ATTRIBUTE17

GLOBAL_ATTRIBUTE18

GLOBAL_ATTRIBUTE19

GLOBAL_ATTRIBUTE20

GLOBAL_ATTRIBUTE_CATEGORY

ALLOW_SUBSTITUTE_RECEIPTS_FLAG

ALLOW_UNORDERED_RECEIPTS_FLAG

DAYS_EARLY_RECEIPT_ALLOWED

DAYS_LATE_RECEIPT_ALLOWED

ENFORCE_SHIP_TO_LOCATION_CODE

INSPECTION_REQUIRED_FLAG

QTY_RCV_EXCEPTION_CODE

RECEIPT_DAYS_EXCEPTION_CODE

QTY_RCV_TOLERANCE

RECEIPT_REQUIRED_FLAG

RECEIVING_ROUTING_ID

ACCTS_PAY_CODE_COMBINATION_ID

BILL_TO_LOCATION_ID

DISTRIBUTION_SET_ID

FUTURE_DATED_PAYMENT_CCID

PREPAY_CODE_COMBINATION_ID

SHIP_TO_LOCATION_ID

BU_ID

BUDGET_DATE_BASIS

INACTIVE_ASSIGNMENT_DATE

Query

SQL_Statement
SELECT hzl.address1 ADDRESS_LINE1, hzl.address2 ADDRESS_LINE2, hzl.address3 ADDRESS_LINE3, hzl.address4 ADDRESS_LINE4, hzl.address_style ADDRESS_STYLE, hzl.address_lines_phonetic ADDRESS_LINES_ALT, hzl.city CITY, hzl.state STATE, hzl.county COUNTY, hzl.country COUNTRY, hzl.postal_code ZIP, hzl.province PROVINCE, hzl.location_language LANGUAGE, hps.duns_number_c DUNS_NUMBER, PVS.VENDOR_SITE_SPK_ID, PVS.VENDOR_SITE_ID, PVS.EFFECTIVE_END_DATE, PVS.EFFECTIVE_START_DATE, PVS.EFFECTIVE_SEQUENCE, PVS.OBJECT_VERSION_NUMBER, PVS.VENDOR_ID, PVS.PRC_BU_ID, PVS.LOCATION_ID, PVS.PARTY_SITE_ID, PVS.INACTIVE_DATE INACTIVE_SITE_DATE, PVS.VENDOR_SITE_CODE, PVS.PURCHASING_SITE_FLAG, PVS.RFQ_ONLY_SITE_FLAG, PVS.PAY_SITE_FLAG, PSA.AWT_GROUP_ID, PVS.SERVICES_TOLERANCE_ID, PVS.TOLERANCE_ID, NVL(PVS.TERMS_ID, ASP.TERMS_ID) TERMS_ID, NVL(PVS.EXCLUDE_FREIGHT_FROM_DISCOUNT, ASP.EXCLUDE_FREIGHT_FROM_DISCOUNT) EXCLUDE_FREIGHT_FROM_DISCOUNT, NVL(PSA.ALLOW_AWT_FLAG, 'N') ALLOW_AWT_FLAG, PVS.PAY_ON_CODE, PVS.DEFAULT_PAY_SITE_ID, PVS.PAY_ON_RECEIPT_SUMMARY_CODE, PVS.PCARD_SITE_FLAG, PVS.MATCH_OPTION, PVS.COUNTRY_OF_ORIGIN_CODE, PVS.CREATE_DEBIT_MEMO_FLAG, PVS.SUPPLIER_NOTIF_METHOD, PVS.EMAIL_ADDRESS, PVS.PRIMARY_PAY_SITE_FLAG, PVS.SHIPPING_CONTROL, PVS.SELLING_COMPANY_IDENTIFIER, NVL(PVS.GAPLESS_INV_NUM_FLAG, FSP.GAPLESS_INV_NUM_FLAG) GAPLESS_INV_NUM_FLAG, PVS.RETAINAGE_RATE, PVS.AUTO_CALCULATE_INTEREST_FLAG AUTO_CALCULATE_INTEREST_FLAG, PVS.HOLD_BY, PVS.HOLD_DATE, PVS.HOLD_FLAG, PVS.PURCHASING_HOLD_REASON, PVS.VENDOR_SITE_CODE_ALT, PVS.ATTENTION_AR_FLAG, PVS.AREA_CODE, PVS.PHONE, PVS.CUSTOMER_NUM, PVS.FREIGHT_TERMS_LOOKUP_CODE, PVS.FOB_LOOKUP_CODE, PVS.FAX, PVS.FAX_AREA_CODE, NVL(PVS.TERMS_DATE_BASIS, ASP.TERMS_DATE_BASIS) TERMS_DATE_BASIS, NVL(PVS.PAY_GROUP_LOOKUP_CODE, ASP.VENDOR_PAY_GROUP_LOOKUP_CODE) PAY_GROUP_LOOKUP_CODE, NVL(PVS.PAYMENT_PRIORITY, ASP.PAYMENT_PRIORITY) PAYMENT_PRIORITY, PVS.INVOICE_AMOUNT_LIMIT, NVL(PVS.PAY_DATE_BASIS_LOOKUP_CODE, ASP.PAY_DATE_BASIS_LOOKUP_CODE) PAY_DATE_BASIS_LOOKUP_CODE, NVL(PVS.ALWAYS_TAKE_DISC_FLAG, ASP.ALWAYS_TAKE_DISC_FLAG) ALWAYS_TAKE_DISC_FLAG, NVL(PVS.INVOICE_CURRENCY_CODE, ASP.INVOICE_CURRENCY_CODE) INVOICE_CURRENCY_CODE, NVL(PVS.PAYMENT_CURRENCY_CODE, ASP.PAYMENT_CURRENCY_CODE) PAYMENT_CURRENCY_CODE, PVS.HOLD_ALL_PAYMENTS_FLAG, PVS.HOLD_FUTURE_PAYMENTS_FLAG, PVS.HOLD_REASON, NVL(PVS.HOLD_UNMATCHED_INVOICES_FLAG, NVL(FSP.HOLD_UNMATCHED_INVOICES_FLAG,'N')) HOLD_UNMATCHED_INVOICES_FLAG, PVS.TAX_REPORTING_SITE_FLAG, PVS.LAST_UPDATE_DATE, PVS.LAST_UPDATED_BY, PVS.LAST_UPDATE_LOGIN, PVS.CREATION_DATE, PVS.CREATED_BY, PVS.REQUEST_ID, PVS.PROGRAM_APPLICATION_ID, PVS.PROGRAM_ID, PVS.PROGRAM_UPDATE_DATE, PVS.ATTRIBUTE_CATEGORY, PVS.ATTRIBUTE1, PVS.ATTRIBUTE2, PVS.ATTRIBUTE3, PVS.ATTRIBUTE4, PVS.ATTRIBUTE5, PVS.ATTRIBUTE6, PVS.ATTRIBUTE7, PVS.ATTRIBUTE8, PVS.ATTRIBUTE9, PVS.ATTRIBUTE10, PVS.ATTRIBUTE11, PVS.ATTRIBUTE12, PVS.ATTRIBUTE13, PVS.ATTRIBUTE14, PVS.ATTRIBUTE15, PVS.GLOBAL_ATTRIBUTE1, PVS.GLOBAL_ATTRIBUTE2, PVS.GLOBAL_ATTRIBUTE3, PVS.GLOBAL_ATTRIBUTE4, PVS.GLOBAL_ATTRIBUTE5, PVS.GLOBAL_ATTRIBUTE6, PVS.GLOBAL_ATTRIBUTE7, PVS.GLOBAL_ATTRIBUTE8, PVS.GLOBAL_ATTRIBUTE9, PVS.GLOBAL_ATTRIBUTE10, PVS.GLOBAL_ATTRIBUTE11, PVS.GLOBAL_ATTRIBUTE12, PVS.GLOBAL_ATTRIBUTE13, PVS.GLOBAL_ATTRIBUTE14, PVS.GLOBAL_ATTRIBUTE15, PVS.GLOBAL_ATTRIBUTE16, PVS.GLOBAL_ATTRIBUTE17, PVS.GLOBAL_ATTRIBUTE18, PVS.GLOBAL_ATTRIBUTE19, PVS.GLOBAL_ATTRIBUTE20, PVS.GLOBAL_ATTRIBUTE_CATEGORY, PVS.ALLOW_SUBSTITUTE_RECEIPTS_FLAG, PVS.ALLOW_UNORDERED_RECEIPTS_FLAG, PVS.DAYS_EARLY_RECEIPT_ALLOWED, PVS.DAYS_LATE_RECEIPT_ALLOWED, PVS.ENFORCE_SHIP_TO_LOCATION_CODE, PVS.INSPECTION_REQUIRED_FLAG, PVS.QTY_RCV_EXCEPTION_CODE, PVS.RECEIPT_DAYS_EXCEPTION_CODE, PVS.QTY_RCV_TOLERANCE, PVS.RECEIPT_REQUIRED_FLAG, PVS.RECEIVING_ROUTING_ID, NVL(PSA.ACCTS_PAY_CODE_COMBINATION_ID, FSP.ACCTS_PAY_CODE_COMBINATION_ID) ACCTS_PAY_CODE_COMBINATION_ID, PSA.BILL_TO_LOCATION_ID, PSA.DISTRIBUTION_SET_ID, NVL(PSA.FUTURE_DATED_PAYMENT_CCID, FSP.FUTURE_DATED_PAYMENT_CCID) FUTURE_DATED_PAYMENT_CCID, NVL(PSA.PREPAY_CODE_COMBINATION_ID, FSP.PREPAY_CODE_COMBINATION_ID) PREPAY_CODE_COMBINATION_ID, PSA.SHIP_TO_LOCATION_ID, PSA.BU_ID, ASP.BUDGET_DATE_BASIS, PSA.INACTIVE_DATE INACTIVE_ASSIGNMENT_DATE FROM POZ_SUPPLIER_SITES_ALL_M PVS, HZ_LOCATIONS hzl, HZ_PARTY_SITES HPS, POZ_SITE_ASSIGNMENTS_ALL_M PSA, AP_SYSTEM_PARAMETERS_ALL ASP, FINANCIALS_SYSTEM_PARAMS_ALL FSP WHERE hzl.location_id = pvs.location_id AND hps.party_site_id = pvs.party_site_id AND pvs.vendor_site_id = psa.vendor_site_id AND pvs.pay_site_flag = 'Y' /* AND TRUNC(sysdate) BETWEEN pvs.effective_start_date AND pvs.effective_end_date AND pvs.effective_sequence = 9999 AND TRUNC(sysdate) BETWEEN psa.effective_start_date AND psa.effective_end_date AND psa.effective_sequence = 9999 / / AND trunc(NVL (psa.inactive_date,sysdate+1)) > trunc(sysdate) AND trunc (NVL(pvs.inactive_date,sysdate+1)) > trunc(sysdate) */ AND PSA.BU_ID = ASP.ORG_ID AND PSA.BU_ID = FSP.ORG_ID

SQL_Statement

SELECT hzl.address1 ADDRESS_LINE1,

hzl.address2 ADDRESS_LINE2,

hzl.address3 ADDRESS_LINE3,

hzl.address4 ADDRESS_LINE4,

hzl.address_style ADDRESS_STYLE,

hzl.address_lines_phonetic ADDRESS_LINES_ALT,

hzl.city CITY,

hzl.state STATE,

hzl.county COUNTY,

hzl.country COUNTRY,

hzl.postal_code ZIP,

hzl.province PROVINCE,

hzl.location_language LANGUAGE,

hps.duns_number_c DUNS_NUMBER,

PVS.VENDOR_SITE_SPK_ID,

PVS.VENDOR_SITE_ID,

PVS.EFFECTIVE_END_DATE,

PVS.EFFECTIVE_START_DATE,

PVS.EFFECTIVE_SEQUENCE,

PVS.OBJECT_VERSION_NUMBER,

PVS.VENDOR_ID,

PVS.PRC_BU_ID,

PVS.LOCATION_ID,

PVS.PARTY_SITE_ID,

PVS.INACTIVE_DATE INACTIVE_SITE_DATE,

PVS.VENDOR_SITE_CODE,

PVS.PURCHASING_SITE_FLAG,

PVS.RFQ_ONLY_SITE_FLAG,

PVS.PAY_SITE_FLAG,

PSA.AWT_GROUP_ID,

PVS.SERVICES_TOLERANCE_ID,

PVS.TOLERANCE_ID,

NVL(PVS.TERMS_ID, ASP.TERMS_ID) TERMS_ID,

NVL(PVS.EXCLUDE_FREIGHT_FROM_DISCOUNT, ASP.EXCLUDE_FREIGHT_FROM_DISCOUNT) EXCLUDE_FREIGHT_FROM_DISCOUNT,

NVL(PSA.ALLOW_AWT_FLAG, 'N') ALLOW_AWT_FLAG,

PVS.PAY_ON_CODE,

PVS.DEFAULT_PAY_SITE_ID,

PVS.PAY_ON_RECEIPT_SUMMARY_CODE,

PVS.PCARD_SITE_FLAG,

PVS.MATCH_OPTION,

PVS.COUNTRY_OF_ORIGIN_CODE,

PVS.CREATE_DEBIT_MEMO_FLAG,

PVS.SUPPLIER_NOTIF_METHOD,

PVS.EMAIL_ADDRESS,

PVS.PRIMARY_PAY_SITE_FLAG,

PVS.SHIPPING_CONTROL,

PVS.SELLING_COMPANY_IDENTIFIER,

NVL(PVS.GAPLESS_INV_NUM_FLAG, FSP.GAPLESS_INV_NUM_FLAG) GAPLESS_INV_NUM_FLAG,

PVS.RETAINAGE_RATE,

PVS.AUTO_CALCULATE_INTEREST_FLAG AUTO_CALCULATE_INTEREST_FLAG,

PVS.HOLD_BY,

PVS.HOLD_DATE,

PVS.HOLD_FLAG,

PVS.PURCHASING_HOLD_REASON,

PVS.VENDOR_SITE_CODE_ALT,

PVS.ATTENTION_AR_FLAG,

PVS.AREA_CODE,

PVS.PHONE,

PVS.CUSTOMER_NUM,

PVS.FREIGHT_TERMS_LOOKUP_CODE,

PVS.FOB_LOOKUP_CODE,

PVS.FAX,

PVS.FAX_AREA_CODE,

NVL(PVS.TERMS_DATE_BASIS, ASP.TERMS_DATE_BASIS) TERMS_DATE_BASIS,

NVL(PVS.PAY_GROUP_LOOKUP_CODE, ASP.VENDOR_PAY_GROUP_LOOKUP_CODE) PAY_GROUP_LOOKUP_CODE,

NVL(PVS.PAYMENT_PRIORITY, ASP.PAYMENT_PRIORITY) PAYMENT_PRIORITY,

PVS.INVOICE_AMOUNT_LIMIT,

NVL(PVS.PAY_DATE_BASIS_LOOKUP_CODE, ASP.PAY_DATE_BASIS_LOOKUP_CODE) PAY_DATE_BASIS_LOOKUP_CODE,

NVL(PVS.ALWAYS_TAKE_DISC_FLAG, ASP.ALWAYS_TAKE_DISC_FLAG) ALWAYS_TAKE_DISC_FLAG,

NVL(PVS.INVOICE_CURRENCY_CODE, ASP.INVOICE_CURRENCY_CODE) INVOICE_CURRENCY_CODE,

NVL(PVS.PAYMENT_CURRENCY_CODE, ASP.PAYMENT_CURRENCY_CODE) PAYMENT_CURRENCY_CODE,

PVS.HOLD_ALL_PAYMENTS_FLAG,

PVS.HOLD_FUTURE_PAYMENTS_FLAG,

PVS.HOLD_REASON,

NVL(PVS.HOLD_UNMATCHED_INVOICES_FLAG, NVL(FSP.HOLD_UNMATCHED_INVOICES_FLAG,'N')) HOLD_UNMATCHED_INVOICES_FLAG,

PVS.TAX_REPORTING_SITE_FLAG,

PVS.LAST_UPDATE_DATE,

PVS.LAST_UPDATED_BY,

PVS.LAST_UPDATE_LOGIN,

PVS.CREATION_DATE,

PVS.CREATED_BY,

PVS.REQUEST_ID,

PVS.PROGRAM_APPLICATION_ID,

PVS.PROGRAM_ID,

PVS.PROGRAM_UPDATE_DATE,

PVS.ATTRIBUTE_CATEGORY,

PVS.ATTRIBUTE1,

PVS.ATTRIBUTE2,

PVS.ATTRIBUTE3,

PVS.ATTRIBUTE4,

PVS.ATTRIBUTE5,

PVS.ATTRIBUTE6,

PVS.ATTRIBUTE7,

PVS.ATTRIBUTE8,

PVS.ATTRIBUTE9,

PVS.ATTRIBUTE10,

PVS.ATTRIBUTE11,

PVS.ATTRIBUTE12,

PVS.ATTRIBUTE13,

PVS.ATTRIBUTE14,

PVS.ATTRIBUTE15,

PVS.GLOBAL_ATTRIBUTE1,

PVS.GLOBAL_ATTRIBUTE2,

PVS.GLOBAL_ATTRIBUTE3,

PVS.GLOBAL_ATTRIBUTE4,

PVS.GLOBAL_ATTRIBUTE5,

PVS.GLOBAL_ATTRIBUTE6,

PVS.GLOBAL_ATTRIBUTE7,

PVS.GLOBAL_ATTRIBUTE8,

PVS.GLOBAL_ATTRIBUTE9,

PVS.GLOBAL_ATTRIBUTE10,

PVS.GLOBAL_ATTRIBUTE11,

PVS.GLOBAL_ATTRIBUTE12,

PVS.GLOBAL_ATTRIBUTE13,

PVS.GLOBAL_ATTRIBUTE14,

PVS.GLOBAL_ATTRIBUTE15,

PVS.GLOBAL_ATTRIBUTE16,

PVS.GLOBAL_ATTRIBUTE17,

PVS.GLOBAL_ATTRIBUTE18,

PVS.GLOBAL_ATTRIBUTE19,

PVS.GLOBAL_ATTRIBUTE20,

PVS.GLOBAL_ATTRIBUTE_CATEGORY,

PVS.ALLOW_SUBSTITUTE_RECEIPTS_FLAG,

PVS.ALLOW_UNORDERED_RECEIPTS_FLAG,

PVS.DAYS_EARLY_RECEIPT_ALLOWED,

PVS.DAYS_LATE_RECEIPT_ALLOWED,

PVS.ENFORCE_SHIP_TO_LOCATION_CODE,

PVS.INSPECTION_REQUIRED_FLAG,

PVS.QTY_RCV_EXCEPTION_CODE,

PVS.RECEIPT_DAYS_EXCEPTION_CODE,

PVS.QTY_RCV_TOLERANCE,

PVS.RECEIPT_REQUIRED_FLAG,

PVS.RECEIVING_ROUTING_ID,

NVL(PSA.ACCTS_PAY_CODE_COMBINATION_ID, FSP.ACCTS_PAY_CODE_COMBINATION_ID) ACCTS_PAY_CODE_COMBINATION_ID,

PSA.BILL_TO_LOCATION_ID,

PSA.DISTRIBUTION_SET_ID,

NVL(PSA.FUTURE_DATED_PAYMENT_CCID, FSP.FUTURE_DATED_PAYMENT_CCID) FUTURE_DATED_PAYMENT_CCID,

NVL(PSA.PREPAY_CODE_COMBINATION_ID, FSP.PREPAY_CODE_COMBINATION_ID) PREPAY_CODE_COMBINATION_ID,

PSA.SHIP_TO_LOCATION_ID,

PSA.BU_ID,

ASP.BUDGET_DATE_BASIS,

PSA.INACTIVE_DATE INACTIVE_ASSIGNMENT_DATE

FROM POZ_SUPPLIER_SITES_ALL_M PVS,

HZ_LOCATIONS hzl,

HZ_PARTY_SITES HPS,

POZ_SITE_ASSIGNMENTS_ALL_M PSA,

AP_SYSTEM_PARAMETERS_ALL ASP,

FINANCIALS_SYSTEM_PARAMS_ALL FSP

WHERE hzl.location_id = pvs.location_id

AND hps.party_site_id = pvs.party_site_id

AND pvs.vendor_site_id = psa.vendor_site_id

AND pvs.pay_site_flag = 'Y'

/* AND TRUNC(sysdate) BETWEEN pvs.effective_start_date AND pvs.effective_end_date

AND pvs.effective_sequence = 9999

AND TRUNC(sysdate) BETWEEN psa.effective_start_date AND psa.effective_end_date

AND psa.effective_sequence = 9999 */

/*

AND trunc(NVL (psa.inactive_date,sysdate+1)) > trunc(sysdate)

AND trunc (NVL(pvs.inactive_date,sysdate+1)) > trunc(sysdate) */

AND PSA.BU_ID = ASP.ORG_ID

AND PSA.BU_ID = FSP.ORG_ID