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.PMITS_ITEM_MASTER_V

Object Details

Object Name:	PMITS_ITEM_MASTER_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PMI.PMITS_ITEM_MASTER_V
Subobject Name:
Status:	VALID

View Type

A Business Intelligence System view

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ITEM_ID	NUMBER	(10)	Yes	Surrogate key for the item
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
DUALUM_IND_DISP	VARCHAR2	(80)	Yes	Dual unit of measure indicator resolved using Lookup
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
LOT_CTL	NUMBER	(5)	Yes	Lot Control Indicator. 0=Not lot controlled, 1=Lot controlled
LOT_CTL_DISP	VARCHAR2	(80)		Lot Control Indicator resolved using Lookup
LOT_INDIVISIBLE	NUMBER	(5)	Yes	Indivisible indicator. 0=Lots are not indivisible (can be split), 1=Lots are indivisible (cannot be split).
LOT_INDIVISIBLE_DISP	VARCHAR2	(80)		Indivisible indicator resolved using Lookup
SUBLOT_CTL	NUMBER	(5)	Yes	Sublot control indicator. 0=Not sublot controlled, 1=Sublot controlled. Used only if lot_ctl =1
SUBLOT_CTL_DISP	VARCHAR2	(80)		Sublot control indicator resolved using lookup
LOCT_CTL	NUMBER	(5)	Yes	Location control indicator. 0=Not location controlled, 1=Location controlled
LOCT_CTL_DISP	VARCHAR2	(80)	Yes	Location control indicator resolved using lookup
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 maintained).
NONINV_IND_DISP	VARCHAR2	(80)		Noninventory indicator resolved using lookup
MATCH_TYPE	NUMBER	(5)	Yes	Type of invoice matching done. Blank=No matching, 2=Two way matching, 3=Three way matching
MATCH_TYPE_DISP	VARCHAR2	(80)	Yes	Type of invoice matching code resolved using lookup
INACTIVE_IND	NUMBER	(5)	Yes	Inactive indicator. 0=Active, 1=Inactive
INACTIVE_IND_DISP	VARCHAR2	(80)		Inactive indicator code resolved using lookup
INV_TYPE	VARCHAR2	(4)		Inventory type
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 for an item
INV_CLASS	VARCHAR2	(8)		Inventory Class for an item
SALES_CLASS	VARCHAR2	(8)		Sales Class for an item
SHIP_CLASS	VARCHAR2	(8)		Shipping Class for an item
FRT_CLASS	VARCHAR2	(8)		Freight Class for an item
PRICE_CLASS	VARCHAR2	(8)		Price Class for an item
STORAGE_CLASS	VARCHAR2	(8)		Storage Class for an item
PURCH_CLASS	VARCHAR2	(8)		Purchase Class for an item
TAX_CLASS	VARCHAR2	(8)		Tax Class for an item
CUSTOMS_CLASS	VARCHAR2	(8)		Customs class for an item
ALLOC_CLASS	VARCHAR2	(8)		Allocation class for an item. Used for auto-allocation
PLANNING_CLASS	VARCHAR2	(8)		Planning class for an item. Used for MPS and MRP reporting
ITEMCOST_CLASS	VARCHAR2	(8)		Cost class for an item
UPC_CODE	VARCHAR2	(16)		UPC Code
GRADE_CTL	NUMBER	(5)	Yes	Grade control indicator. 0=Not grade controlled, 1=Grade controlled
GRADE_CTL_DISP	VARCHAR2	(80)		Grade control indicator code resolved using lookup
STATUS_CTL	NUMBER	(5)	Yes	Status control indicator. 0=Not status controlled, 1=Status controlled
STATUS_CTL_DISP	VARCHAR2	(80)	Yes	Status control indicator code resolved using lookup
QC_GRADE	VARCHAR2	(4)		Default grade, for lots of grade controlled items
LOT_STATUS	VARCHAR2	(4)		Default status, for lots of status controlled items
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
PLANNING_CATEGORY_ID	NUMBER			Category Id for Planning Class
PRICE_CATEGORY_ID	NUMBER			Category Id for Price Class
EXPACTION_INTERVAL	NUMBER		Yes	Interval between time lot expires and time expaction_code action should be taken
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).
EXPERIMENTAL_IND_DISP	VARCHAR2	(80)	Yes	Experimental indicator code resolved using lookup
EXPORTED_DATE	DATE		Yes	Date the item was exported to Oracle Financials.
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)		reference code associated with a product class. Used for export/ importing among European countries
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
ITEM_ABCCODE	VARCHAR2	(4)		ABC Code for the item
ALLOC_CATEGORY_ID	NUMBER			Category Id for Allocation Class
CUSTOMS_CATEGORY_ID	NUMBER			Category Id for Customs Class
FRT_CATEGORY_ID	NUMBER			Category Id for Freight Class
GL_CATEGORY_ID	NUMBER			Category Id for GL Class
INV_CATEGORY_ID	NUMBER			Category Id for Inventory Class
COST_CATEGORY_ID	NUMBER			Category Id for Cost Class
PURCH_CATEGORY_ID	NUMBER			Category Id for Purchase Class
SALES_CATEGORY_ID	NUMBER			Category Id for Sales Class
SEQ_CATEGORY_ID	NUMBER			Category Id for SEQ Class
SHIP_CATEGORY_ID	NUMBER			Category Id for Shipping Class
STORAGE_CATEGORY_ID	NUMBER			Category Id for Storage Class
TAX_CATEGORY_ID	NUMBER			Category Id for Tax Class
ITEM_DESC1	VARCHAR2	(70)	Yes	MLS Description of the item
ITEM_DESC2	VARCHAR2	(70)		MLS comments of the item

Query Text

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


SELECT ITEM_ID
,      ITEM_NO
,      ALT_ITEMA
,      ALT_ITEMB
,      ITEM_UM
,      DUALUM_IND
,      DUALUM_IND_DISP
,      ITEM_UM2
,      DEVIATION_LO
,      DEVIATION_HI
,      LOT_CTL
,      LOT_CTL_DISP
,      LOT_INDIVISIBLE
,      LOT_INDIVISIBLE_DISP
,      SUBLOT_CTL
,      SUBLOT_CTL_DISP
,      LOCT_CTL
,      LOCT_CTL_DISP
,      NONINV_IND
,      NONINV_IND_DISP
,      MATCH_TYPE
,      MATCH_TYPE_DISP
,      INACTIVE_IND
,      INACTIVE_IND_DISP
,      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
,      UPC_CODE
,      GRADE_CTL
,      GRADE_CTL_DISP
,      STATUS_CTL
,      STATUS_CTL_DISP
,      QC_GRADE
,      LOT_STATUS
,      QCITEM_ID
,      QCHOLD_RES_CODE
,      EXPACTION_CODE
,      PLANNING_CATEGORY_ID
,      PRICE_CATEGORY_ID
,      EXPACTION_INTERVAL
,      WHSE_ITEM_ID
,      EXPERIMENTAL_IND
,      EXPERIMENTAL_IND_DISP
,      EXPORTED_DATE
,      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
,      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
FROM APPS.PMITS_ITEM_MASTER_V;

Dependencies

[top of page]

APPS.PMITS_ITEM_MASTER_V references the following:

APPS: GEM_LOOKUPS; IC_ITEM_MST_VL

APPS.PMITS_ITEM_MASTER_V is not referenced by any database object