[Home] [Help] [Dependency Information]

VIEW: APPS.POFV_SUPPLIERS

Object Details

Object Name:	POFV_SUPPLIERS
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PO.POFV_SUPPLIERS
Subobject Name:
Status:	VALID

View Type

A Business Intelligence System view

This shows external organizations that provide goods and services to an internal organization.

[View Source]

Columns

Query Text

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

SELECT SUPPLIER_ID
,      SUPPLIER_NAME
,      ALTERNATE_SUPPLIER_NAME
,      SUPPLIER_NUMBER
,      START_ACTIVE_DATE
,      END_ACTIVE_DATE
,      VAT_REGISTRATION_NUMBER
,      TAX_IDENTIFICATION_NUMBER
,      _LA:SUPPLIER_TYPE
,      STANDARD_INDUSTRY_CLASS
,      _LA:ONE_TIME_FLAG
,      _LA:MINORITY_GROUP
,      _LA:SMALL_BUSINESS_FLAG
,      _LA:WOMEN_OWNED_FLAG
,      CUSTOMER_NUMBER
,      TAX_CALCULATION_LEVEL
,      ALLOW_TAX_CALC_OVERRIDE
,      TAX_ROUNDING_RULE
,      AMOUNT_INCLUDES_TAX_FLAG
,      _LA:FEDERAL_REPORTABLE_FLAG
,      TYPE_OF_1099
,      _LA:STATE_REPORTABLE_FLAG
,      TAX_REPORTING_METHOD
,      NAME_CONTROL
,      TAX_VERIFICATION_DATE
,      VALIDATION_NUMBER
,      _LA:ORGANIZATION_TYPE
,      INVOICE_AMOUNT_LIMIT
,      _LA:HOLD_ALL_PAYMENTS
,      _LA:HOLD_FUTURE_PAYMENTS
,      _LA:HOLD_UNMATCHED_INVOICES
,      HOLD_REASON
,      _LA:PAY_GROUP
,      PAYMENT_PRIORITY
,      _LA:TERMS_DATE_BASIS
,      _LA:PAY_DATE_BASIS
,      PAYMENT_METHOD
,      _LA:ALWAYS_TAKE_DISCOUNT
,      _LA:EXCL_FREIGHT_FROM_DISC
,      _LA:ALLOW_INTEREST_INVOICES
,      PAY_ALONE_FLAG
,      FREIGHT_TERMS
,      FREE_ON_BOARD_POINT
,      PURCHASING_HOLD_DATE
,      PURCHASING_HOLD_REASON
,      _LA:ENFORCE_SHIP_TO_LOCATION
,      _LA:INVOICE_MATCHING
,      QTY_RECEIVED_TOLERANCE
,      _LA:QTY_RECEIVED_EXCEPTION
,      EARLY_RECEIPT_ALLOWED_DAYS
,      LATE_RECEIPT_ALLOWED_DAYS
,      _LA:ALLOW_SUBSTITUTE_RECEIPT
,      _LA:ALLOW_UNORDERED_RECEIPT
,      _LA:RECEIPT_DAYS_EXCEPTION
,      _LA:ALLOW_WITHHOLDING_FLAG
,      _LA:WITHHOLDING_STATUS_TYPE
,      WITHHOLDING_START_DATE
,      EDI_PAYMENT_METHOD
,      EDI_PAYMENT_FORMAT
,      EDI_REMITTANCE_METHOD
,      EDI_REMITTANCE_INSTRUCTION
,      EDI_TRANSACTION_HANDLING
,      _DF
,      SUPPLIER_EMPLOYEE_ID
,      SUPPLIER_EMPLOYEE_NUMBER
,      SUPPLIER_EMPLOYEE_NAME
,      PARENT_SUPPLIER_ID
,      PARENT_SUPPLIER_NAME
,      INVOICE_CURRENCY_CODE
,      INVOICE_CURRENCY_NAME
,      PAYMENT_CURRENCY_CODE
,      PAYMENT_CURRENCY_NAME
,      HOLD_BY
,      HOLD_BY_EMPLOYEE_NUMBER
,      HOLD_BY_EMPLOYEE_NAME
,      PAYMENT_TERMS_ID
,      PAYMENT_TERMS_NAME
,      RECEIVING_ROUTING_ID
,      RECEIVING_ROUTING_NAME
,      CREATED_DATE
,      CREATED_BY
,      LAST_UPDATED_DATE
,      LAST_UPDATED_BY
,      BANK_CHARGE_BEARER
,      BANK_BRANCH_TYPE
,      MATCH_OPTION
,      FUTURE_DATED_PAYMENT_CCID
,      _LA:CREATE_DEBIT_MEMO_FLAG
,      OFFSET_TAX_FLAG
FROM APPS.POFV_SUPPLIERS;

Dependencies

[top of page]

APPS

AP_TERMS

FND_CURRENCIES_VL

HR_GENERAL - show dependent code

HR_PERSON_NAME - show dependent code

HR_SECURITY - show dependent code

PER_PEOPLE_F

PO_VENDORS

RCV_ROUTING_HEADERS

APPS.POFV_SUPPLIERS is not referenced by any database object