Product: | AP - Payables |
---|---|
Description: | |
Implementation/DBA Data: | APPS.AP_VENDORS_V |
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