POZ_SITE_ATTRIBUTES

Details

Schema: FUSION
Object owner: POZ
Object type: VIEW

Columns

Name
VENDOR_SITE_SPK_ID VENDOR_SITE_ID EFFECTIVE_END_DATE EFFECTIVE_START_DATE EFFECTIVE_SEQUENCE INACTIVE_DATE OBJECT_VERSION_NUMBER VENDOR_ID PRC_BU_ID LOCATION_ID PARTY_SITE_ID VENDOR_SITE_CODE PURCHASING_SITE_FLAG RFQ_ONLY_SITE_FLAG PAY_SITE_FLAG TP_HEADER_ID SERVICES_TOLERANCE_ID TOLERANCE_ID TERMS_ID EXCLUDE_FREIGHT_FROM_DISCOUNT ALLOW_AWT_FLAG BANK_CHARGE_BEARER PAY_ON_CODE DEFAULT_PAY_SITE_ID PAY_ON_RECEIPT_SUMMARY_CODE ECE_TP_LOCATION_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 SHIP_VIA_LOOKUP_CODE FREIGHT_TERMS_LOOKUP_CODE FOB_LOOKUP_CODE FAX FAX_AREA_CODE TELEX 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 ACCTS_PAY_CODE_COMBINATION_ID BILL_TO_LOCATION_ID DISTRIBUTION_SET_ID FUTURE_DATED_PAYMENT_CCID PREPAY_CODE_COMBINATION_ID SHIP_TO_LOCATION_ID DAYS_EARLY_RECEIPT_ALLOWED DAYS_LATE_RECEIPT_ALLOWED INSPECTION_REQUIRED_FLAG QTY_RCV_TOLERANCE RECEIPT_REQUIRED_FLAG RECEIVING_ROUTING_ID BU_ID AGENT_BU_ID BILL_TO_BU_ID ASSIGNMENT_ID ASSIGNMENT_SPK_ID ALLOW_SUBSTITUTE_RECEIPTS_FLAG ALLOW_UNORDERED_RECEIPTS_FLAG ENFORCE_SHIP_TO_LOCATION_CODE QTY_RCV_EXCEPTION_CODE RECEIPT_DAYS_EXCEPTION_CODE SHIPPING_NETWORK_LOCATION PHONE_COUNTRY_CODE PHONE_EXTENSION FAX_COUNTRY_CODE AGING_PERIOD_DAYS AGING_ONSET_POINT CONSUMPTION_ADVICE_FREQUENCY CONSUMPTION_ADVICE_SUMMARY PAY_ON_USE_FLAG MODE_OF_TRANSPORT SERVICE_LEVEL

Name

VENDOR_SITE_SPK_ID

VENDOR_SITE_ID

EFFECTIVE_END_DATE

EFFECTIVE_START_DATE

EFFECTIVE_SEQUENCE

INACTIVE_DATE

OBJECT_VERSION_NUMBER

VENDOR_ID

PRC_BU_ID

LOCATION_ID

PARTY_SITE_ID

VENDOR_SITE_CODE

PURCHASING_SITE_FLAG

RFQ_ONLY_SITE_FLAG

PAY_SITE_FLAG

TP_HEADER_ID

SERVICES_TOLERANCE_ID

TOLERANCE_ID

TERMS_ID

EXCLUDE_FREIGHT_FROM_DISCOUNT

ALLOW_AWT_FLAG

BANK_CHARGE_BEARER

PAY_ON_CODE

DEFAULT_PAY_SITE_ID

PAY_ON_RECEIPT_SUMMARY_CODE

ECE_TP_LOCATION_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

SHIP_VIA_LOOKUP_CODE

FREIGHT_TERMS_LOOKUP_CODE

FOB_LOOKUP_CODE

FAX

FAX_AREA_CODE

TELEX

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

ACCTS_PAY_CODE_COMBINATION_ID

BILL_TO_LOCATION_ID

DISTRIBUTION_SET_ID

FUTURE_DATED_PAYMENT_CCID

PREPAY_CODE_COMBINATION_ID

SHIP_TO_LOCATION_ID

DAYS_EARLY_RECEIPT_ALLOWED

DAYS_LATE_RECEIPT_ALLOWED

INSPECTION_REQUIRED_FLAG

QTY_RCV_TOLERANCE

RECEIPT_REQUIRED_FLAG

RECEIVING_ROUTING_ID

BU_ID

AGENT_BU_ID

BILL_TO_BU_ID

ASSIGNMENT_ID

ASSIGNMENT_SPK_ID

ALLOW_SUBSTITUTE_RECEIPTS_FLAG

ALLOW_UNORDERED_RECEIPTS_FLAG

ENFORCE_SHIP_TO_LOCATION_CODE

QTY_RCV_EXCEPTION_CODE

RECEIPT_DAYS_EXCEPTION_CODE

SHIPPING_NETWORK_LOCATION

PHONE_COUNTRY_CODE

PHONE_EXTENSION

FAX_COUNTRY_CODE

AGING_PERIOD_DAYS

AGING_ONSET_POINT

CONSUMPTION_ADVICE_FREQUENCY

CONSUMPTION_ADVICE_SUMMARY

PAY_ON_USE_FLAG

MODE_OF_TRANSPORT

SERVICE_LEVEL

Query

SQL_Statement
SELECT PVS.VENDOR_SITE_SPK_ID, PVS.VENDOR_SITE_ID, PVS.EFFECTIVE_END_DATE, PVS.EFFECTIVE_START_DATE, PVS.EFFECTIVE_SEQUENCE, PVS.INACTIVE_DATE, PVS.OBJECT_VERSION_NUMBER, PVS.VENDOR_ID, PVS.PRC_BU_ID, PVS.LOCATION_ID, PVS.PARTY_SITE_ID, PVS.VENDOR_SITE_CODE, PVS.PURCHASING_SITE_FLAG, PVS.RFQ_ONLY_SITE_FLAG, PVS.PAY_SITE_FLAG, PVS.TP_HEADER_ID, PVS.SERVICES_TOLERANCE_ID, PVS.TOLERANCE_ID, PVS.TERMS_ID, PVS.EXCLUDE_FREIGHT_FROM_DISCOUNT, PSA.ALLOW_AWT_FLAG, PVS.BANK_CHARGE_BEARER, PVS.PAY_ON_CODE, PVS.DEFAULT_PAY_SITE_ID, PVS.PAY_ON_RECEIPT_SUMMARY_CODE, PVS.ECE_TP_LOCATION_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, PVS.GAPLESS_INV_NUM_FLAG, PVS.RETAINAGE_RATE, PVS.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.SHIP_VIA_LOOKUP_CODE, PVS.FREIGHT_TERMS_LOOKUP_CODE, PVS.FOB_LOOKUP_CODE, PVS.FAX, PVS.FAX_AREA_CODE, PVS.TELEX, PVS.TERMS_DATE_BASIS, PVS.PAY_GROUP_LOOKUP_CODE, PVS.PAYMENT_PRIORITY, PVS.INVOICE_AMOUNT_LIMIT, PVS.PAY_DATE_BASIS_LOOKUP_CODE, PVS.ALWAYS_TAKE_DISC_FLAG, PVS.INVOICE_CURRENCY_CODE, PVS.PAYMENT_CURRENCY_CODE, PVS.HOLD_ALL_PAYMENTS_FLAG, PVS.HOLD_FUTURE_PAYMENTS_FLAG, PVS.HOLD_REASON, PVS.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, PSA.ACCTS_PAY_CODE_COMBINATION_ID, PSA.BILL_TO_LOCATION_ID, PSA.DISTRIBUTION_SET_ID, PSA.FUTURE_DATED_PAYMENT_CCID, PSA.PREPAY_CODE_COMBINATION_ID, PSA.SHIP_TO_LOCATION_ID, PVS.DAYS_EARLY_RECEIPT_ALLOWED, PVS.DAYS_LATE_RECEIPT_ALLOWED, PVS.INSPECTION_REQUIRED_FLAG, PVS.QTY_RCV_TOLERANCE, PVS.RECEIPT_REQUIRED_FLAG, PVS.RECEIVING_ROUTING_ID, PSA.BU_ID, PSA.AGENT_BU_ID, PSA.BILL_TO_BU_ID, PSA.ASSIGNMENT_ID, PSA.ASSIGNMENT_SPK_ID, PVS.ALLOW_SUBSTITUTE_RECEIPTS_FLAG, PVS.ALLOW_UNORDERED_RECEIPTS_FLAG, PVS.ENFORCE_SHIP_TO_LOCATION_CODE, PVS.QTY_RCV_EXCEPTION_CODE, PVS.RECEIPT_DAYS_EXCEPTION_CODE, PVS.SHIPPING_NETWORK_LOCATION, PVS.PHONE_COUNTRY_CODE, PVS.PHONE_EXTENSION, PVS.FAX_COUNTRY_CODE, PVS.AGING_PERIOD_DAYS, PVS.AGING_ONSET_POINT, PVS.CONSUMPTION_ADVICE_FREQUENCY, PVS.CONSUMPTION_ADVICE_SUMMARY, PVS.PAY_ON_USE_FLAG, PVS.MODE_OF_TRANSPORT, PVS.SERVICE_LEVEL FROM POZ_SUPPLIER_SITES_ALL_M PVS, POZ_SITE_ASSIGNMENTS_ALL_M PSA WHERE 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 PVS.VENDOR_SITE_ID = PSA.VENDOR_SITE_ID

SQL_Statement

SELECT

PVS.VENDOR_SITE_SPK_ID,

PVS.VENDOR_SITE_ID,

PVS.EFFECTIVE_END_DATE,

PVS.EFFECTIVE_START_DATE,

PVS.EFFECTIVE_SEQUENCE,

PVS.INACTIVE_DATE,

PVS.OBJECT_VERSION_NUMBER,

PVS.VENDOR_ID,

PVS.PRC_BU_ID,

PVS.LOCATION_ID,

PVS.PARTY_SITE_ID,

PVS.VENDOR_SITE_CODE,

PVS.PURCHASING_SITE_FLAG,

PVS.RFQ_ONLY_SITE_FLAG,

PVS.PAY_SITE_FLAG,

PVS.TP_HEADER_ID,

PVS.SERVICES_TOLERANCE_ID,

PVS.TOLERANCE_ID,

PVS.TERMS_ID,

PVS.EXCLUDE_FREIGHT_FROM_DISCOUNT,

PSA.ALLOW_AWT_FLAG,

PVS.BANK_CHARGE_BEARER,

PVS.PAY_ON_CODE,

PVS.DEFAULT_PAY_SITE_ID,

PVS.PAY_ON_RECEIPT_SUMMARY_CODE,

PVS.ECE_TP_LOCATION_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,

PVS.GAPLESS_INV_NUM_FLAG,

PVS.RETAINAGE_RATE,

PVS.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.SHIP_VIA_LOOKUP_CODE,

PVS.FREIGHT_TERMS_LOOKUP_CODE,

PVS.FOB_LOOKUP_CODE,

PVS.FAX,

PVS.FAX_AREA_CODE,

PVS.TELEX,

PVS.TERMS_DATE_BASIS,

PVS.PAY_GROUP_LOOKUP_CODE,

PVS.PAYMENT_PRIORITY,

PVS.INVOICE_AMOUNT_LIMIT,

PVS.PAY_DATE_BASIS_LOOKUP_CODE,

PVS.ALWAYS_TAKE_DISC_FLAG,

PVS.INVOICE_CURRENCY_CODE,

PVS.PAYMENT_CURRENCY_CODE,

PVS.HOLD_ALL_PAYMENTS_FLAG,

PVS.HOLD_FUTURE_PAYMENTS_FLAG,

PVS.HOLD_REASON,

PVS.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,

PSA.ACCTS_PAY_CODE_COMBINATION_ID,

PSA.BILL_TO_LOCATION_ID,

PSA.DISTRIBUTION_SET_ID,

PSA.FUTURE_DATED_PAYMENT_CCID,

PSA.PREPAY_CODE_COMBINATION_ID,

PSA.SHIP_TO_LOCATION_ID,

PVS.DAYS_EARLY_RECEIPT_ALLOWED,

PVS.DAYS_LATE_RECEIPT_ALLOWED,

PVS.INSPECTION_REQUIRED_FLAG,

PVS.QTY_RCV_TOLERANCE,

PVS.RECEIPT_REQUIRED_FLAG,

PVS.RECEIVING_ROUTING_ID,

PSA.BU_ID,

PSA.AGENT_BU_ID,

PSA.BILL_TO_BU_ID,

PSA.ASSIGNMENT_ID,

PSA.ASSIGNMENT_SPK_ID,

PVS.ALLOW_SUBSTITUTE_RECEIPTS_FLAG,

PVS.ALLOW_UNORDERED_RECEIPTS_FLAG,

PVS.ENFORCE_SHIP_TO_LOCATION_CODE,

PVS.QTY_RCV_EXCEPTION_CODE,

PVS.RECEIPT_DAYS_EXCEPTION_CODE,

PVS.SHIPPING_NETWORK_LOCATION,

PVS.PHONE_COUNTRY_CODE,

PVS.PHONE_EXTENSION,

PVS.FAX_COUNTRY_CODE,

PVS.AGING_PERIOD_DAYS,

PVS.AGING_ONSET_POINT,

PVS.CONSUMPTION_ADVICE_FREQUENCY,

PVS.CONSUMPTION_ADVICE_SUMMARY,

PVS.PAY_ON_USE_FLAG,

PVS.MODE_OF_TRANSPORT,

PVS.SERVICE_LEVEL

FROM

POZ_SUPPLIER_SITES_ALL_M PVS,

POZ_SITE_ASSIGNMENTS_ALL_M PSA

WHERE

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 PVS.VENDOR_SITE_ID = PSA.VENDOR_SITE_ID