DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.PMI_LOT_SHARED_V

Object Details
Object Name: PMI_LOT_SHARED_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPMI.PMI_LOT_SHARED_V
Subobject Name:
Status: VALID

View Type

A Business Intelligence System view

[View Source]

Columns
Name Datatype Length Mandatory Comments
START_ITEM_ID NUMBER

item_id of the a start-lot
START_LOT_ID NUMBER
Yes lot_id of the start-lot
SHARED_ITEM_ID NUMBER

item_id of lot sharing ingredient lot with start-lot
SHARED_LOT_ID NUMBER
Yes lot_id of lot sharing ingredient lot with start lot
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
FROM APPS.PMI_LOT_SHARED_V;

Dependencies

[top of page]

APPS.PMI_LOT_SHARED_V references the following:

SchemaAPPS
SynonymPMI_LOT_GENEALOGY
ViewPMI_LOT_SOURCE_LEAF_V
APPS.PMI_LOT_SHARED_V is referenced by following:

SchemaAPPS
ViewPMIBV_LOT_SHARED_SHIP_V
ViewPMIFV_LOT_SHARED_ONHAND_V
ViewPMIFV_LOT_SHARED_SHIP_V