[Home] [Help] [Dependency Information]

VIEW: APPS.PMIFV_LOT_SHARED_ONHAND_V

Object Details

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

View Type

A Business Intelligence System view

This view lists the onhand balances of all product lots which share ingredient lots
with another product lot. This ingredient lots may be any number of levels removed
from the start-lot or on-hand lot.

[View Source]

Columns

Query Text

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

SELECT START_ITEM_ID
,      START_LOT_ID
,      SHARED_ITEM_ID
,      SHARED_LOT_ID
,      START_ITEM_NO
,      START_ITEM_DESCRIPTION
,      START_LOT_NO
,      START_SUBLOT_NO
,      SHARED_ITEM_NO
,      SHARED_ITEM_DESCRIPTION
,      SHARED_ITEM_UOM
,      SHARED_ITEM_UOM2
,      SHARED_INVENTORY_CLASS
,      SHARED_PLANNING_CLASS
,      SHARED_SALES_CLASS
,      SHARED_LOT_NO
,      SHARED_SUBLOT_NO
,      SHARED_ONHAND
,      SHARED_ONHAND_UOM2
,      SHARED_WAREHOUSE
,      SHARED_LOCATION
FROM APPS.PMIFV_LOT_SHARED_ONHAND_V;

Dependencies

[top of page]

APPS

IC_ITEM_MST

IC_LOCT_INV

IC_LOTS_MST

PMI_LOT_SHARED_V

APPS.PMIFV_LOT_SHARED_ONHAND_V is not referenced by any database object