VIEW: APPS.POS_PO_VENDORS_V

Source

View Text - Preformatted

SELECT "VENDOR_ID", "LAST_UPDATE_DATE", "LAST_UPDATED_BY", "VENDOR_NAME", "SEGMENT1", "SUMMARY_FLAG", "ENABLED_FLAG", "SEGMENT2", "SEGMENT3", "SEGMENT4", "SEGMENT5", "LAST_UPDATE_LOGIN", "CREATION_DATE", "CREATED_BY", "EMPLOYEE_ID", "VENDOR_TYPE_LOOKUP_CODE", "CUSTOMER_NUM", "ONE_TIME_FLAG", "PARENT_VENDOR_ID", "MIN_ORDER_AMOUNT", "TERMS_ID", "SET_OF_BOOKS_ID", "ALWAYS_TAKE_DISC_FLAG", "PAY_DATE_BASIS_LOOKUP_CODE", "PAY_GROUP_LOOKUP_CODE", "PAYMENT_PRIORITY", "INVOICE_CURRENCY_CODE", "PAYMENT_CURRENCY_CODE", "INVOICE_AMOUNT_LIMIT", "HOLD_ALL_PAYMENTS_FLAG", "HOLD_FUTURE_PAYMENTS_FLAG", "HOLD_REASON", "NUM_1099", "TYPE_1099", "WITHHOLDING_STATUS_LOOKUP_CODE", "WITHHOLDING_START_DATE", "ORGANIZATION_TYPE_LOOKUP_CODE", "START_DATE_ACTIVE", "END_DATE_ACTIVE", "MINORITY_GROUP_LOOKUP_CODE", "WOMEN_OWNED_FLAG", "SMALL_BUSINESS_FLAG", "STANDARD_INDUSTRY_CLASS", "HOLD_FLAG", "PURCHASING_HOLD_REASON", "HOLD_BY", "HOLD_DATE", "TERMS_DATE_BASIS", "INSPECTION_REQUIRED_FLAG", "RECEIPT_REQUIRED_FLAG", "QTY_RCV_TOLERANCE", "QTY_RCV_EXCEPTION_CODE", "ENFORCE_SHIP_TO_LOCATION_CODE", "DAYS_EARLY_RECEIPT_ALLOWED", "DAYS_LATE_RECEIPT_ALLOWED", "RECEIPT_DAYS_EXCEPTION_CODE", "RECEIVING_ROUTING_ID", "ALLOW_SUBSTITUTE_RECEIPTS_FLAG", "ALLOW_UNORDERED_RECEIPTS_FLAG", "HOLD_UNMATCHED_INVOICES_FLAG", "TAX_VERIFICATION_DATE", "NAME_CONTROL", "STATE_REPORTABLE_FLAG", "FEDERAL_REPORTABLE_FLAG", "ATTRIBUTE_CATEGORY", "ATTRIBUTE1", "ATTRIBUTE2", "ATTRIBUTE3", "ATTRIBUTE4", "ATTRIBUTE5", "ATTRIBUTE6", "ATTRIBUTE7", "ATTRIBUTE8", "ATTRIBUTE9", "ATTRIBUTE10", "ATTRIBUTE11", "ATTRIBUTE12", "ATTRIBUTE13", "ATTRIBUTE14", "ATTRIBUTE15", "REQUEST_ID", "PROGRAM_APPLICATION_ID", "PROGRAM_ID", "PROGRAM_UPDATE_DATE", "VAT_REGISTRATION_NUM", "AUTO_CALCULATE_INTEREST_FLAG", "VALIDATION_NUMBER", "EXCLUDE_FREIGHT_FROM_DISCOUNT", "TAX_REPORTING_NAME", "CHECK_DIGITS", "ALLOW_AWT_FLAG", "AWT_GROUP_ID" FROM PO_VENDORS

View Text - HTML Formatted

SELECT "VENDOR_ID"
, "LAST_UPDATE_DATE"
, "LAST_UPDATED_BY"
, "VENDOR_NAME"
, "SEGMENT1"
, "SUMMARY_FLAG"
, "ENABLED_FLAG"
, "SEGMENT2"
, "SEGMENT3"
, "SEGMENT4"
, "SEGMENT5"
, "LAST_UPDATE_LOGIN"
, "CREATION_DATE"
, "CREATED_BY"
, "EMPLOYEE_ID"
, "VENDOR_TYPE_LOOKUP_CODE"
, "CUSTOMER_NUM"
, "ONE_TIME_FLAG"
, "PARENT_VENDOR_ID"
, "MIN_ORDER_AMOUNT"
, "TERMS_ID"
, "SET_OF_BOOKS_ID"
, "ALWAYS_TAKE_DISC_FLAG"
, "PAY_DATE_BASIS_LOOKUP_CODE"
, "PAY_GROUP_LOOKUP_CODE"
, "PAYMENT_PRIORITY"
, "INVOICE_CURRENCY_CODE"
, "PAYMENT_CURRENCY_CODE"
, "INVOICE_AMOUNT_LIMIT"
, "HOLD_ALL_PAYMENTS_FLAG"
, "HOLD_FUTURE_PAYMENTS_FLAG"
, "HOLD_REASON"
, "NUM_1099"
, "TYPE_1099"
, "WITHHOLDING_STATUS_LOOKUP_CODE"
, "WITHHOLDING_START_DATE"
, "ORGANIZATION_TYPE_LOOKUP_CODE"
, "START_DATE_ACTIVE"
, "END_DATE_ACTIVE"
, "MINORITY_GROUP_LOOKUP_CODE"
, "WOMEN_OWNED_FLAG"
, "SMALL_BUSINESS_FLAG"
, "STANDARD_INDUSTRY_CLASS"
, "HOLD_FLAG"
, "PURCHASING_HOLD_REASON"
, "HOLD_BY"
, "HOLD_DATE"
, "TERMS_DATE_BASIS"
, "INSPECTION_REQUIRED_FLAG"
, "RECEIPT_REQUIRED_FLAG"
, "QTY_RCV_TOLERANCE"
, "QTY_RCV_EXCEPTION_CODE"
, "ENFORCE_SHIP_TO_LOCATION_CODE"
, "DAYS_EARLY_RECEIPT_ALLOWED"
, "DAYS_LATE_RECEIPT_ALLOWED"
, "RECEIPT_DAYS_EXCEPTION_CODE"
, "RECEIVING_ROUTING_ID"
, "ALLOW_SUBSTITUTE_RECEIPTS_FLAG"
, "ALLOW_UNORDERED_RECEIPTS_FLAG"
, "HOLD_UNMATCHED_INVOICES_FLAG"
, "TAX_VERIFICATION_DATE"
, "NAME_CONTROL"
, "STATE_REPORTABLE_FLAG"
, "FEDERAL_REPORTABLE_FLAG"
, "ATTRIBUTE_CATEGORY"
, "ATTRIBUTE1"
, "ATTRIBUTE2"
, "ATTRIBUTE3"
, "ATTRIBUTE4"
, "ATTRIBUTE5"
, "ATTRIBUTE6"
, "ATTRIBUTE7"
, "ATTRIBUTE8"
, "ATTRIBUTE9"
, "ATTRIBUTE10"
, "ATTRIBUTE11"
, "ATTRIBUTE12"
, "ATTRIBUTE13"
, "ATTRIBUTE14"
, "ATTRIBUTE15"
, "REQUEST_ID"
, "PROGRAM_APPLICATION_ID"
, "PROGRAM_ID"
, "PROGRAM_UPDATE_DATE"
, "VAT_REGISTRATION_NUM"
, "AUTO_CALCULATE_INTEREST_FLAG"
, "VALIDATION_NUMBER"
, "EXCLUDE_FREIGHT_FROM_DISCOUNT"
, "TAX_REPORTING_NAME"
, "CHECK_DIGITS"
, "ALLOW_AWT_FLAG"
, "AWT_GROUP_ID"
FROM PO_VENDORS