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

Object Details

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

View Type

A Business Intelligence System view

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
PRODUCT_ITEM_ID	NUMBER			Product Item ID
PRODUCT_LOT_ID	NUMBER		Yes	Product Lot ID
INGREDIENT_ITEM_ID	NUMBER			Ingredient Item ID
INGREDIENT_LOT_ID	NUMBER		Yes	Ingredient Lot ID
PRODUCT_WAREHOUSE	VARCHAR2	(4)	Yes	Product Warehouse
PRODUCT_LOCATION	VARCHAR2	(16)	Yes	Product Location
PRODUCT_LOCATION_ONHAND	NUMBER		Yes	Product Location Onhand
PRODUCT_LOCATION_ONHAND_UOM2	NUMBER			Product Location Onhand UOM2
PRODUCT_LOT_STATUS	VARCHAR2	(4)		Product Lot Status
INGREDIENT_ITEM_NO	VARCHAR2	(32)	Yes	Ingredient Item Number
INGREDIENT_ITEM_DESCRIPTION	VARCHAR2	(70)	Yes	Ingredient Item Description
INGREDIENT_ITEM_UOM	VARCHAR2	(4)	Yes	Ingredient Item UOM
INGREDIENT_ITEM_UOM2	VARCHAR2	(4)		Ingredient Item UOM2
INGREDIENT_LOT_NO	VARCHAR2	(32)	Yes	Ingredient Lot Number
INGREDIENT_SUBLOT_NO	VARCHAR2	(32)		Ingredient Sublot Number
PRODUCT_ITEM_NO	VARCHAR2	(32)	Yes	Product Item Number
PRODUCT_ITEM_DESCRIPTION	VARCHAR2	(70)	Yes	Product Item Description
PRODUCT_ITEM_UOM	VARCHAR2	(4)	Yes	Product Item UOM
PRODUCT_ITEM_UOM2	VARCHAR2	(4)		Product Item UOM2
PRODUCT_ITEM_INV_CLASS	VARCHAR2	(8)		Product Item Inventory Class
PRODUCT_ITEM_PLAN_CLASS	VARCHAR2	(8)		Product Item Planning Class
PRODUCT_ITEM_SALES_CLASS	VARCHAR2	(8)		Product Item Sales Class
PRODUCT_LOT_NO	VARCHAR2	(32)	Yes	Product Lot Number
PRODUCT_SUBLOT_NO	VARCHAR2	(32)		Product Sublot Number

Query Text

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


SELECT PRODUCT_ITEM_ID
,      PRODUCT_LOT_ID
,      INGREDIENT_ITEM_ID
,      INGREDIENT_LOT_ID
,      PRODUCT_WAREHOUSE
,      PRODUCT_LOCATION
,      PRODUCT_LOCATION_ONHAND
,      PRODUCT_LOCATION_ONHAND_UOM2
,      PRODUCT_LOT_STATUS
,      INGREDIENT_ITEM_NO
,      INGREDIENT_ITEM_DESCRIPTION
,      INGREDIENT_ITEM_UOM
,      INGREDIENT_ITEM_UOM2
,      INGREDIENT_LOT_NO
,      INGREDIENT_SUBLOT_NO
,      PRODUCT_ITEM_NO
,      PRODUCT_ITEM_DESCRIPTION
,      PRODUCT_ITEM_UOM
,      PRODUCT_ITEM_UOM2
,      PRODUCT_ITEM_INV_CLASS
,      PRODUCT_ITEM_PLAN_CLASS
,      PRODUCT_ITEM_SALES_CLASS
,      PRODUCT_LOT_NO
,      PRODUCT_SUBLOT_NO
FROM APPS.PMIFV_LOT_DEST_ONHAND_V;

Dependencies

[top of page]

APPS.PMIFV_LOT_DEST_ONHAND_V references the following:

APPS: IC_ITEM_MST; IC_LOCT_INV; IC_LOTS_MST; PMI_LOT_GENEALOGY

APPS.PMIFV_LOT_DEST_ONHAND_V is not referenced by any database object