[Home] [Help] [Dependency Information]

VIEW: APPS.AP_VENDORS_V

Object Details

Object Name:	AP_VENDORS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	SQLAP.AP_VENDORS_V
Subobject Name:
Status:	VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Query Text

Cut, paste (and edit) the following text to query this object:

SELECT ROW_ID
,      VENDOR_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      VENDOR_NAME
,      VENDOR_NUMBER
,      SUMMARY_FLAG
,      ENABLED_FLAG
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
,      EMPLOYEE_ID
,      VENDOR_TYPE_LOOKUP_CODE
,      VENDOR_TYPE_DISP
,      CUSTOMER_NUM
,      ONE_TIME_FLAG
,      PARENT_VENDOR_ID
,      PARENT_VENDOR_NAME
,      PARENT_VENDOR_NUMBER
,      TERMS_ID
,      TERMS_NAME
,      SET_OF_BOOKS_ID
,      ALWAYS_TAKE_DISC_FLAG
,      PAY_DATE_BASIS_LOOKUP_CODE
,      PAY_DATE_BASIS_DISP
,      PAY_GROUP_LOOKUP_CODE
,      PAY_GROUP_DISP
,      PAYMENT_PRIORITY
,      INVOICE_CURRENCY_CODE
,      INVOICE_AMOUNT_LIMIT
,      HOLD_ALL_PAYMENTS_FLAG
,      HOLD_FUTURE_PAYMENTS_FLAG
,      HOLD_REASON
,      NUM_1099
,      TYPE_1099
,      TYPE_1099_DISP
,      WITHHOLDING_STATUS_LOOKUP_CODE
,      WITHHOLDING_STATUS_DISP
,      WITHHOLDING_START_DATE
,      ORGANIZATION_TYPE_LOOKUP_CODE
,      ORGANIZATION_TYPE_DISP
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      QTY_RCV_TOLERANCE
,      MINORITY_GROUP_LOOKUP_CODE
,      MINORITY_GROUP_DISP
,      WOMEN_OWNED_FLAG
,      SMALL_BUSINESS_FLAG
,      STANDARD_INDUSTRY_CLASS
,      PURCHASING_HOLD_REASON
,      HOLD_FLAG
,      HOLD_BY
,      HOLD_DATE
,      TERMS_DATE_BASIS
,      DAYS_EARLY_RECEIPT_ALLOWED
,      DAYS_LATE_RECEIPT_ALLOWED
,      ENFORCE_SHIP_TO_LOCATION_CODE
,      ENFORCE_SHIP_TO_LOCATION_DISP
,      FEDERAL_REPORTABLE_FLAG
,      HOLD_UNMATCHED_INVOICES_FLAG
,      INSPECTION_REQUIRED_FLAG
,      RECEIPT_REQUIRED_FLAG
,      INVOICE_MATCHING_FLAG
,      RECEIVING_ROUTING_ID
,      RECEIVING_ROUTING_NAME
,      STATE_REPORTABLE_FLAG
,      TAX_VERIFICATION_DATE
,      AUTO_CALCULATE_INTEREST_FLAG
,      NAME_CONTROL
,      ALLOW_SUBSTITUTE_RECEIPTS_FLAG
,      ALLOW_UNORDERED_RECEIPTS_FLAG
,      RECEIPT_DAYS_EXCEPTION_CODE
,      RECEIPT_DAYS_EXCEPTION_DISP
,      QTY_RCV_EXCEPTION_CODE
,      QTY_RCV_EXCEPTION_DISP
,      EXCLUDE_FREIGHT_FROM_DISCOUNT
,      VAT_REGISTRATION_NUM
,      TAX_REPORTING_NAME
,      ATTRIBUTE_CATEGORY
,      PROGRAM_UPDATE_DATE
,      PROGRAM_ID
,      PROGRAM_APPLICATION_ID
,      REQUEST_ID
,      PAYMENT_CURRENCY_CODE
,      AWT_GROUP_ID
,      AWT_GROUP_NAME
,      CHECK_DIGITS
,      ALLOW_AWT_FLAG
,      VALIDATION_NUMBER
,      MIN_ORDER_AMOUNT
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      VENDOR_TYPE_EXP_DATE
,      TERMS_EXP_DATE
,      PAY_GROUP_EXP_DATE
,      MINORITY_GROUP_EXP_DATE
,      QTY_RCV_EXP_DATE
,      VENDOR_NAME_ALT
,      BANK_CHARGE_BEARER
,      GLOBAL_ATTRIBUTE_CATEGORY
,      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
,      MATCH_OPTION
,      CREATE_DEBIT_MEMO_FLAG
,      NI_NUMBER
FROM APPS.AP_VENDORS_V;

Dependencies

[top of page]

APPS

AP_AWT_GROUPS

AP_INCOME_TAX_TYPES

AP_TERMS

FND_GLOBAL - show dependent code

PO_AGENTS

PO_LOOKUP_CODES

PO_VENDORS

RCV_ROUTING_HEADERS

APPS

ITG_SYNCSUPPLIERINBOUND_PVT - show dependent code