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


TABLE: GML.PO_VNIT_MST

Object Details
Object Name: PO_VNIT_MST
Object Type: TABLE
Owner: GML
FND Design Data: TableGML.PO_VNIT_MST
Subobject Name:
Status: VALID


Vendor Item Table not supported in OPM Purchasing; this table may be dropped in a future release.


Storage Details
Tablespace: TablespaceAPPS_TS_ARCHIVE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PO_VNIT_MST_PK NORMAL UNIQUE TablespaceAPPS_TS_ARCHIVE ColumnVENDOR_ID
ColumnITEM_ID
ColumnWHSE_CODE
Columns
Name Datatype Length Mandatory Comments
VENDOR_ID NUMBER (10) Yes Surrogate id for vendor from OPM Vendor Master table
ITEM_ID NUMBER (10) Yes Item id from Item Master in OPM
WHSE_CODE VARCHAR2 (4) Yes Warehouse code
LEAD_TIME NUMBER
Yes Number of days lead time required to purchase item in this warehouse
TIMELINESS_RATING NUMBER (5) Yes User-defined rating of vendor's timeliness for this item/warehouse
PRICE_RATING NUMBER (5) Yes User-defined price rating
PREFERENCE_RATING NUMBER (5) Yes User-defined preference rating
QUALITY_RATING NUMBER (5) Yes User-defined quality rating
MSDS_REQUIRED NUMBER (5) Yes Indicator if MSDS required
MSDS_VERSION_NO VARCHAR2 (32) Yes Version number of MSDS last sent
MSDS_ISSUANCE_DATE DATE
Yes Date of latest MSDS
DELETE_MARK NUMBER (5) Yes Indicates if record is logically deleted; 0 = active record; 1 = deleted record
CREATION_DATE DATE
Yes Standard who column
LAST_UPDATE_DATE DATE
Yes Standard who column
CREATED_BY NUMBER (15) Yes Standard who column
LAST_UPDATED_BY NUMBER (15) Yes Standard who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column
TEXT_CODE NUMBER (10)
ID which joins any rows of text in this table to the Text Table for this Module
TRANS_CNT NUMBER (10)
Not currently used
Query Text

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


SELECT VENDOR_ID
,      ITEM_ID
,      WHSE_CODE
,      LEAD_TIME
,      TIMELINESS_RATING
,      PRICE_RATING
,      PREFERENCE_RATING
,      QUALITY_RATING
,      MSDS_REQUIRED
,      MSDS_VERSION_NO
,      MSDS_ISSUANCE_DATE
,      DELETE_MARK
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      TEXT_CODE
,      TRANS_CNT
FROM GML.PO_VNIT_MST;

Dependencies

[top of page]

GML.PO_VNIT_MST does not reference any database object

GML.PO_VNIT_MST is referenced by following:

SchemaAPPS
SynonymPO_VNIT_MST