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]

TABLE: PMI.PMI_LOT_GENEALOGY

Object Details

Object Name:	PMI_LOT_GENEALOGY
Object Type:	TABLE
Owner:	PMI
FND Design Data:	PMI.PMI_LOT_GENEALOGY
Subobject Name:
Status:	VALID

This table will store that product-ingredient which support the PMI Lot Genealogy Views. These associations cover both direct and indirect product-ingredient associations.

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PMI_LOT_GENEALOGY_PK	NORMAL	UNIQUE	APPS_TS_SUMMARY	PRODUCT_LOT_ID INGRED_LOT_ID
PMI_LOT_GENEALOGY_I2	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	INGRED_LOT_ID

Columns

Name	Datatype	Mandatory	Comments
PRODUCT_ITEM_ID	NUMBER		the item number of a lot that contains the ingredient lot
PRODUCT_LOT_ID	NUMBER	Yes	the lot number of a lot that contains the ingredient lot
INGRED_ITEM_ID	NUMBER		the item number of a lot that is contained in the product lot
INGRED_LOT_ID	NUMBER	Yes	the lot number of a lot that is containted in the produc lot
ASSOCIATION_COUNT	NUMBER		the number of physical associations for this distinct association

Query Text

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


SELECT PRODUCT_ITEM_ID
,      PRODUCT_LOT_ID
,      INGRED_ITEM_ID
,      INGRED_LOT_ID
,      ASSOCIATION_COUNT
FROM PMI.PMI_LOT_GENEALOGY;

Dependencies

[top of page]

PMI.PMI_LOT_GENEALOGY does not reference any database object

PMI.PMI_LOT_GENEALOGY is referenced by following:

APPS: PMI_LOT_GENEALOGY