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

VIEW: APPS.IC_ITEM_MST_VL

Object Details
Object Name: IC_ITEM_MST_VL
Object Type: VIEW
Owner: APPS
FND Design Data: ViewGMI.IC_ITEM_MST_VL
Subobject Name:
Status: VALID

View Type

MultiLingual view (a language resolved view of the data.)


OPM Items MLS enabled View


[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
ROW_ID
ITEM_ID NUMBER (10) Yes ITEM_ID
ITEM_NO VARCHAR2 (32) Yes Item Number
ALT_ITEMA VARCHAR2 (32)
Alternate name for the item
ALT_ITEMB VARCHAR2 (32)
Second alternate name for the item
ITEM_UM VARCHAR2 (4) Yes Primary unit of measure of the item by which the inventory balances are maintained
DUALUM_IND NUMBER (5) Yes Dual unit of measure indicator. 0=Single UOM control, 1=Fixed relationship dual UOM control, 2=Variable relationship dual UOM control with default conversion displayed, 3= Variable relationship dual UOM control with default conversion not displayed
ITEM_UM2 VARCHAR2 (4)
Secondary unit of measure of the item by which the inventory balances are maintained for dual UOM items
DEVIATION_LO NUMBER
Yes Factor defining the allowable deviation below the standard conversion for dual UOM items with dualum_ind as 2 or 3
DEVIATION_HI NUMBER
Yes Factor defining the allowable deviation above the standard conversion for dual UOM items with dualum_ind as 2 or 3
LEVEL_CODE NUMBER (5)
Not currently used
LOT_CTL NUMBER (5) Yes Lot Control Indicator. 0=Not lot controlled, 1=Lot controlled
LOT_INDIVISIBLE NUMBER (5) Yes Indivisible indicator. 0=Lots are not indivisible (can be split), 1=Lots are indivisible (cannot be split).
SUBLOT_CTL NUMBER (5) Yes Sublot control indicator. 0=Not sublot controlled, 1=Sublot controlled. Used only if lot_ctl =1.
LOCT_CTL NUMBER (5) Yes Location control indicator. 0=Not location controlled, 1=Location controlled.
NONINV_IND NUMBER (5) Yes Noninventory indicator. 0=Not a noninventory item (inventory balances NONINV_IND = 0, Inventory Item. are maintained), 1=Noninventory item (inventory balances are not = 1, Non-Inventory Item. maintained).
MATCH_TYPE NUMBER (5) Yes Type of invoice matching done. Blank=No matching, 2=Two way matching, 3=Three way matching
INACTIVE_IND NUMBER (5) Yes Inactive indicator. 0=Active, 1=Inactive
INV_TYPE VARCHAR2 (4)
Inventory type. User defined
SHELF_LIFE NUMBER
Yes Shelf life. This number of days is added to lots of grade controlled items to calculate the expiration date.
RETEST_INTERVAL NUMBER
Yes Number of days specifying how often grade controlled items should be retested
GL_CLASS VARCHAR2 (8)
GL CLASS
INV_CLASS VARCHAR2 (8)
Inventory Class
SALES_CLASS VARCHAR2 (8)
SALES CLASS
SHIP_CLASS VARCHAR2 (8)
SHIP CLASS
FRT_CLASS VARCHAR2 (8)
Freight CLASS
PRICE_CLASS VARCHAR2 (8)
PRICE CLASS
STORAGE_CLASS VARCHAR2 (8)
STORAGE CLASS
PURCH_CLASS VARCHAR2 (8)
PURCHASE CLASS
TAX_CLASS VARCHAR2 (8)
TAX CLASS
CUSTOMS_CLASS VARCHAR2 (8)
CUSTOMS CLASS
ALLOC_CLASS VARCHAR2 (8)
ALLOCATION CLASS
PLANNING_CLASS VARCHAR2 (8)
PLANNING_CLASS
ITEMCOST_CLASS VARCHAR2 (8)
COST CLASS
COST_MTHD_CODE VARCHAR2 (4)
Not Currently used
UPC_CODE VARCHAR2 (16)
Not currently used
GRADE_CTL NUMBER (5) Yes Grade control indicator. 0=Not grade controlled, 1=Grade controlled
STATUS_CTL NUMBER (5) Yes Status control indicator. 0=Not status controlled, 1=Status controlled
QC_GRADE VARCHAR2 (4)
Default grade, for lots of grade controlled items
LOT_STATUS VARCHAR2 (4)
Default status, for lots of status controlled items.
BULK_ID NUMBER (10)
Not currently used
PKG_ID NUMBER (10)
Not currently used
QCITEM_ID NUMBER (10)
QC reference item
QCHOLD_RES_CODE VARCHAR2 (4)
QC hold reason code
EXPACTION_CODE VARCHAR2 (4)
Code for action to take when a lot expires
FILL_QTY NUMBER
Yes Not currently used
FILL_UM VARCHAR2 (4)
Not currently used
PLANNING_CATEGORY_ID NUMBER

PLANNING_CATEGORY_ID
PRICE_CATEGORY_ID NUMBER

PRICE_CATEGORY_ID
EXPACTION_INTERVAL NUMBER
Yes Interval between time lot expires and time expaction_code action should be taken.
PHANTOM_TYPE NUMBER (5) Yes Not currently used
WHSE_ITEM_ID NUMBER (10) Yes For sharing a common ps_whse_eff row
EXPERIMENTAL_IND NUMBER (5) Yes Experimental indicator. 0=Unrestricted use item (not experimental); 1=Experimental item (cannot be used in FM or PM).
EXPORTED_DATE DATE
Yes Date the item was exported to Oracle Financials
TRANS_CNT NUMBER (10)
Not currently used
DELETE_MARK NUMBER (5) Yes Standard: 0=Active record (default); 1=Marked for (logical) deletion
TEXT_CODE NUMBER (10)
ID which joins any rows of text in this table to the Text Table for this Module
SEQ_DPND_CLASS VARCHAR2 (8)
SEQUENCE DEPENDENT CLASS
COMMODITY_CODE VARCHAR2 (9)
Obsolete
ONT_PRICING_QTY_SOURCE NUMBER (5)
OM/OPM integration pricing by quantity 2 indicator - 0 indicates pricing by order quantity; 1 indicates pricing by secondary quantity
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
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
ITEM_ABCCODE VARCHAR2 (4)
ABC Code for the item
ALLOC_CATEGORY_ID NUMBER

ALLOC_CATEGORY_ID
CUSTOMS_CATEGORY_ID NUMBER

CUSTOMS_CATEGORY_ID
FRT_CATEGORY_ID NUMBER

FRT_CATEGORY_ID
GL_CATEGORY_ID NUMBER

GL_CATEGORY_ID
INV_CATEGORY_ID NUMBER

INV_CATEGORY_ID
COST_CATEGORY_ID NUMBER

COST_CATEGORY_ID
PURCH_CATEGORY_ID NUMBER

PURCH_CATEGORY_ID
SALES_CATEGORY_ID NUMBER

SALES_CATEGORY_ID
SEQ_CATEGORY_ID NUMBER

SEQ_CATEGORY_ID
SHIP_CATEGORY_ID NUMBER

SHIP_CATEGORY_ID
STORAGE_CATEGORY_ID NUMBER

STORAGE_CATEGORY_ID
TAX_CATEGORY_ID NUMBER

TAX_CATEGORY_ID
ITEM_DESC1 VARCHAR2 (70) Yes MLS Description of the item
ITEM_DESC2 VARCHAR2 (70)
MLS comments of the item
AUTOLOT_ACTIVE_INDICATOR NUMBER (1)
Indicates if autolot is active for the item.
LOT_PREFIX VARCHAR2 (32)
Prefix to be used for Autolot.
LOT_SUFFIX NUMBER (32)
Suffix to be used for Autolot.
SUBLOT_PREFIX VARCHAR2 (32)
Sublot Prefix to be used for Autolot.
SUBLOT_SUFFIX NUMBER (32)
Sublot Suffix to be used for Autolot.
Query Text

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


SELECT ROW_ID
,      ITEM_ID
,      ITEM_NO
,      ALT_ITEMA
,      ALT_ITEMB
,      ITEM_UM
,      DUALUM_IND
,      ITEM_UM2
,      DEVIATION_LO
,      DEVIATION_HI
,      LEVEL_CODE
,      LOT_CTL
,      LOT_INDIVISIBLE
,      SUBLOT_CTL
,      LOCT_CTL
,      NONINV_IND
,      MATCH_TYPE
,      INACTIVE_IND
,      INV_TYPE
,      SHELF_LIFE
,      RETEST_INTERVAL
,      GL_CLASS
,      INV_CLASS
,      SALES_CLASS
,      SHIP_CLASS
,      FRT_CLASS
,      PRICE_CLASS
,      STORAGE_CLASS
,      PURCH_CLASS
,      TAX_CLASS
,      CUSTOMS_CLASS
,      ALLOC_CLASS
,      PLANNING_CLASS
,      ITEMCOST_CLASS
,      COST_MTHD_CODE
,      UPC_CODE
,      GRADE_CTL
,      STATUS_CTL
,      QC_GRADE
,      LOT_STATUS
,      BULK_ID
,      PKG_ID
,      QCITEM_ID
,      QCHOLD_RES_CODE
,      EXPACTION_CODE
,      FILL_QTY
,      FILL_UM
,      PLANNING_CATEGORY_ID
,      PRICE_CATEGORY_ID
,      EXPACTION_INTERVAL
,      PHANTOM_TYPE
,      WHSE_ITEM_ID
,      EXPERIMENTAL_IND
,      EXPORTED_DATE
,      TRANS_CNT
,      DELETE_MARK
,      TEXT_CODE
,      SEQ_DPND_CLASS
,      COMMODITY_CODE
,      ONT_PRICING_QTY_SOURCE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      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
,      ITEM_ABCCODE
,      ALLOC_CATEGORY_ID
,      CUSTOMS_CATEGORY_ID
,      FRT_CATEGORY_ID
,      GL_CATEGORY_ID
,      INV_CATEGORY_ID
,      COST_CATEGORY_ID
,      PURCH_CATEGORY_ID
,      SALES_CATEGORY_ID
,      SEQ_CATEGORY_ID
,      SHIP_CATEGORY_ID
,      STORAGE_CATEGORY_ID
,      TAX_CATEGORY_ID
,      ITEM_DESC1
,      ITEM_DESC2
,      AUTOLOT_ACTIVE_INDICATOR
,      LOT_PREFIX
,      LOT_SUFFIX
,      SUBLOT_PREFIX
,      SUBLOT_SUFFIX
FROM APPS.IC_ITEM_MST_VL;

Dependencies

[top of page]

APPS.IC_ITEM_MST_VL references the following:

SchemaAPPS
SynonymIC_ITEM_MST_B
SynonymIC_ITEM_MST_TL
APPS.IC_ITEM_MST_VL is referenced by following:

SchemaAPPS
SynonymIC_ITEM_MST
ViewPMITS_ITEM_MASTER_V