DBA Data[Home] [Help]

APPS.INV_LABEL_PVT10 dependencies on MTL_ITEM_REVISIONS

Line 73: MTL_ITEM_REVISIONS item_mir

69: item_poh. hazard_class,
70: item_mir.revision
71: FROM MTL_SYSTEM_ITEMS_KFV item,
72: PO_HAZARD_CLASSES item_poh,
73: MTL_ITEM_REVISIONS item_mir
74: WHERE item.organization_id = p_organization_id
75: AND item.inventory_item_id = p_inventory_item_id
76: AND item.hazard_class_id = item_poh.hazard_class_id (+)
77: AND item.organization_Id = item_mir.organization_id(+)