eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: APPS.POBV_SUPPLIERS

Object Details

Object Name:	POBV_SUPPLIERS
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PO.POBV_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

Name	Datatype	Length	Mandatory	Comments
SUPPLIER_ID	NUMBER		Yes
SUPPLIER_NAME	VARCHAR2	(240)
ALTERNATE_SUPPLIER_NAME	VARCHAR2	(320)
SUPPLIER_NUMBER	VARCHAR2	(30)	Yes
START_ACTIVE_DATE	DATE
END_ACTIVE_DATE	DATE
VAT_REGISTRATION_NUMBER	VARCHAR2	(20)
TAX_IDENTIFICATION_NUMBER	VARCHAR2	(20)
_LA:SUPPLIER_TYPE	CHAR	(74)
STANDARD_INDUSTRY_CLASS	VARCHAR2	(25)
_LA:ONE_TIME_FLAG	CHAR	(59)
_LA:MINORITY_GROUP	CHAR	(80)
_LA:SMALL_BUSINESS_FLAG	CHAR	(65)
_LA:WOMEN_OWNED_FLAG	CHAR	(62)
CUSTOMER_NUMBER	VARCHAR2	(25)
TAX_CALCULATION_LEVEL	VARCHAR2	(0)
ALLOW_TAX_CALC_OVERRIDE	VARCHAR2	(0)
TAX_ROUNDING_RULE	VARCHAR2	(0)
AMOUNT_INCLUDES_TAX_FLAG	VARCHAR2	(0)
_LA:FEDERAL_REPORTABLE_FLAG	CHAR	(69)
TYPE_OF_1099	VARCHAR2	(10)
_LA:STATE_REPORTABLE_FLAG	CHAR	(67)
TAX_REPORTING_METHOD	VARCHAR2	(80)
NAME_CONTROL	VARCHAR2	(4)
TAX_VERIFICATION_DATE	DATE
VALIDATION_NUMBER	NUMBER
_LA:ORGANIZATION_TYPE	CHAR	(86)
INVOICE_AMOUNT_LIMIT	NUMBER
_LA:HOLD_ALL_PAYMENTS	CHAR	(68)
_LA:HOLD_FUTURE_PAYMENTS	CHAR	(71)
_LA:HOLD_UNMATCHED_INVOICES	CHAR	(74)
HOLD_REASON	VARCHAR2	(240)
_LA:PAY_GROUP	CHAR	(70)
PAYMENT_PRIORITY	NUMBER
_LA:TERMS_DATE_BASIS	CHAR	(72)
_LA:PAY_DATE_BASIS	CHAR	(80)
PAYMENT_METHOD	VARCHAR2	(0)
_LA:ALWAYS_TAKE_DISCOUNT	CHAR	(67)
_LA:EXCL_FREIGHT_FROM_DISC	CHAR	(75)
_LA:ALLOW_INTEREST_INVOICES	CHAR	(74)
PAY_ALONE_FLAG	VARCHAR2	(0)
FREIGHT_TERMS	VARCHAR2	(0)
FREE_ON_BOARD_POINT	VARCHAR2	(0)
PURCHASING_HOLD_DATE	DATE
PURCHASING_HOLD_REASON	VARCHAR2	(240)
_LA:ENFORCE_SHIP_TO_LOCATION	CHAR	(92)
_LA:INVOICE_MATCHING	CHAR	(185)
QTY_RECEIVED_TOLERANCE	NUMBER
_LA:QTY_RECEIVED_EXCEPTION	CHAR	(85)
EARLY_RECEIPT_ALLOWED_DAYS	NUMBER
LATE_RECEIPT_ALLOWED_DAYS	NUMBER
_LA:ALLOW_SUBSTITUTE_RECEIPT	CHAR	(76)
_LA:ALLOW_UNORDERED_RECEIPT	CHAR	(75)
_LA:RECEIPT_DAYS_EXCEPTION	CHAR	(90)
_LA:ALLOW_WITHHOLDING_FLAG	CHAR	(60)
_LA:WITHHOLDING_STATUS_TYPE	CHAR	(88)
WITHHOLDING_START_DATE	DATE
EDI_PAYMENT_METHOD	VARCHAR2	(0)
EDI_PAYMENT_FORMAT	VARCHAR2	(0)
EDI_REMITTANCE_METHOD	VARCHAR2	(0)
EDI_REMITTANCE_INSTRUCTION	VARCHAR2	(0)
EDI_TRANSACTION_HANDLING	VARCHAR2	(0)
SUPPLIER_EMPLOYEE_ID	NUMBER
PARENT_SUPPLIER_ID	NUMBER
INVOICE_CURRENCY_CODE	VARCHAR2	(15)
PAYMENT_CURRENCY_CODE	VARCHAR2	(15)
HOLD_BY	NUMBER	(9)
PAYMENT_TERMS_ID	NUMBER
RECEIVING_ROUTING_ID	NUMBER
CREATED_DATE	DATE		Yes
CREATED_BY	NUMBER		Yes	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATED_DATE	DATE		Yes
LAST_UPDATED_BY	NUMBER		Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
BANK_CHARGE_BEARER	VARCHAR2	(1)
BANK_BRANCH_TYPE	VARCHAR2	(0)
MATCH_OPTION	VARCHAR2	(25)
FUTURE_DATED_PAYMENT_CCID	VARCHAR2	(0)
_LA:CREATE_DEBIT_MEMO_FLAG	CHAR	(68)
OFFSET_TAX_FLAG	VARCHAR2	(0)

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
,      SUPPLIER_EMPLOYEE_ID
,      PARENT_SUPPLIER_ID
,      INVOICE_CURRENCY_CODE
,      PAYMENT_CURRENCY_CODE
,      HOLD_BY
,      PAYMENT_TERMS_ID
,      RECEIVING_ROUTING_ID
,      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.POBV_SUPPLIERS;

Dependencies

[top of page]

APPS.POBV_SUPPLIERS references the following:

APPS: PO_VENDORS

APPS.POBV_SUPPLIERS is not referenced by any database object