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]

TABLE: GML.PO_VEND_MST

Object Details

Object Name:	PO_VEND_MST
Object Type:	TABLE
Owner:	GML
FND Design Data:	GML.PO_VEND_MST
Subobject Name:
Status:	VALID

The vendor master for OPM is updated via a database trigger from the Supplier entered in Oracle Purchasing. Vendor information can not be edited or viewed in OPM. Purchase orders transferred to OPM will reference the vendor number from OPM and stock receipts must contain a vendor number which can be looked up from the OPM vendor master. In addition to updating this table, the vendor relationships maintained in PO_VEND_ASC are also created when vendors are transferred from Oracle Purchasing.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PO_VEND_MSTI1	NORMAL	UNIQUE	APPS_TS_TX_IDX	CO_CODE VENDOR_NO
PO_VEND_MSTI2	NORMAL	UNIQUE	APPS_TS_TX_IDX	VENDOR_NO VENDSORT_NO VENDOR_NAME CO_CODE INACTIVE_IND DELETE_MARK
PO_VEND_MST_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	VENDOR_ID
PO_VEND_MSTI3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CO_CODE OF_VENDOR_SITE_ID
PO_VEND_MSTI4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CO_CODE OF_VENDOR_ID
PO_VEND_MST_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	OF_VENDOR_SITE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
VENDOR_ID	NUMBER	(10)	Yes	Surrogate key for vendor.
PHONE_NO	VARCHAR2	(20)		Phone number.
VENDOR_NO	VARCHAR2	(32)	Yes	Unique vendor number entered by user.
ALTVEND_NO	VARCHAR2	(32)		User entered code
VENDSORT_NO	VARCHAR2	(16)		Short name of the vendor
VENDOR_NAME	VARCHAR2	(40)	Yes	Vendor name
ADDR_ID	NUMBER	(10)		Fk to sy_addr_mst.
REMIT_NAME	VARCHAR2	(40)		Remit to name of the vendor
MAILADDR_ID	NUMBER	(10)		Fk to sy_addr_mst.
CO_CODE	VARCHAR2	(4)		Company for which the vendor number is defined. A blank value indicates the vendor is defined for all companies.
FAX_NO	VARCHAR2	(20)		Fax number.
TELEX_NO	VARCHAR2	(20)		Telex number.
DEFAULT_CURRENCY	VARCHAR2	(4)		Default curreny for a transaction. Fk to gl_curr_mst.
CHANGE_CURRENCY	NUMBER	(5)	Yes	Indicates whether the currency can be changed: 0 - default currency only; 1- other currencies are permited.
TIMELINESS_RATING	NUMBER	(5)		User entered timeliness of delivery rating.
PRICE_RATING	NUMBER	(5)		How the user rates the vendor prices.
MISC_RATING	NUMBER	(5)		Miscellaneous rating.
BUS_START_DATE	DATE			Date when the first busineess activity took place.
BUS_END_DATE	DATE			Date when the final business actity took place.
BUS_AMOUNT	NUMBER			Amount of business done with the vendor.
MIN_PURCHASE	NUMBER			The minimum amount that can be purchased on a single po.
APPROVED_IND	NUMBER	(5)	Yes	Indicates whether the vendor has been approved for purchases: 0 - orders not allowed; 1- order allowed. Restricts or permits entry of the vendor in po.
INACTIVE_IND	NUMBER	(5)	Yes	Indicates if the vendor is inactive: 0 - active; 1 - not active. If the vendor is not active a po cannot be created.
SHIP_IND	NUMBER	(5)	Yes	Indicates whether the vendor ships product: 0 - no; 1 - yes
PAYMENT_IND	NUMBER	(5)	Yes	Does this vendor receive payments for merchandice: 0 - no; 1 - yes
INFORM_GOVT	NUMBER	(5)	Yes	Is a 1099 issued: 0 - no; 1- yes
TAXABLE_IND	NUMBER	(5)	Yes	Is the vendor taxable: 0 - tax exempt; 1 - taxable
TERMS_CODE	VARCHAR2	(4)		Fk to op_term_mst
TERMS_VARY	NUMBER	(5)	Yes	Indicates whether the terms can vary on an order by order basis: 0 - no; 1 - yes
VENDOR_TYPE	NUMBER	(5)	Yes	0 - regular vendor; 1 - consignment vendor
SIC_CODE	VARCHAR2	(8)		User entered sic code - not validated
SPLC_CODE	VARCHAR2	(8)		User enterd splc code - not validated
FRTBILL_MTHD	VARCHAR2	(4)		Fk to op_ship_mth
CREDIT_LIMIT	NUMBER			Maximum credit limit granted by the vendor.
VEND_CLASS	VARCHAR2	(8)		Fk to po_vend_cls.
VENDTRADE_CLASS	VARCHAR2	(8)		Fk to po_vtrd_cls.
VENDGL_CLASS	VARCHAR2	(8)		Fk to po_vgld_cls.
OF_VENDOR_ID	NUMBER	(10)		Surrogate from Oracle Financials identifying the vendor.
OF_VENDOR_SITE_ID	NUMBER	(10)		Surrogate from Oracle Financials identifying the vendor.
CREATION_DATE	DATE		Yes	Standard who column
CREATED_BY	NUMBER	(15)	Yes	Standard who column
LAST_UPDATE_DATE	DATE		Yes	Standard who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column
TRANS_CNT	NUMBER	(10)		Not currently used
TEXT_CODE	NUMBER	(10)		ID which joins any rows of text in this table to the Text Table for this Module
DELETE_MARK	NUMBER	(5)	Yes	Standard: 0=Active record (default); 1=Marked for (logical) deletion.
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column
PROGRAM_APPLICATION_ID	NUMBER	(15)		Concurrent who column
PROGRAM_ID	NUMBER	(15)		Concurrent who column
PROGRAM_UPDATE_DATE	DATE			Concurrent who column
REQUEST_ID	NUMBER	(15)		Concurrent who column
ATTRIBUTE1	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE2	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE3	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE4	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE5	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE6	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE7	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE8	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE9	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE10	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE11	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE12	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE13	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE14	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE15	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE16	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE17	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE18	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE19	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE20	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE21	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE22	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE23	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE24	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE25	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE26	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE27	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE28	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE29	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE30	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfield segment

Query Text

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


SELECT VENDOR_ID
,      PHONE_NO
,      VENDOR_NO
,      ALTVEND_NO
,      VENDSORT_NO
,      VENDOR_NAME
,      ADDR_ID
,      REMIT_NAME
,      MAILADDR_ID
,      CO_CODE
,      FAX_NO
,      TELEX_NO
,      DEFAULT_CURRENCY
,      CHANGE_CURRENCY
,      TIMELINESS_RATING
,      PRICE_RATING
,      MISC_RATING
,      BUS_START_DATE
,      BUS_END_DATE
,      BUS_AMOUNT
,      MIN_PURCHASE
,      APPROVED_IND
,      INACTIVE_IND
,      SHIP_IND
,      PAYMENT_IND
,      INFORM_GOVT
,      TAXABLE_IND
,      TERMS_CODE
,      TERMS_VARY
,      VENDOR_TYPE
,      SIC_CODE
,      SPLC_CODE
,      FRTBILL_MTHD
,      CREDIT_LIMIT
,      VEND_CLASS
,      VENDTRADE_CLASS
,      VENDGL_CLASS
,      OF_VENDOR_ID
,      OF_VENDOR_SITE_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      TRANS_CNT
,      TEXT_CODE
,      DELETE_MARK
,      LAST_UPDATE_LOGIN
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REQUEST_ID
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      ATTRIBUTE21
,      ATTRIBUTE22
,      ATTRIBUTE23
,      ATTRIBUTE24
,      ATTRIBUTE25
,      ATTRIBUTE26
,      ATTRIBUTE27
,      ATTRIBUTE28
,      ATTRIBUTE29
,      ATTRIBUTE30
,      ATTRIBUTE_CATEGORY
FROM GML.PO_VEND_MST;

Dependencies

[top of page]

GML.PO_VEND_MST does not reference any database object

GML.PO_VEND_MST is referenced by following:

GML: PO_VEND_MST#