VIEW: APPS.AP_VENDORS_V

Source

View Text - Preformatted

SELECT PV.ROWID , PV.VENDOR_ID , PV.LAST_UPDATE_DATE , PV.LAST_UPDATED_BY , PV.VENDOR_NAME , PV.SEGMENT1 , PV.SUMMARY_FLAG , PV.ENABLED_FLAG , PV.LAST_UPDATE_LOGIN , PV.CREATION_DATE , PV.CREATED_BY , PV.EMPLOYEE_ID , PV.VENDOR_TYPE_LOOKUP_CODE , LC_TYPE.DISPLAYED_FIELD , PV.CUSTOMER_NUM , PV.ONE_TIME_FLAG , PV.PARENT_VENDOR_ID , PVP.VENDOR_NAME , PVP.SEGMENT1 /*, PV.SHIP_TO_LOCATION_ID , HR_SHIPTO.LOCATION_CODE , HR_SHIPTO.DESCRIPTION , PV.BILL_TO_LOCATION_ID , HR_BILLTO.LOCATION_CODE , HR_BILLTO.DESCRIPTION , PV.SHIP_VIA_LOOKUP_CODE , PV.FREIGHT_TERMS_LOOKUP_CODE , LC_TERMS.DISPLAYED_FIELD , PV.FOB_LOOKUP_CODE , LC_FOB.DISPLAYED_FIELD */ , PV.TERMS_ID , AT.NAME , PV.SET_OF_BOOKS_ID , PV.ALWAYS_TAKE_DISC_FLAG , PV.PAY_DATE_BASIS_LOOKUP_CODE , LC_PDATE.DISPLAYED_FIELD , PV.PAY_GROUP_LOOKUP_CODE , LC_GROUP.DISPLAYED_FIELD , PV.PAYMENT_PRIORITY , PV.INVOICE_CURRENCY_CODE , PV.INVOICE_AMOUNT_LIMIT , PV.HOLD_ALL_PAYMENTS_FLAG , PV.HOLD_FUTURE_PAYMENTS_FLAG , PV.HOLD_REASON /*, PV.DISTRIBUTION_SET_ID , AD.DISTRIBUTION_SET_NAME , PV.ACCTS_PAY_CODE_COMBINATION_ID , PV.PREPAY_CODE_COMBINATION_ID */ , PV.NUM_1099 , PV.TYPE_1099 , ATX.DESCRIPTION , PV.WITHHOLDING_STATUS_LOOKUP_CODE , LC_WH.DISPLAYED_FIELD , PV.WITHHOLDING_START_DATE , PV.ORGANIZATION_TYPE_LOOKUP_CODE , LC_ORG.DISPLAYED_FIELD /* eTax Uptake , PV.VAT_CODE */ , PV.START_DATE_ACTIVE , PV.END_DATE_ACTIVE , PV.QTY_RCV_TOLERANCE , PV.MINORITY_GROUP_LOOKUP_CODE , LC_MIN.DISPLAYED_FIELD , PV.WOMEN_OWNED_FLAG , PV.SMALL_BUSINESS_FLAG , PV.STANDARD_INDUSTRY_CLASS , PV.PURCHASING_HOLD_REASON , PV.HOLD_FLAG , PV.HOLD_BY , PV.HOLD_DATE , PV.TERMS_DATE_BASIS , PV.DAYS_EARLY_RECEIPT_ALLOWED , PV.DAYS_LATE_RECEIPT_ALLOWED , PV.ENFORCE_SHIP_TO_LOCATION_CODE , LC_SHIP.DISPLAYED_FIELD , PV.FEDERAL_REPORTABLE_FLAG , PV.HOLD_UNMATCHED_INVOICES_FLAG , PV.INSPECTION_REQUIRED_FLAG , PV.RECEIPT_REQUIRED_FLAG , PV.INSPECTION_REQUIRED_FLAG||PV.RECEIPT_REQUIRED_FLAG , PV.RECEIVING_ROUTING_ID , RH.ROUTING_NAME , PV.STATE_REPORTABLE_FLAG , PV.TAX_VERIFICATION_DATE , PV.AUTO_CALCULATE_INTEREST_FLAG , PV.NAME_CONTROL , PV.ALLOW_SUBSTITUTE_RECEIPTS_FLAG , PV.ALLOW_UNORDERED_RECEIPTS_FLAG , PV.RECEIPT_DAYS_EXCEPTION_CODE , LC_DAYS.DISPLAYED_FIELD , PV.QTY_RCV_EXCEPTION_CODE , LC_QTY.DISPLAYED_FIELD /* eTax Uptake , PV.OFFSET_TAX_FLAG */ , PV.EXCLUDE_FREIGHT_FROM_DISCOUNT , PV.VAT_REGISTRATION_NUM , PV.TAX_REPORTING_NAME , PV.ATTRIBUTE_CATEGORY , PV.PROGRAM_UPDATE_DATE , PV.PROGRAM_ID , PV.PROGRAM_APPLICATION_ID , PV.REQUEST_ID , PV.PAYMENT_CURRENCY_CODE , PV.AWT_GROUP_ID , AWT.NAME , PV.CHECK_DIGITS , PV.ALLOW_AWT_FLAG , PV.VALIDATION_NUMBER , PV.MIN_ORDER_AMOUNT , PV.ATTRIBUTE1 , PV.ATTRIBUTE2 , PV.ATTRIBUTE3 , PV.ATTRIBUTE4 , PV.ATTRIBUTE5 , PV.ATTRIBUTE6 , PV.ATTRIBUTE7 , PV.ATTRIBUTE8 , PV.ATTRIBUTE9 , PV.ATTRIBUTE10 , PV.ATTRIBUTE11 , PV.ATTRIBUTE12 , PV.ATTRIBUTE13 , PV.ATTRIBUTE14 , PV.ATTRIBUTE15 , LC_TYPE.INACTIVE_DATE , AT.END_DATE_ACTIVE /* , AD.INACTIVE_DATE , HR_SHIPTO.INACTIVE_DATE , HR_BILLTO.INACTIVE_DATE */ , LC_GROUP.INACTIVE_DATE , LC_MIN.INACTIVE_DATE , LC_QTY.INACTIVE_DATE /*, LC_FOB.INACTIVE_DATE , LC_TERMS.INACTIVE_DATE */ , PV.VENDOR_NAME_ALT , NVL(PV.BANK_CHARGE_BEARER,'I') /* eTax Uptake , NVL(PV.AP_TAX_ROUNDING_RULE,'N') , NVL(PV.AUTO_TAX_CALC_FLAG,'N') , NVL(PV.AUTO_TAX_CALC_OVERRIDE,'N') , NVL(PV.AMOUNT_INCLUDES_TAX_FLAG,'N') */ , PV.GLOBAL_ATTRIBUTE_CATEGORY GLOBAL_ATTRIBUTE_CATEGORY , PV.GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE1 , PV.GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE2 , PV.GLOBAL_ATTRIBUTE3 GLOBAL_ATTRIBUTE3 , PV.GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE4 , PV.GLOBAL_ATTRIBUTE5 GLOBAL_ATTRIBUTE5 , PV.GLOBAL_ATTRIBUTE6 GLOBAL_ATTRIBUTE6 , PV.GLOBAL_ATTRIBUTE7 GLOBAL_ATTRIBUTE7 , PV.GLOBAL_ATTRIBUTE8 GLOBAL_ATTRIBUTE8 , PV.GLOBAL_ATTRIBUTE9 GLOBAL_ATTRIBUTE9 , PV.GLOBAL_ATTRIBUTE10 GLOBAL_ATTRIBUTE10 , PV.GLOBAL_ATTRIBUTE11 GLOBAL_ATTRIBUTE11 , PV.GLOBAL_ATTRIBUTE12 GLOBAL_ATTRIBUTE12 , PV.GLOBAL_ATTRIBUTE13 GLOBAL_ATTRIBUTE13 , PV.GLOBAL_ATTRIBUTE14 GLOBAL_ATTRIBUTE14 , PV.GLOBAL_ATTRIBUTE15 GLOBAL_ATTRIBUTE15 , PV.GLOBAL_ATTRIBUTE16 GLOBAL_ATTRIBUTE16 , PV.GLOBAL_ATTRIBUTE17 GLOBAL_ATTRIBUTE17 , PV.GLOBAL_ATTRIBUTE18 GLOBAL_ATTRIBUTE18 , PV.GLOBAL_ATTRIBUTE19 GLOBAL_ATTRIBUTE19 , PV.GLOBAL_ATTRIBUTE20 GLOBAL_ATTRIBUTE20 , PV.MATCH_OPTION /*, PV.FUTURE_DATED_PAYMENT_CCID FUTURE_DATED_PAYMENT_CCID*/ , PV.CREATE_DEBIT_MEMO_FLAG , PV.NI_NUMBER FROM PO_LOOKUP_CODES LC_TYPE, /* PO_LOOKUP_CODES LC_TERMS, PO_LOOKUP_CODES LC_FOB, */ PO_LOOKUP_CODES LC_GROUP, PO_LOOKUP_CODES LC_WH, PO_LOOKUP_CODES LC_ORG, PO_LOOKUP_CODES LC_MIN, PO_LOOKUP_CODES LC_SHIP, PO_LOOKUP_CODES LC_DAYS, PO_LOOKUP_CODES LC_QTY, PO_LOOKUP_CODES LC_PDATE, PO_VENDORS PVP, /* AP_DISTRIBUTION_SETS AD, */ AP_TERMS AT, AP_INCOME_TAX_TYPES ATX, /* HR_LOCATIONS_ALL HR_SHIPTO, HR_LOCATIONS_ALL HR_BILLTO, */ PO_AGENTS PA, RCV_ROUTING_HEADERS RH, PO_VENDORS PV, AP_AWT_GROUPS AWT WHERE PVP.VENDOR_ID(+) = PV.PARENT_VENDOR_ID AND LC_TYPE.LOOKUP_CODE(+) = PV.VENDOR_TYPE_LOOKUP_CODE AND LC_TYPE.LOOKUP_TYPE(+) = 'VENDOR TYPE' /* AND LC_TERMS.LOOKUP_CODE(+) = PV.FREIGHT_TERMS_LOOKUP_CODE AND LC_TERMS.LOOKUP_TYPE(+) = 'FREIGHT TERMS' AND LC_FOB.LOOKUP_CODE(+) = PV.FOB_LOOKUP_CODE AND LC_FOB.LOOKUP_TYPE(+) = 'FOB' */ AND LC_GROUP.LOOKUP_CODE(+) = PV.PAY_GROUP_LOOKUP_CODE AND LC_GROUP.LOOKUP_TYPE(+) = 'PAY GROUP' AND LC_WH.LOOKUP_CODE(+) = PV.WITHHOLDING_STATUS_LOOKUP_CODE AND LC_WH.LOOKUP_TYPE(+) = 'WITHHOLDING STATUS' AND LC_ORG.LOOKUP_CODE(+) = PV.ORGANIZATION_TYPE_LOOKUP_CODE AND LC_ORG.LOOKUP_TYPE(+) = 'ORGANIZATION TYPE' AND LC_MIN.LOOKUP_CODE(+) = PV.MINORITY_GROUP_LOOKUP_CODE AND LC_MIN.LOOKUP_TYPE(+) = 'MINORITY GROUP' AND LC_SHIP.LOOKUP_CODE(+) = PV.ENFORCE_SHIP_TO_LOCATION_CODE AND LC_SHIP.LOOKUP_TYPE(+) = 'RECEIVING CONTROL LEVEL' AND LC_DAYS.LOOKUP_CODE(+) = PV.RECEIPT_DAYS_EXCEPTION_CODE AND LC_DAYS.LOOKUP_TYPE(+) = 'RECEIVING CONTROL LEVEL' AND LC_QTY.LOOKUP_CODE(+) = PV.QTY_RCV_EXCEPTION_CODE AND LC_QTY.LOOKUP_TYPE(+) = 'RECEIVING CONTROL LEVEL' AND LC_PDATE.LOOKUP_TYPE(+) = PV.PAY_DATE_BASIS_LOOKUP_CODE AND LC_PDATE.LOOKUP_TYPE(+) = 'PAY DATE BASIS' AND ATX.INCOME_TAX_TYPE(+) = PV.TYPE_1099 /* AND AD.DISTRIBUTION_SET_ID(+) = PV.DISTRIBUTION_SET_ID */ AND AT.TERM_ID(+) = PV.TERMS_ID /* AND HR_SHIPTO.LOCATION_ID(+) = PV.SHIP_TO_LOCATION_ID AND HR_BILLTO.LOCATION_ID(+) = PV.BILL_TO_LOCATION_ID */ AND PA.AGENT_ID(+) = PV.HOLD_BY AND AWT.GROUP_ID(+) = PV.AWT_GROUP_ID AND RH.ROUTING_HEADER_ID(+) = PV.RECEIVING_ROUTING_ID

View Text - HTML Formatted

SELECT PV.ROWID
, PV.VENDOR_ID
, PV.LAST_UPDATE_DATE
, PV.LAST_UPDATED_BY
, PV.VENDOR_NAME
, PV.SEGMENT1
, PV.SUMMARY_FLAG
, PV.ENABLED_FLAG
, PV.LAST_UPDATE_LOGIN
, PV.CREATION_DATE
, PV.CREATED_BY
, PV.EMPLOYEE_ID
, PV.VENDOR_TYPE_LOOKUP_CODE
, LC_TYPE.DISPLAYED_FIELD
, PV.CUSTOMER_NUM
, PV.ONE_TIME_FLAG
, PV.PARENT_VENDOR_ID
, PVP.VENDOR_NAME
, PVP.SEGMENT1 /*
, PV.SHIP_TO_LOCATION_ID
, HR_SHIPTO.LOCATION_CODE
, HR_SHIPTO.DESCRIPTION
, PV.BILL_TO_LOCATION_ID
, HR_BILLTO.LOCATION_CODE
, HR_BILLTO.DESCRIPTION
, PV.SHIP_VIA_LOOKUP_CODE
, PV.FREIGHT_TERMS_LOOKUP_CODE
, LC_TERMS.DISPLAYED_FIELD
, PV.FOB_LOOKUP_CODE
, LC_FOB.DISPLAYED_FIELD */
, PV.TERMS_ID
, AT.NAME
, PV.SET_OF_BOOKS_ID
, PV.ALWAYS_TAKE_DISC_FLAG
, PV.PAY_DATE_BASIS_LOOKUP_CODE
, LC_PDATE.DISPLAYED_FIELD
, PV.PAY_GROUP_LOOKUP_CODE
, LC_GROUP.DISPLAYED_FIELD
, PV.PAYMENT_PRIORITY
, PV.INVOICE_CURRENCY_CODE
, PV.INVOICE_AMOUNT_LIMIT
, PV.HOLD_ALL_PAYMENTS_FLAG
, PV.HOLD_FUTURE_PAYMENTS_FLAG
, PV.HOLD_REASON /*
, PV.DISTRIBUTION_SET_ID
, AD.DISTRIBUTION_SET_NAME
, PV.ACCTS_PAY_CODE_COMBINATION_ID
, PV.PREPAY_CODE_COMBINATION_ID */
, PV.NUM_1099
, PV.TYPE_1099
, ATX.DESCRIPTION
, PV.WITHHOLDING_STATUS_LOOKUP_CODE
, LC_WH.DISPLAYED_FIELD
, PV.WITHHOLDING_START_DATE
, PV.ORGANIZATION_TYPE_LOOKUP_CODE
, LC_ORG.DISPLAYED_FIELD /* ETAX UPTAKE
, PV.VAT_CODE */
, PV.START_DATE_ACTIVE
, PV.END_DATE_ACTIVE
, PV.QTY_RCV_TOLERANCE
, PV.MINORITY_GROUP_LOOKUP_CODE
, LC_MIN.DISPLAYED_FIELD
, PV.WOMEN_OWNED_FLAG
, PV.SMALL_BUSINESS_FLAG
, PV.STANDARD_INDUSTRY_CLASS
, PV.PURCHASING_HOLD_REASON
, PV.HOLD_FLAG
, PV.HOLD_BY
, PV.HOLD_DATE
, PV.TERMS_DATE_BASIS
, PV.DAYS_EARLY_RECEIPT_ALLOWED
, PV.DAYS_LATE_RECEIPT_ALLOWED
, PV.ENFORCE_SHIP_TO_LOCATION_CODE
, LC_SHIP.DISPLAYED_FIELD
, PV.FEDERAL_REPORTABLE_FLAG
, PV.HOLD_UNMATCHED_INVOICES_FLAG
, PV.INSPECTION_REQUIRED_FLAG
, PV.RECEIPT_REQUIRED_FLAG
, PV.INSPECTION_REQUIRED_FLAG||PV.RECEIPT_REQUIRED_FLAG
, PV.RECEIVING_ROUTING_ID
, RH.ROUTING_NAME
, PV.STATE_REPORTABLE_FLAG
, PV.TAX_VERIFICATION_DATE
, PV.AUTO_CALCULATE_INTEREST_FLAG
, PV.NAME_CONTROL
, PV.ALLOW_SUBSTITUTE_RECEIPTS_FLAG
, PV.ALLOW_UNORDERED_RECEIPTS_FLAG
, PV.RECEIPT_DAYS_EXCEPTION_CODE
, LC_DAYS.DISPLAYED_FIELD
, PV.QTY_RCV_EXCEPTION_CODE
, LC_QTY.DISPLAYED_FIELD /* ETAX UPTAKE
, PV.OFFSET_TAX_FLAG */
, PV.EXCLUDE_FREIGHT_FROM_DISCOUNT
, PV.VAT_REGISTRATION_NUM
, PV.TAX_REPORTING_NAME
, PV.ATTRIBUTE_CATEGORY
, PV.PROGRAM_UPDATE_DATE
, PV.PROGRAM_ID
, PV.PROGRAM_APPLICATION_ID
, PV.REQUEST_ID
, PV.PAYMENT_CURRENCY_CODE
, PV.AWT_GROUP_ID
, AWT.NAME
, PV.CHECK_DIGITS
, PV.ALLOW_AWT_FLAG
, PV.VALIDATION_NUMBER
, PV.MIN_ORDER_AMOUNT
, PV.ATTRIBUTE1
, PV.ATTRIBUTE2
, PV.ATTRIBUTE3
, PV.ATTRIBUTE4
, PV.ATTRIBUTE5
, PV.ATTRIBUTE6
, PV.ATTRIBUTE7
, PV.ATTRIBUTE8
, PV.ATTRIBUTE9
, PV.ATTRIBUTE10
, PV.ATTRIBUTE11
, PV.ATTRIBUTE12
, PV.ATTRIBUTE13
, PV.ATTRIBUTE14
, PV.ATTRIBUTE15
, LC_TYPE.INACTIVE_DATE
, AT.END_DATE_ACTIVE /*
, AD.INACTIVE_DATE
, HR_SHIPTO.INACTIVE_DATE
, HR_BILLTO.INACTIVE_DATE */
, LC_GROUP.INACTIVE_DATE
, LC_MIN.INACTIVE_DATE
, LC_QTY.INACTIVE_DATE /*
, LC_FOB.INACTIVE_DATE
, LC_TERMS.INACTIVE_DATE */
, PV.VENDOR_NAME_ALT
, NVL(PV.BANK_CHARGE_BEARER
, 'I') /* ETAX UPTAKE
, NVL(PV.AP_TAX_ROUNDING_RULE
, 'N')
, NVL(PV.AUTO_TAX_CALC_FLAG
, 'N')
, NVL(PV.AUTO_TAX_CALC_OVERRIDE
, 'N')
, NVL(PV.AMOUNT_INCLUDES_TAX_FLAG
, 'N') */
, PV.GLOBAL_ATTRIBUTE_CATEGORY GLOBAL_ATTRIBUTE_CATEGORY
, PV.GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE1
, PV.GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE2
, PV.GLOBAL_ATTRIBUTE3 GLOBAL_ATTRIBUTE3
, PV.GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE4
, PV.GLOBAL_ATTRIBUTE5 GLOBAL_ATTRIBUTE5
, PV.GLOBAL_ATTRIBUTE6 GLOBAL_ATTRIBUTE6
, PV.GLOBAL_ATTRIBUTE7 GLOBAL_ATTRIBUTE7
, PV.GLOBAL_ATTRIBUTE8 GLOBAL_ATTRIBUTE8
, PV.GLOBAL_ATTRIBUTE9 GLOBAL_ATTRIBUTE9
, PV.GLOBAL_ATTRIBUTE10 GLOBAL_ATTRIBUTE10
, PV.GLOBAL_ATTRIBUTE11 GLOBAL_ATTRIBUTE11
, PV.GLOBAL_ATTRIBUTE12 GLOBAL_ATTRIBUTE12
, PV.GLOBAL_ATTRIBUTE13 GLOBAL_ATTRIBUTE13
, PV.GLOBAL_ATTRIBUTE14 GLOBAL_ATTRIBUTE14
, PV.GLOBAL_ATTRIBUTE15 GLOBAL_ATTRIBUTE15
, PV.GLOBAL_ATTRIBUTE16 GLOBAL_ATTRIBUTE16
, PV.GLOBAL_ATTRIBUTE17 GLOBAL_ATTRIBUTE17
, PV.GLOBAL_ATTRIBUTE18 GLOBAL_ATTRIBUTE18
, PV.GLOBAL_ATTRIBUTE19 GLOBAL_ATTRIBUTE19
, PV.GLOBAL_ATTRIBUTE20 GLOBAL_ATTRIBUTE20
, PV.MATCH_OPTION /*
, PV.FUTURE_DATED_PAYMENT_CCID FUTURE_DATED_PAYMENT_CCID*/
, PV.CREATE_DEBIT_MEMO_FLAG
, PV.NI_NUMBER
FROM PO_LOOKUP_CODES LC_TYPE
, /* PO_LOOKUP_CODES LC_TERMS
, PO_LOOKUP_CODES LC_FOB
, */ PO_LOOKUP_CODES LC_GROUP
, PO_LOOKUP_CODES LC_WH
, PO_LOOKUP_CODES LC_ORG
, PO_LOOKUP_CODES LC_MIN
, PO_LOOKUP_CODES LC_SHIP
, PO_LOOKUP_CODES LC_DAYS
, PO_LOOKUP_CODES LC_QTY
, PO_LOOKUP_CODES LC_PDATE
, PO_VENDORS PVP
, /* AP_DISTRIBUTION_SETS AD
, */ AP_TERMS AT
, AP_INCOME_TAX_TYPES ATX
, /* HR_LOCATIONS_ALL HR_SHIPTO
, HR_LOCATIONS_ALL HR_BILLTO
, */ PO_AGENTS PA
, RCV_ROUTING_HEADERS RH
, PO_VENDORS PV
, AP_AWT_GROUPS AWT
WHERE PVP.VENDOR_ID(+) = PV.PARENT_VENDOR_ID
AND LC_TYPE.LOOKUP_CODE(+) = PV.VENDOR_TYPE_LOOKUP_CODE
AND LC_TYPE.LOOKUP_TYPE(+) = 'VENDOR TYPE' /*
AND LC_TERMS.LOOKUP_CODE(+) = PV.FREIGHT_TERMS_LOOKUP_CODE
AND LC_TERMS.LOOKUP_TYPE(+) = 'FREIGHT TERMS'
AND LC_FOB.LOOKUP_CODE(+) = PV.FOB_LOOKUP_CODE
AND LC_FOB.LOOKUP_TYPE(+) = 'FOB' */
AND LC_GROUP.LOOKUP_CODE(+) = PV.PAY_GROUP_LOOKUP_CODE
AND LC_GROUP.LOOKUP_TYPE(+) = 'PAY GROUP'
AND LC_WH.LOOKUP_CODE(+) = PV.WITHHOLDING_STATUS_LOOKUP_CODE
AND LC_WH.LOOKUP_TYPE(+) = 'WITHHOLDING STATUS'
AND LC_ORG.LOOKUP_CODE(+) = PV.ORGANIZATION_TYPE_LOOKUP_CODE
AND LC_ORG.LOOKUP_TYPE(+) = 'ORGANIZATION TYPE'
AND LC_MIN.LOOKUP_CODE(+) = PV.MINORITY_GROUP_LOOKUP_CODE
AND LC_MIN.LOOKUP_TYPE(+) = 'MINORITY GROUP'
AND LC_SHIP.LOOKUP_CODE(+) = PV.ENFORCE_SHIP_TO_LOCATION_CODE
AND LC_SHIP.LOOKUP_TYPE(+) = 'RECEIVING CONTROL LEVEL'
AND LC_DAYS.LOOKUP_CODE(+) = PV.RECEIPT_DAYS_EXCEPTION_CODE
AND LC_DAYS.LOOKUP_TYPE(+) = 'RECEIVING CONTROL LEVEL'
AND LC_QTY.LOOKUP_CODE(+) = PV.QTY_RCV_EXCEPTION_CODE
AND LC_QTY.LOOKUP_TYPE(+) = 'RECEIVING CONTROL LEVEL'
AND LC_PDATE.LOOKUP_TYPE(+) = PV.PAY_DATE_BASIS_LOOKUP_CODE
AND LC_PDATE.LOOKUP_TYPE(+) = 'PAY DATE BASIS'
AND ATX.INCOME_TAX_TYPE(+) = PV.TYPE_1099 /*
AND AD.DISTRIBUTION_SET_ID(+) = PV.DISTRIBUTION_SET_ID */
AND AT.TERM_ID(+) = PV.TERMS_ID /*
AND HR_SHIPTO.LOCATION_ID(+) = PV.SHIP_TO_LOCATION_ID
AND HR_BILLTO.LOCATION_ID(+) = PV.BILL_TO_LOCATION_ID */
AND PA.AGENT_ID(+) = PV.HOLD_BY
AND AWT.GROUP_ID(+) = PV.AWT_GROUP_ID
AND RH.ROUTING_HEADER_ID(+) = PV.RECEIVING_ROUTING_ID