[Home] [Help] [Dependency Information]

VIEW: APPS.PMIFV_LOT_SOURCE_ONHAND_V

Object Details

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

View Type

A Business Intelligence System view

This view lists the onhand balances of all lot sources (ingredient lots) of a
product lot. The product lots on-hand balances are included, allowing for ALL
source quantities to be evaluated.

[View Source]

Columns

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
,      INGREDIENT_WAREHOUSE
,      INGREDIENT_LOCATION
,      INGREDIENT_LOCATION_ONHAND
,      INGREDIENT_LOC_ONHAND_UOM2
,      INGREDIENT_LOT_STATUS
,      INGREDIENT_ITEM_NO
,      INGREDIENT_ITEM_DESCRIPTION
,      INGREDIENT_ITEM_UOM
,      INGREDIENT_ITEM_UOM2
,      INGREDIENT_ITEM_INV_CLASS
,      INGREDIENT_ITEM_PLAN_CLASS
,      INGREDIENT_ITEM_SALES_CLASS
,      INGREDIENT_LOT_NO
,      INGREDIENT_SUBLOT_NO
,      PRODUCT_ITEM_NO
,      PRODUCT_ITEM_DESCRIPTION
,      PRODUCT_ITEM_UOM
,      PRODUCT_ITEM_UOM2
,      PRODUCT_LOT_NO
,      PRODUCT_SUBLOT_NO
FROM APPS.PMIFV_LOT_SOURCE_ONHAND_V;

Dependencies

[top of page]

APPS

IC_ITEM_MST

IC_LOCT_INV

IC_LOTS_MST

PMI_LOT_GENEALOGY

APPS.PMIFV_LOT_SOURCE_ONHAND_V is not referenced by any database object