DBA Data[Home] [Help]

APPS.EAM_ASSET_ATTR_PVT dependencies on CSI_ITEM_INSTANCES

Line 176: from csi_item_instances

172:
173: if (p_maintenance_object_id is not null) then
174: select serial_number,inventory_item_id
175: into l_serial_number,l_inventory_item_id
176: from csi_item_instances
177: where instance_id = p_maintenance_object_id;
178: else
179: l_inventory_item_id := p_inventory_item_id;
180: l_serial_number := p_serial_number;

Line 957: from csi_item_instances

953: -- API body
954: sql_stmt_num :=1;
955:
956: select instance_id into l_object_id
957: from csi_item_instances
958: where serial_number = p_serial_number_to
959: and inventory_item_id = p_inventory_item_id;
960:
961: